Home > mailing lists

Currval not working - Mailing list pgsql-odbc

From	Patrick Hatcher
Subject	Currval not working
Date	May 30, 2003 20:03:07
Msg-id	000a01c326ee$dcd67520$02120a0a@D7MKWD21 Whole thread Raw
Responses	Re: Currval not working (Chris Gamache <cgg007@yahoo.com>)
List	pgsql-odbc

PG: 7.3.3

Driver version: 7.03.01

I'm using VB as a front-end to end data into PG database. When I try to pull the current value of my serial field using this code:

rs.open "select currval('public.hodiv_hodiv_id_seq');",CN

I get this error message:

ERROR: hodiv_hodiv_id_seq.currval is not yet defined in this session.

However, if use nextval it works fine.

rs.open "select nextval('public.hodiv_hodiv_id_seq');",CN

Any ideas?

TIA

Patrick

From: Jeff Silberberg
Date: 30 May 2003, 17:48:46
Subject: PSgreSQL Driver Security question..

From: Corrado Cavallini
Date: 01 June 2003, 03:01:22
Subject: ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access