Skip site navigation (1) Skip section navigation (2)

RE: A problem with the nextval('') function

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Ray Daigle" <rdaigle(at)click2net(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: A problem with the nextval('') function
Date: 2001-07-27 22:17:17
Message-ID: EKEJJICOHDIEMGPNIFIJIEEFFAAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
-----Original Message-----
From: Ray Daigle

> 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".

ODBC itself doesn't reject the query.
Aren't you using DAO-jet ?

regards,
Hiroshi Inoue



In response to

pgsql-odbc by date

Next:From: Ryan HoDate: 2001-07-28 04:46:17
Subject: Re: Visual Basic and PostgreSQL ODBC
Previous:From: Gilles DAROLDDate: 2001-07-27 18:53:16
Subject: OpenLDAP and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group