Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mical55
Starting Member
1 Post |
 Posted - 2008-07-21 : 10:29:55
|
| I’m using an Access front End App that passes through 2 references in an UPDATE statement via a pass through query to a table in SQL svr 2005:Using a simple query to change one field on a particular record and the record seems to disappear after trying to update it. Meaning if I then search for the record it returns no results. Doing exactly the same search half an hour later it then returns the record.The update works 9 times out of 10.Example query:UPDATE PRINTQUEUE SET PQ_PRINTEDFLAG = 0, PQ_STATUSDESC = 'RE-PRINT REQUESTED ', PQ_STATUSDATE = GETDATE(), PQ_PRINTERID = 'pdfFactory' WHERE PRINTQUEUE.PQ_DOCUMENTNO='27036' AND PRINTQUEUE.PQ_JOBREFERENCE='G/20681' ;Thanks. Mic |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2008-07-21 : 19:25:47
|
| Are there any triggers on the table? Just thinking that it might be moved to a history table or something once it's been updated.... |
 |
|
|
|
|
|
UPDATE query makes record invisible?