VFP5.0 XP
I have several open tables involved in various parent/child relationships in a food service menu/inventory program.
The user selects products from the inventory table, in a grid, which are stored in a temp table. When product selection is complete, the temp table is then appended to the menu table. I use table buffering. Occasionally, seemingly random, the program will not save the just completed menu and will in addition delete all items contained in the temp table from the product inventory table. This did not happen until there were several hundred records in both the product and menu tables. The only recourse then is to manually re-enter the product inventory information. My client is, to say the least, upset.
The only error message I have been able to capture indicates it is a buffering problem. Since it is a seemingly random problem, I have not been able to duplicate it in the development environment.
Thoughts would be appreciated.
George
I have several open tables involved in various parent/child relationships in a food service menu/inventory program.
The user selects products from the inventory table, in a grid, which are stored in a temp table. When product selection is complete, the temp table is then appended to the menu table. I use table buffering. Occasionally, seemingly random, the program will not save the just completed menu and will in addition delete all items contained in the temp table from the product inventory table. This did not happen until there were several hundred records in both the product and menu tables. The only recourse then is to manually re-enter the product inventory information. My client is, to say the least, upset.
The only error message I have been able to capture indicates it is a buffering problem. Since it is a seemingly random problem, I have not been able to duplicate it in the development environment.
Thoughts would be appreciated.
George
