Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access Append Query Using .NextVal?

440366Mar 16 2005 — edited Mar 22 2005

How do I use sequence.NextVal in an Access append (insert) query to an Oracle database table?

This SQL example (underlying the Access append query) does not work:

INSERT INTO FUEL_CAPTURE (RECORDID, FuelID, FactionID)
SELECT RECORDIDFUEL_CAPTURE_SEQ.NextVal, Fuel.FUELID, Fuel.FACTIONID
FROM Fuel;

The Access front end is linked to the Oracle database using ODBC.

Thanks,
J

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2005

Added on Mar 16 2005

#database-and-application-migrations

1 comment

3,284 views