Closing a query

[ndevriendt]

Hello,

I'm new in Delphi and I want to use a query multiple times.
I'm using Microsoft SQL Server 2000 as database.

I use the following code:


if ADOMenus.active then ADOMenus.active := false;
ADOMenus.SQL.Text := SQLString;
ADOMenus.active := true;

SQL string contains a simple select statement.
He gives me the following error on the line adomenus.active := false;

'Project GMS.exe raised exception class EOleException with
message 'Either BOF of EOF is True, or the current record
has been deleted. Requested operation requires a current record'. Process stopped£. Use Step or Run to continue'.

Can somebody explain this error.

Thanks for your time and answer

Devriendt Nico

 

[Otto]

Delphi has compatibility problems with the newer MDAC. Try to install the "ADO Update Pack" (download it from the Borland's website), and recompile your code.

Otto