Re: calling nextval function

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Eric E" <whalesuit(at)bonbon(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: calling nextval function
Date: 2004-12-06 15:37:17
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A755D@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> Hi Oliver,
> sSeqValSQL = "SELECT nextval(bed_id_seq);"
> cnPGODBC.Open ("Your ODBC connection string")
> Set rsSeqVal = cnPGODBC.Execute(sSeqValSQL)

I thought the sequence name had to be single quoted to the sequence
functions...can you skip that in VB?

i.e. select nextval('my_seq');

Merlin

Browse pgsql-odbc by date

  From Date Subject
Next Message Stephen Frost 2004-12-07 14:02:40 Re: ODBC Rewrite
Previous Message Eric E 2004-12-06 15:33:54 Re: calling nextval function