Update and Return

Update and Return

goodkarma
Newbie
Posts: 1
Threads: 1
Joined: Feb 2015
Reputation: 0

02-19-2015, 11:57 AM

Is there a way to update a column in a table and return the new value for use in the php program? In other words, combining the two statements below:

UPDATE TABLE
SET SEQ = SEQ+1
WHERE FIELD = 'NEXTINV '

SELECT SEQ
FROM TABLE

Messages In This Thread

Update and Return - by goodkarma - 02-19-2015, 11:57 AM

RE: Update and Return - by dbui - 02-19-2015, 09:12 PM

RE: Update and Return - by Wouter60 - 02-20-2015, 04:49 AM

RE: Update and Return - by Nichiren - 02-23-2015, 06:30 AM