Icon View Incident Report

Serious 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 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 Resolution
Fixed Problem on 12/7/2020 in version 4.49 build 4


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

Image