Dump with SQL Sentences

[Former Member]

Hi

I 'm using SQL sentences in a customer program, for example:

        EXEC SQL.
          INSERT INTO ORAGNI.V_SALDOS_FATPO@INT
          VALUES (:TI_SALIDA-PERNR,
                  :TI_SALIDA-NAME1,
                  TO_DATE(:C_FECHA, 'dd.mm.yyyy'),
                  :TI_SALIDA-DISPO,
                  :TI_SALIDA-SALDOP,
                  :TI_SALIDA-SALDOAU,
                  :TI_SALIDA-SALDOAO,
                  :TI_SALIDA-SALDOAPO,
                  :TI_SALIDA-SALDOAE,
                  :TI_SALIDA-SALDOAD,
                  :TI_SALIDA-DARMC,
                  :TI_SALIDA-SALDOT,
*                :TI_SALIDA-SYSID,
                  :V_FONDO,
                  :TI_SALIDA-ULTIMO_DIV)
        ENDEXEC.

    EXEC SQL.
      COMMIT WORK.
    ENDEXEC.

But i have a dump when I run this program, this is part of the dump:

Errores tiempo ejecucióDBIF_DSQL2_SQL_ERROR          
       ocurrido el     07.10.2008 a  14:59:31
------------------------------------------------------------------------------------------ 
SQL error 1722 occurred when executing EXEC SQL.                               
 
-----------------¿Qué ha sucedido?
----------------- 
The error occurred in the current database connection "DEFAULT".               

Other Dump:

Errores tiempo ejecucióDBIF_DSQL2_SQL_ERROR          
       ocurrido el     07.10.2008 a  14:59:31
------------------------------------------------------------------------------------------ 
SQL error 1722 occurred when executing EXEC SQL.                               
 
-----------------¿Qué ha sucedido?
----------------- 
The error occurred in the current database connection "DEFAULT".               

How can i do to catch this mistake ?? maybe i can to use catch ... endcatch ¿how can i use it?

Regards

Gregory

[Former Member · Accepted solution]

Hi,

01722, 00000, "invalid number"

// *Cause:

// *Action:

You must be writing invalid number into a numeric field, Please check the values in the individual fields using trace and compare with the Field definition to find the error.

Thanks and Best Regards,

Sunil.

[Former Member]

Ready

thanks for your asnwer