SQLCA.SQLERRM in 4GL RDS and NewEra
Posted in 1996
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
Hello Informixers: I'm improving my error handler routine in both environment, 4GL and NewEra. In INFORMIX-4GL, I'm trying to use SQLCA.SQLERRM to determine wich Constraint has been violated. There's something that looks like a bug: using the same version 4.11.UC4 it doesn't work in RDS, but works fine in Compiled version. Anybody know something about this? In INFORMIX-NewEra, I'm using the generated code from Window Painter. It uses Implicit connection, which doesn't make SQLCA record available. Based on this, How can I get the constraint id after a constraint violation? TIA ////// +---------------------------ooo-O-O-ooo--------------------------------+ | U | | Melvin Perez Cedano Santo Domingo, Dom. Rep.| | Vice-President m.mejia@codetel.net.do | | Systems Development Phone (809) 686-5574 | | CAM Informatica, S. A. Fax (809) 686-5467 | +----------------------------------------------------------------------+ | ALL RIGHTS RESERVED | | This posting is copyright and may be used only for the purposes | | of professional study or the professional exchange of information. | | Use of this posting by any commercial organisation for the | | purposes of vilifying another is explicitly prohibited. | +----------------------------------------------------------------------+