Strange WHERE-statement in rtm
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
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
This discussion has been closed.
Comments
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