Postgres Pro
Downloads
Home   >   mailing lists

Re: calling nextval function - Mailing list pgsql-odbc

From Merlin Moncure
Subject Re: calling nextval function
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A755D@Herge.rcsinc.local
Whole thread Raw
In response to calling nextval function  ("Gosling, Oliver" <o.gosling@lancaster.ac.uk>)
List pgsql-odbc
Tree view 
> 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:

Previous
From: Eric E
Date:
Subject: Re: calling nextval function
Next
From: markw@mohawksoft.com
Date:
Subject: ODBC Rewrite