SQL Optimization : select * from mytable where 'c' <> 'c'

rbuser

RB17 & Delphi 10 Berlin

Hello,
even if i compile with RELEASE compilator option
all of my reports send severals "select * from mytable where 'c' <> 'c' "

what can i do to remove these SQL instructions
regards
Julien bertano

nicocizik

Hi Julien,

Many ReportBuilder DADE plugins use this SQL command to obtain your
table field names. This command should return 0 records and execute
fairly quickly and is the only way in many cases to get a list of your
field names so they can be accessed in DADE.

Depending on which plugin your are using, check the
TdaXXXDataset.SetDataName routine for where this is done. Some data
access components offer more optimized methods such as Interbase Express.