Finding Parameters from 4gl

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dear Knowledgable, I am running Informix IDS 7.31UC5 on AIX 4.3.3. My problem is one of the users has managed to bypass the application and entered a record into a table(yet to be worked out how this was done) The only problem is that the application (written in 4gl) can not carry out an insert due to a duplicate primary key. Q. How can I get the IDS engine to tell me what value the application is trying to insert into the table as when I run "onstat -g ses thread ID" I can view the SQL but it just has ? marks for the values. If I new what the values were I could remove the record from the table and hence enable the application to continue Adam Birch ambirch@hotmail.com -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>; iQA/AwUBOU11b3QB7atCA4drEQLYNwCdG6kkOVZyHWLpfdJF3/wM+Wof1IEAn1Y8 bcq70gPtD04CiTE8ZYU21Qfu =R+Mu -----END PGP SIGNATURE-----

"Adam:-)" wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Dear Knowledgable, > I am running Informix IDS 7.31UC5 on AIX 4.3.3. My problem is one > of the users has managed to bypass the application and entered a > record into a table(yet to be worked out how this was done) The only > problem is that the application (written in 4gl) can not carry out an > insert due to a duplicate primary key. > Q. How can I get the IDS engine to tell me what value the > application is trying to insert into the table as when I run > "onstat -g ses thread ID" I can view the SQL but it just has ? marks > for the values. If I new what the values were I could remove the > record from the table and hence enable the application to continue > > Adam Birch > ambirch@hotmail.com > I am not too sure if I4GL has a debug facility which allows you to monitor all SQL sent to the engine, in Querix however such facility exits if it could be of any help to you. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------