conflict-free SQL statements

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am running a script that reads a large amount of data from a ODBC-Link
into a new table, then deletes a target-table and copies the new table into
the target.

I often get corrupt results that can be recovered by repairing the table.
I assume that the second process starts before the first has finished.
Any idea how to prevent this? Do I have to lock the tables? I know that no
other process is writing into the tables however.



Re: conflict-free SQL statements

you do not give specifics about your environment and it is unclear what two
processes you are referring to.

in general, to enable mutual exclusion on a resource use one of the OS
synchronisation objects.


Quoted text here. Click to load it

Site Timeline