Expert: Markish - 9/10/2008

Question
I want to make a program on FoxPro2.6 which manage addition,deletion and editing records on a .dbf file. I also want a field like emp_code which generate automaticaly.

Answer
Hi Prem,

For adding a record in a DBF, You can use

Use tableA
append blank
replace field1 with value1, field2 with value2,...

For deleting use

use tableA
goto 10  && goes to record 10
delete   && Marks the record for deletion

pack     && Permanently removes the record

For editing, you can use the same

replace field1 with value1, field2 with value2,...

Hope this helps..
Best regards,
Markish

http://markishonline.com