This is the second time I’ve encountered this, I have no idea what’s causing or how / why it’s happening. I have an import script which reads in a data file and makes a series of inserts into my mySql db. After all is said in done I run an update which combines data from two tables into one. Well, the update query works but it doesn’t actually run when I have it in my code sequence.
My fix for this previously was to use a delay, but that’s retarded.
So I’ll basically do:
INSERT
INSERT
INSERT
UPDATE
The update never runs. Has anyone else run into this issue? Is there something I should do with table locking? If I run the UPDATE function after the fact it works but it won’t work in sequence.
Thanks.
Okay, it looks like I had a second UPDATE that was reverting my first.
I was comparing two strings with [string] <> [string], which shouldn’t be a problem .. but when I changed it to [string] NOT LIKE [string] everything was fine.