Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
June C. Hunt — — source: Usenet: comp.databases.informix
<Darren_Jacobs@carmax.com> wrote:
>
> This is a multipart message in MIME format.
Please don't post MIME.
> 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
Also posted to ids@iiug.org -
You probably want to take a look at the DBINFO function. The
'sqlca.sqlerrd2' option will return an integer value that gives you the
number of rows processed. See the IBM Informix Guide to SQL: Syntax for
details.
--
June Hunt
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.