>Using vfp 7, we create a view that depends of 4 tables. We test the view and everything work fine, but when we close all or run the program surrenly one or the tables disappear from the view (we open view designer and it's no more).
Plinio,
Prior to VFP 8, there were many problems with the View Designer. Once you reached a certain level of complexity, the designer couldn't hande it. While I've never heard it to delete a table from the table list, I wouldn't be surprised.
Prior to opening the view in the View Designer, use the view nodata. Issue the following:
? CursorgetProp('SQL','MyViewName')
See if the table is still there. If it is, open the view in the designer and see if the table goes away. If so, then it's a problem with the designer and that view. You'll have to maintain that view in code.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao