Re: Rows affected?
Thanks for
the responses.
I greatly appreciate it.
"rkusenet" <usenet.rk@gmail.com>
03/10/2005 03:17 PM
To
<Darren_Jacobs@carmax.com>
cc
Subject
Re: Rows affected?
select dbinfo('sqlca.sqlerrd2')
from systables
where tabid = 1
will tell you how many rows were affected by the last updates/deletes. Not
sure about
insert though.
<Darren_Jacobs@carmax.com> wrote
> Greetings,
>
> I have an application (Power Builder) that us being used to make
> inserts,updates, and deletes and the user would like to know how many
rows
> were affected by one of these operations. Is there a way to capture the
> "rows affected" and return it to the application? (ie, similar to what
is
> returned if using Sql Editor)
>
> Info window in Sql Editor
> -- Executing selected SQL statements in Untitled.sql.
> update backup_log_tbl set success_failed = "failed"
> where complete_dt < "2004-04-30 00:00:00.000";> -- 10 rows updated.
>
>
> IDS 9.40 FC2
> HPUX 11