View Incident Report

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

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

Resolution

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

Products Affected

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap