>Just beginning to delve into SQL syntax in VFP and would like to create a primary (numeric) key in a table. I would also like this field to simply be an integer value which increments by 1 each time a new record is added.
>
>Some SQL languages have a definition which causes this to happen. I haven't seen any reference to something like this so far. Is there anything like this in VFP ?
>
>If not, is there a recommended method for handling this ? Separate FREE table to store next value in ? Table within the database ?
Look at the Primary Keys document on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer