Error numbers in VB

[Robert Scheer]

Hi.

An application I am writing in VB/ADO makes intensive use of an Informix
database, through the Informix Oledb Provider 2.7 . In my error handling
routines, I am trying to get the error numbers generated by Informix without
success, so, I am reading the error descriptions in order to do my error
handling. Is it really the only way to intercept Informix errors from VB,
or can I intercept the error numbers?

Thanks,

Robert Scheer

[Ruben]

Hi
I'am speak spanish, but i hope that you understand me

you can read the register sqlca.*

if you have an spanish translator, translate this

Informix genera un registro especial por cada transaccion llamado sqlca.
El registro sqlca esta compuesto por varias columnas
sqlca.sqlcode
sqlca.errd
sqlca.errm

Despues de una transacción puedes leer este registro y veras el resultado.




"Robert Scheer" <rbscheer@my-deja.com> wrote:
>
>Hi.
>
>An application I am writing in VB/ADO makes intensive use of an Informix
>database, through the Informix Oledb Provider 2.7 . In my error handling
>routines, I am trying to get the error numbers generated by Informix without
>success, so, I am reading the error descriptions in order to do my error
>handling. Is it really the only way to intercept Informix errors from VB,
>or can I intercept the error numbers?
>
>Thanks,
>
>Robert Scheer

[Robert Scheer]

Hi Ruben,

I could understand what you said. But I am trying a simple Select DBInfo('sqlca.sqlcode')
From Systables and keep receiving this error:
"Unknown first argument of dbinfo(sqlca.sqlcode)"

Do you know of some material that explains the structure of the sqlca register?

Thanks,

Robert Scheer


"Ruben" <rubenaraya@vtr.cl> wrote:
>
>Hi
>I'am speak spanish, but i hope that you understand me
>
>you can read the register sqlca.*
>
>if you have an spanish translator, translate this
>
>Informix genera un registro especial por cada transaccion llamado sqlca.
>El registro sqlca esta compuesto por varias columnas
>sqlca.sqlcode
>sqlca.errd
>sqlca.errm
>
>Despues de una transacción puedes leer este registro y veras el resultado.
>
>
>
>
>"Robert Scheer" <rbscheer@my-deja.com> wrote:
>>
>>Hi.
>>
>>An application I am writing in VB/ADO makes intensive use of an Informix
>>database, through the Informix Oledb Provider 2.7 . In my error handling
>>routines, I am trying to get the error numbers generated by Informix without
>>success, so, I am reading the error descriptions in order to do my error
>>handling. Is it really the only way to intercept Informix errors from VB,
>>or can I intercept the error numbers?
>>
>>Thanks,
>>
>>Robert Scheer
>

[Sean R. Durity]

"Robert Scheer" <rbscheer@my-deja.com> wrote:
>
>Hi Ruben,
>
>I could understand what you said. But I am trying a simple Select DBInfo('sqlca.sqlcode')
>From Systables and keep receiving this error:
>"Unknown first argument of dbinfo(sqlca.sqlcode)"
>
>Do you know of some material that explains the structure of the sqlca register?

Try your question in comp.databases.informix (or search the archives at Google
Groups). More of the folks-in-the-know hang out there.

As for sqlca - I think you can only get to it from 4GL and ESQL-C, not VB.
However, I could be wrong.

Sean R. Durity

[Bruce]

You can check the errors in the ado connection object

---------------
| |
| * * |
| /\ |
| \ / |
| \____/ |
| |
---------------

"Robert Scheer" <rbscheer@my-deja.com> wrote:
>
>Hi.
>
>An application I am writing in VB/ADO makes intensive use of an Informix
>database, through the Informix Oledb Provider 2.7 . In my error handling
>routines, I am trying to get the error numbers generated by Informix without
>success, so, I am reading the error descriptions in order to do my error
>handling. Is it really the only way to intercept Informix errors from VB,
>or can I intercept the error numbers?
>
>Thanks,
>
>Robert Scheer