Page 1 of 1

TMyQuery (No SQL Statement Provided)

Posted: Thu 05 Nov 2009 11:54
by vladimirwilson
hi Guys,

i am getting an error from TMyQuery (No SQL Statement Provide)

according to my logs it appear to happen after counting the records... here is a brief example of the code:

TMyQuery.SQL := 'SQL Statement'

while not TMyQuery1.EOF do
begin
TMyQuery1.SQL := 'SQL Statement'

if TMyQuery1.RecordCount > 0 then
DoSomenthing

end;
i know the error is very clear, but i do not understand why its happening...

Can you guys give me any sugestions?

Thank you,
Vladimir

Posted: Thu 05 Nov 2009 12:06
by Dimon
This means that the TMyQuery.SQL property is empty.
Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Posted: Fri 13 Nov 2009 22:48
by vga
change TMyQuery.SQL := 'SQL Statement'
to TMyQuery.SQL.text := 'SQL Statement'


ok?