Put your update in an stored procedure and return a value you're after..
Alan

-----Original Message-----
From: Sandor Szollosi <ssani@...> [mailto:ssani@...]
Sent: Tuesday, 31 December 2002 9:14 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] (unknown)


Hi Folks! Happy New Year!

Is there a way to get returning values at update?
For example:
UPDATE MYTABLE SET AGE=20 WHERE ID=5
I'd like to know MYTABLE.NAME value in this record.

TIA:

Sandor
FB1.0,W2k




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/