EOF error when closing ADOQuery!

[jcfrasco]

I created a program that uses an ADOQuery object to attach to SQL Server 2000. It retrieves a list of tools and displays them in a grid. The user has the ability to type in a specific tool ID and with each OnChange event of the text box I close the ADOQuery object and set the SQL to search for records that start with that letter and any additional letters after each one is typed. The drill down works well until no records are found and the recordset is at EOF. This causes an error because it will not allow me to close the ADOQuery object to reset it if it is set to EOF. How can I overcome this obstacle or rewrite it to be more resource friendly.

I appreciate any help in this matter.

jcfrasco

 

[michaenh]

Maybe something like this.. ?

ADOQuery.SQL.Clear;
SQL := 'bla..bla...';
ADOQuery.SQL.Text := SQL;
ADOQuery.Active := True;

if not ADOQuery.IsEmpty then
//do something
else
//free