Re: # of Rows updated?

Hi Joe,

If I remembered correctly, both RDO and ADO's Connection.Excute method should returns the RecordsAffected in its second argument. Have a try pls.

Tony
<jgotthelf_at_my-deja.com> wrote in message news:8on3kn$4nc$1_at_nnrp1.deja.com...
> 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 - 23:11:15 CDT