Connection is busy with results for another hstmt

[Karen99]

I am working on Sql Server 2000 and Delphi 3. When I try to open a table :

Table1.open;

I get the following error message :

Connection is busy with results for another hstmt.

What does this mean ? What does hstmt mean ?

Please help

Karen

 

[satishtiru]

This you will get if you are accessing database before you close the previous recordset. This mostly you see when you have multiple threads.

To fix this: synchronize the call to database such that you will not open two recordsets at any time on the same database or have a seperate database connection

Thanks,

 

[hilfy]

The other thing you need to make sure of is that your table component is not "Active" in the IDE. You will ALWAYS want to explicitly open and close your tables in code and NOT through the Active property of the component in the IDE.

-D