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.
>
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement