🚀 go-pugleaf

Thomas,

Don't know of any magic parameters.  You might want to put the delete in a
transaction and commit it when done.  Also, use thread synchronization via
semaphores or critical sections.

- Arnie

"Thomas Wagener" <Thomas.Wagener@web.de> wrote in message
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
>
>