Hello all,
I'm attempting to find the property (if it exists) where I can check to see
how many rows were affected during an UPDATE. An equivalent would be
@@ROWCOUNT in SQL Server, etc...
As an example:
UPDATE tablefoo
SET foo1 = 'spork'
WHERE foo2 = 'goomba'
IF @@ROWCOUNT = 0 INSERT INTO tablefoo . . . .
And, so on...
TIA,
-Jason