Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

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

edited October 2016 in DADE
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

Comments

  • edited October 2016
    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.