Re: Passing Back CURRVAL

Roy Wagner (roywagner_at_aol.com) writes:

   You have to use an SQL PASSTHRU query such as SELECT Myseq.nextval NEXT_VALUE from DUAL;

> 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!

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##