ADOQuery Select Statement with no result
Posted on 2003-03-17
When i write for example:
ADOQuery->SQL->ADD(select * from TABLE_NAME;")
my aplication is working fine. There is a set o records witch is returned from the SQL Server to my aplication.
The problem appears when executing select statement on the Server returns no result, for example
Of corse this statement returns 0 rows.
Then if I try to exec another select statement (that returns some rows this time) I have this:
" Eof or Bof are set to true or Current Record have been deleted. This operation requires current record"
My application is going crush :(
Even command ADOQuery->Close() cases this error.
Of corse if no set of rows was returned by SQL select statement,bof and eof are set to true, and I can't
have current record.
But why i can't use this ADOQuery component to another SQL select statemnets and work with any problem?
I'm not very expirienced in database-appliacation programming and this is serious problem for me.
If You know answer for my question, please help me.
Thank You very much