>I am still new to VFP programming.
>It appears that to add a record to a database via a form, you APPEND BLANK and then have the user enter the new data.
>I did not see any controls that would generate an error message if you tried to enter a duplicate key as happens with BTrieve and other databases.
>Under FoxPro 2.6 you can either go to EOF and SCATTER MEMVAR and not add the record if it is already present.


To enforce unique keys, you can use a primary or a candidate index. To check for uniqueness before you try to commit the record, you can INDEXSEEK() the value of the current field to check to see if it exists in the table already.