Ed already answered the question, but I thought I'd ad a "didjano". If you have a database, you can set the default value of the primary key to GETKEYNO('tablename') or whatever your equivalent function is and it will put the numbers in automagically.
-Michelle
>Hello... I am very new to the Visual FoxPro World... so, if these questions seem basic, they probably are!
>
>I took an introduction class to VFP6.0 and learned the program code for auto-generating primary keys.
>
>Question: Do I have to create a sysinfo table for each primary key located in my tables that I want to auto-generate?
>
>Last night I created 7 stored proceedures and 7 sysinfo tables for my tables. It appears to work fine, however I am not sure this is the best way to do it. In ACCESS you just have to select AUTONumber and it does the same thing. It seems like a lot of work.
>
>Am I doing things correctly? Is there a better way?
>
>Jason Doyle
>MSA Consulting, Inc.
Précédent
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