Hi John,

Pardon the Oracle question -- Is an Oracle sequence an insert trigger? Or is it more like the Access AutoNumber datatype? Do I use SQL pass-through to query it? How do I resolve the difference between my prototype calling the procedure and the production database using this MyKeys.nextval method? Is there a function for knowing WHERE the data is coming from?

Thanks for your help.

>Hi Valerie ---
>
>Let's assume that you will eventually use an Oracle sequence to generate the primary keys (lets call the sequence MyKeys). Before INSERTing a new record, you can query MyKeys.nextval to see what primary key will be assigned by the INSERT and there will be your "pointer" to the new record.
>
>