ProC : UPDATE...SET...RETURNING...INTO...allowed?
From: <kerbiquet_at_hotmail.com>
Date: 2000/04/11
Message-ID: <8cvejj$pfi$1_at_nnrp1.deja.com>#1/1
Date: 2000/04/11
Message-ID: <8cvejj$pfi$1_at_nnrp1.deja.com>#1/1
Is the following statement valid in Pro*C?
UPDATE quantieme SET nuqmes=nuqmes+1
WHERE dmaj=to_date(:date_quant,'DD-MON-YYYY')
RETURNING nuqmes INTO :val_quant;
If not, is there a way to update a table and return the updated value in one SQL statement?
Thanks,
Pierre
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Apr 11 2000 - 00:00:00 CEST