Error numbers in VB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Error numbers in VB

  1. #1
    Robert Scheer Guest

    Error numbers in VB


    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

  2. #2
    Ruben Guest

    Re: Error numbers in VB


    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



  3. #3
    Robert Scheer Guest

    Re: Error numbers in VB


    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

    >



  4. #4
    Sean R. Durity Guest

    Re: Error numbers in VB



    "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


  5. #5
    Bruce Guest

    Re: Error numbers in VB


    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center