Icon View Incident Report

Minor Minor
Reported By: Brian Martin
Reported On: 4/19/2021
For: Version 4.49 Build 4
# 4828 Using a 4.49 Client Application Accessing a 4.48 Database Server Can Cause Parameter Errors

I have Delphi 10.4.2 installed and have just loaded DBISAM 4.49 build 4 into it and have a parameterised query problem

Query used is below … where InsFieldType field is a string … and this is throwing an exception

I have tried defining the DataType to ftString … and setting an actual pre-defined Value / Type at design time and it throws an EDatabaseError with 'DBISAMQuery2: Field 'InsFieldType' is of an unknown type'

This error is so raised for Memo parameters … I changed the query so both parameters were integers and that works fine

UPDATE InspectDataEnginrs 
SET InsFieldType= :InsFieldType
WHERE InspectDataID =:InspectDataID



Comments Comments
The problem was that the client was overriding the data type of parameters that weren't receiving parameter information back from the 4.48 database server that was not automatic populating the parameter types (this feature was added in 4.48).


Resolution Resolution
Fixed Problem on 4/20/2021 in version 4.49 build 5


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image