Hi Valerie ---

OK, I'll answer as best I can but I am by no means an Oracle whiz....an Oracle sequence is a database object that maintains sequential numbers. It can be queried via a SELECT and, yes, I think that means you could do it through SQLEXEC() although I've never tried it.

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