Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group