> 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