> We've run into a snag with processing Oracle tables attached to a
> Microsoft Access Database.
>
> We want to be able to use Oracle's Sequence generator to
> create unique ID's on row-inserts, but have been unable to get MS-Access
> to recognize any way to accomplish this - it doesn't recognize the
> SQL statement with the "<sequence>.nextval" in it.
>
Two possibilities come to mind.
- SELECT sequence.nextval from DUAL into a field, then use the
field to set the id.
- Use a Pre-Insert row database trigger to set the id. That way
the key is created entirely outside of Access.
Received on Fri Jan 19 1996 - 11:44:29 CST
