I have a FCGI script that lets you enter an sql statement in a textbox and
on submit the statement is submitted to the database. If it is a select
statement, a table with the results is displayed. If it is not a select
statement, the program simply prints an error that fetch* didn't work.
I'd like to make this program more intelligent by displaying the message
returned by the database by successful update, delete, insert,
etc. statements. I'm using Informix and I'm unable to find an attribute
or function that allows me to do this. I believe in Sybase you can just
do a fetch and grab a particular piece of the result set that would
contain this data (don't have the perldoc for DBD::Sybase in front of me,
so I don't know offhand what the syntax would be to do this). Is there's
something equivalent I can use under Informix to get this information?
Example
update informix.vp_ppreq
set ts = '2001-07-04 12:00:00'
where prt_date = '2001-03-01'
No rows found. -----> this is what I want to get!!!
Thank you,
Curt Crandall
