View Incident Report

Minor

Reported By: Jakk
Reported On: 11/30/2004
For: Version 4.15 Build 1

# 1916 Assigning a Word Value to the TDBISAMParam Value Property Does Not Work in Delphi 6 and Higher

I'm using dynamic sql. The following does not work and generates the error:

'DBISAMQuery1:Field 'custno' is of an unknown type'

Query1.SQL.Text := 'select * from customer where custno = :custno';
Query1.Prepare;
Query1.Params.ParamByname('CustNo').Value := 1234;
Query1.Open;

Comments and Workarounds

The workaround is to use the AsInteger property instead or cast the value to an integer during the assignment to the Value property.

Resolution

Fixed Problem on 12/7/2004 in version 4.16 build 1

More Support Options