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