# of Rows updated?

Hi,

I am trying to determine, VIA ODBC from VB how many rows are affected by an UPDATE statement, I.E. I send, via pass through:

update table set value=x where key=yy

And I want to know how many rows were affected (1 or 0) - reason for this is to detect dirty reads.

In SQL Server I can "select @@rowcount" - but this does not work in Oracle. Any suggestions on how I can either:

1. Find out how many rows were affected by the UPDATE statement, or
2. More generally - find out if I ran into a dirty read situation.?

Joe G.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 31 2000 - 21:18:13 CDT