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

Strange WHERE-statement in rtm

edited February 2009 in DADE
Hi,

Lately, I find some strange WHERE-statements in my rtm's (I'm using
Delphi2007 with RB 10.09).

I'm sure I'm not using any WHERE-statement but in the rtm I find:

WHERE ('#39'c'#39' <> '#39'c'#39')

Is this normal? The reports seem to work fine.

Any comments,

TIA, Ronald

Comments

  • edited February 2009

    The SQL will be regenerated prior to the report generating.

    That Where clause condition is used internally by RB to validate the SQL
    against the database engine without selecting any records. Not sure why it
    is being saved down, but it won't hurt anything.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.