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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
