TMyQuery (No SQL Statement Provided)

[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

[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.

[vga]

change TMyQuery.SQL := 'SQL Statement'
to TMyQuery.SQL.text := 'SQL Statement'


ok?