Re: Delphi and the SQLCA

My understanding is that the SQLCA is only accessible from Informix development tools such as Informix-4GL and ESQL/C. It is not an information source that is native to Informix-SQL (try accessing it from an SQL script). We had the same problem with Gupta SQL/Windows when we wrote a record to a table with a serial value and wanted to find out the SQLCA.SQLERRD[2] value but could not. Informix 6.x & 7.x have some new control records that are accessible from SQL, which contain similar information to that which is stored in SQLCA, but 5.x has nothing. Paul Hutton huttonp@ozemail.com.au Javier Arroyo wrote: > > 102110.3554@compuserve.com (Jeff Webster) wrote: > > >Abyone know how to go about accessing the SQLCA from within a Delphi program? > >Does it make any difference if using ODBC or native drivers (i.e. SQL Links)? > >Thanks in advance for any help > >-- > >-------------------------------------------------------------------------- > > Jeff Webster | 102110.3554@compuserve.com > > Visual Services, Inc. | Tel: (810) 433-7943 > > Bloomfield Hills, Michigan, USA | Fax: (810) 646-0888 > > > > "Any opinions expressed herein are my own and not those of my employers." > >-------------------------------------------------------------------------- > > I have succesfully hooked into Informix from Delphi using Intersolv's > ODBC driver and Borland's SQL Links, SQL links seems to be about 15% > faster. > > Javier Arroyo > Automated Environments * Roseville, CA > email 74734.162@compuserve.com > fax 916-782-8557 > phone 916-782-unix