Focal Point
[SOLVED] How can I capture database message after SQL Passthrough?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/9577086276

September 16, 2014, 09:47 AM
bug
[SOLVED] How can I capture database message after SQL Passthrough?
I found information about capturing sys error message here

http://forums.informationbuild...177023816#1177023816

and here:

http://forums.informationbuild...1057331/m/4781021962

But none of them mentioned the database message. For example, I have this message when I run an insert statement:


SQL SQLMSS
INSERT INTO TABLE_ABC
(ID , DATE ) VALUES
( 'AFDDD', '20140831' );
END

(FOC1364) ROWS AFFECTED BY PASSTHRU COMMAND : 1/INSERT


I need to capture how many rows have been inserted, or if the insert return any error in my program.

Is there a way to do that?

Thanks!

This message has been edited. Last edited by: Tamra,


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
September 18, 2014, 07:53 AM
dhagen
Look at this


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
September 24, 2014, 01:24 PM
bug
quote:
Originally posted by dhagen:
Look at this


This really helps!

But is there further way to know if the SQL operation fails?


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)