Foxpro Notes 1: Modification on Foxpro Auto-generated Stored Procedure

Last tuesday, I was being asked to support development with Visual Foxpro 9.0. I have setup Foxpro database according to specification except foreign key constraint. The auto-generated foreign key constraint will restrict the direct data entry from the form.

I have looked for help at "www.foxite.com". Tushar from India has provided me 2 clues to derive the solution. Really appreciate for his help.

1. Add "IF !EMPTY(foreignkey)" to bypass the foreign key constraint checking code



2. Add round brackets () for the variable lcParentWkArea in statement "unlock record pnParentRec in lcParentWkArea". Thhe new statement is "unlock record pnParentRec in (lcParentWkArea)"