Hi,
I've been writing a VB application that uses 7.01.00.06 ODBC driver to access a PostgresSQL database. Everything works OK until I try using the 'nextval' function. When I try to execute SELECT nextval('userid') , either from my application or from the Visual Data Manager tool, I get an error that states: "The SELECT statment includes a reserved word or argumnet name that is misspelled or missing, or the punctuation is incorrect. Number 3141".
The same query works fine on my database if I'm just using the standard UNIX PostgreSQL client, it's only when I try to execute it through ODBC that I get a problem.
Does anyone know if the 7.01.00.06 version of the psqlodbc drivers support the nextval function in a SELECT query?
Thanks,
Ray Daigle
Technical Analyst
Click2Net Inc.
Tel: (905) 271 3550 ext. 222
Fax: (905) 271 3650
rdaigle@click2net.com