Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA30950 for ; Wed, 26 May 1999 13:47:45 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id NAA15554 for ; Wed, 26 May 1999 13:47:12 -0400 Received: by localhost with Microsoft MAPI; Wed, 26 May 1999 13:49:13 -0400 Message-ID: <01BEA77E.89E72F60.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: select nextval. . . Date: Wed, 26 May 1999 13:49:12 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit i am connecting to a postgres 6.4.2 database with msaccess97. in that postgres database i have a sequence defined. in access i have a form, with only one textbox -- when i open that form i'd like to populate that textbox with the next value in that sequence. i can get the next value from psql (select nextval('sequencename');), but i can't seem to figure out how to get that nextval from within access97 into a control on a form. i can design a pass-through query that inserts the nextval into a database, but that isn't what i want to do (it also exposes some risk of non-uniqueness that the sequence helps to ensure). got any ideas?? jt