Getting the last query when an error occured
Posted in 2003
HI ! Well, another one ! :) Yes, once again a little question for the newsgroup ! So i begin my explanation : with ESQL/C As all my "C" program are services, i would like to log error to "maybe" interact with it . But what i'm trying to obtain unsuccessfully for some day now, is to get the text of the last query that generates an error ! eg: in the code there is an exec sql select a,b from alpha; then I check the result of the command. (b is not in the table) so => error i got the message : "Error : Column(b) not foun in any table in the query" but since our whole code is pretty huge, it would be great to have the query that make the error : "select a,b from alpha" so we can pretty easely diagnose what the error is exactly and the gravity of it. In that case it's just the name of the column we can say it would take 5mn of correction , 5 mn of compilation, and 5-10 mn of test(if we're nor sure... :)). we're doing this with all the database we work with. So i think that i just missing the thing and that Informix have structure for this.... (but i can't find information about this ... i try but i can't ...) Thank you by advance for any answers ! Arnaud