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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only