Re: Obtain Serial Value

From: Timothy Reed <tareed(at)gmail(dot)com>
To: "Sistemas C(dot)M(dot)P(dot)" <sistemascmp(at)redynet4(dot)com(dot)ar>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Obtain Serial Value
Date: 2006-02-08 14:32:05
Message-ID: dc53e5300602080632i24818944m3077b1b46bc65497@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

You should try SELECT MAX( <fieldname> ) FROM <tablename>; ??

On 2/8/06, Sistemas C.M.P. <sistemascmp(at)redynet4(dot)com(dot)ar> wrote:
>
> I am using VB6+ADO+ODBC with pgSQL.
> I need to obtain the value of a serial field (autogenerated) inmediatly
> after I do a INSERT query. How can I do?
>

--
--------
Timothy Reed

tareed(at)gmail(dot)com

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Trewern, Ben 2006-02-08 14:46:50 Re: Obtain Serial Value
Previous Message Sistemas C.M.P. 2006-02-08 14:03:02 Obtain Serial Value