Form Error after deleting fields in .DBF file and form

[PabloHaughton]

I created a form using the form Wizard and added some new fields to it.
Later I decided to remove these fields from the form and also from the .DBF file that is in a Database (.DBC).
To my surprise, when I run the form it still looks for the fields I deleted from the form and table.
I get the following error:

variable 'varname' is not found.
Error: 12
Variable 'varname' is not found.
Method: embossedform.dataenvironment.OpenTables
Line: 0

Is there a special place where you have to go and remove field references also?

 

[Scott24x7]

Right click on the form, select "Data Environment" from the drop down.

Delete the table if it peresist, or answer "Yes" to removing the reference if VFP asks that, then just close the DE, save the form, and that issue should go away.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[Mike Lewis]

Pablo,

Whenever you delete fields from a DBF, be sure to delete any relevant indexes as well. If an index expression contains the field you just deleted, you will see the error you described.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk