>Hi there,
>
>I am looking for help on how to code a form for a Adding, deleting and editing data in a table. I have tried to use the append command or a simple insert statement, but I keep get index violations even though the key value of the record I am trying to add is unique. Where can I find good examples of how to code a form with a Add, delete and edit capabilities. I can use the wizard to create a form, but that means one does not know what happens and how the code works. Not even VFP help gives you example code. I would really appreciate it if someome can help me
>
>Thanx
Before using the APPEND command, you have to enable buffering.
Use TableUpdate() to save changes, and TableRevert() to undo changes.
I did a simple sample form for my students, but I don't have it with me right now.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)