View Incident Report

Serious

Reported By: Hannes Bischof
Reported On: 12/7/2020
For: Version 4.49 Build 3

# 4793 ODBC Driver Incorrectly Resetting SQL Statement Parameters During Statement Preparation

The parameters don't work. If I make a SELECT-Statement in the test project I sent you, it works fine and returns one result. But if I use parameters, it returns an empty table/no result.

tmpOdbcCommand.CommandText = "SELECT  Option1 FROM Einstellungen WHERE Optionsname = ?"; 
tmpOdbcCommand.Parameters.AddWithValue("?OptionsName", "MandantFirmenname");

Comments

The problem was with the new automatic parameter population added in 4.48. If parameters were manually added to a statement before the statement was prepared, then the preparation functionality would reset the parameters back to the default values set up during the automatic parameter population. Now the automatic parameter population only adds any new parameters that haven't already been defined (by parameter position).

Resolution

Fixed Problem on 12/7/2020 in version 4.49 build 4

Products Affected

DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap