Icon View Incident Report

Minor Minor
Reported By: Marc Pelletier
Reported On: 6/28/2006
For: Version 4.24 Build 1
# 2205 Using a Parameter for an SQL Table Name Causes AV

I am creating a query at runtime and associating it with a database in a datamodule. The database directory is also dynamic.

I create the query like below and before opening it. I make sure the dbImages db has the appropriate directory set by doing
dbImages.Close;
dbImages.Directory := fImagePath;

When I subsequently open the table I get a access error at a very low address (8db), which implies something isn't being initialized properly.

function TdmFPLink.CreateImageQuery( ): TDBIsamQuery;
begin
 result := TDBISAMQuery.Create( self);

 // dbImages is a DBIsamDatabase
 result.DatabaseName := dbImages.DatabaseName;

 result.SQL.Add( 'Select Image, Time from :TableName where Flight = :Flt 
' );
 result.SQL.Add( 'and Time >= :StartTime and Time <= :EndTime ' );
 result.SQL.Add( 'order by Time' );

end;



Comments Comments
The problem was with the parameter being used for a table name.


Resolution Resolution
Fixed Problem on 6/30/2006 in version 4.25 build 1


Products Affected Products Affected
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image