Re: Passing Back CURRVAL

From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/10/05
Message-ID: <45060i$adr_at_dingo.cc.uq.oz.au>#1/1

roywagner_at_aol.com (Roy Wagner) wrote:

>How can pseudo-column values like CURRVAL and NEXTVAL (dynamic SEQUENCE
>values) be accessed from a front-end written in Visual Basic which is
>connected to an Oracle database using ODBC. Since these columns are not a
>part of the table ODBC fails when these names are used in VB. Thanks you!

Oh but they are, they can be select from dual....

-----------------------------\ooOoo/-----------------------------------
Gordon Hooker MACS PCP                                     ,--_|\
25 Clarke Street, Ripley, Queensland, 4306, Australia     /      \ 
gordonh_at_acslink.net.au                                    \_.--._/
mobile: 018883835 phone: 61-7-2889716                           V
-----------------------------------------------------------------------

It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Thu Oct 05 1995 - 00:00:00 CET