Re: Informix sqlca and Delphi
Fortunately, Delphi doesn't rely on ODBC for database connectivity.
Using the native SQL Link driver for Informix, you can get this
information (it's faster than ODBC too!).
See the earlier response from Nick Derpich on how this is accomplished
using Delphi/BDE/SQL Links.
-Mike
Jacob Salomon wrote:
>
> Marius Dreyer wrote:
> >
> > Hi evereyone
> >
> > Is somebody accessing the Informix sqlca from Delphi 1.01 ?
> >
> > The problem i'm having is to access the serial value for table into
> > which I just inserted a record.
>
> Marius,
>
> I know nothing about DELPHI specifically but I do know that the sqlca is
> not part of the ODBC standard API for databases. Thus, delphi knows
> knothing ;) about it.
>
> However, there is the dbinfo function you can use after the INSERT
> statement.
>
> insert into some-table values (0,...)>
> select unique dbinfo("sqlca.sqlerrd1") into my_var from systables>
> Actually, any table will be OK in the FROM clause. Since this is just
> an ordinary database call any ODBC-compliant protocol will handle it.
>
> --
> -- Jake Salomon(Confessed DELPHI ignoramus)
> . .
> _..-'( )`-.._
> ./'. '||\\\\. }\\_/{ .//||` .`\\.
> ./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\.
> ./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\.
> ./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\.
> /'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\
> '.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.`
> '.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.`
> |/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\|
> V V V }' `\\ /' `{ V V V
> \\ \\ \\ V / / /
> +-----------------------------------------------------------+
> | Impeccable Logic: A thought process which successfully |
> | resists chicken bites |
> +-----------------------------------------------------------+