🚀 go-pugleaf

Be sure you are not on client-side cursor - on client cursor all rows are
cached. Check that cursor type is adOpenDynamic or adOpenKeyset.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Thomas Wagener" <Thomas.Wagener@web.de> �������/�������� � ��������
���������: news:3cedf0d8$1_1@dnews...
> Hi,
>
> I have a problem concerning the sychronisation of ADOConnections in
> different threads. When I call a delete statement (via a TADOCommand) on a
> table, a query in a different thread is still giving back the deleted
record
> set. The application works on a user database. When I delete a user in one
> thread the username is still displayed in the other, although I obtain the
> user list definitely after the first command was executed.
> Each thread holds a TADOConnection that is only closed but not destroyed
> between the queries on the database. I suspect that the caches of the
> connections are not updated properly. Is there a magic parameter for
> TADOConnection that might remedy this problem, do I have to destroy the
> connection after each query, or am I completely on the wrong track? I am
> using CBuilder 5.
>
> Any suggestions,
>
> Thomas
>
>