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#1177023816and here:
http://forums.informationbuild...1057331/m/4781021962But 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/INSERTI 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, September 18, 2014, 07:53 AM
dhagenLook at
thisSeptember 24, 2014, 01:24 PM
bugquote:
Originally posted by dhagen:
Look at
this
This really helps!
But is there further way to know if the SQL operation fails?