November 18, 2005 at 3:08 am
Guys & girlz of course 😉
Having troubles using the query analyzer. I ran an update query in my QA window. 179 rows affected. I select those rows and the date seems to have changed. But when I look into my erp system the data is not changed.
I had to close the QA window, reopen it and run the update query again. Then the data is changed.
We have had this problem several times now.
Anybody has any idea ?
Thx El Jefe
JV
November 18, 2005 at 7:04 am
The only time I had something like this is when I had 'Set implicit_transactions' ticked in Options / Connection properties
This tells QA to start a transaction when you connect which would give you the symptom you describe but then you would have got a message to confirm the transaction when you quit QA
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply