Don't waste time looking for the problem. Just emit a SET Database TO and CLOSE TABLES ALL . After that execute your routine.
E. >________________________________ > From: Peter Hart <[email protected]> >To: "'[email protected]'" <[email protected]> >Sent: Friday, August 24, 2012 5:11 PM >Subject: Tables left open when form closes > >I have an application which uses Arg Software Ribbon bars. > >When I click on an icon to open a form which needs to open a table exclusive >i.e. for re-indexing. I get an error that the table is already in use. I don't >get this error if either this is the first form opened or I have only opened >forms that don't use that particular table. >If I open FoxPro whilst the application is open I can see which tables have >been used by trying to open the tables exclusive, and the I get the error. >All the forms are based on a form class that has its datasession property set >private. I thought these would automatically close any tables opened by the >form as the form was closed. > >Any ideas were I am going wrong? > >Is it possible to run through all used work areas to see if the tables >required are in use and if so close them? > >T.I.A. > >Peter >Peter Hart Computers > > > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > >_______________________________________________ >Post Messages to: [email protected] >Subscription Maintenance: http://leafe.com/mailman/listinfo/profox >OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech >Searchable Archive: http://leafe.com/archives/search/profox >This message: >http://leafe.com/archives/byMID/profox/9C476F6427FC3547AC8BBFE5E254EC56538C4F2627@SERVER.peterhartcomput.local >** All postings, unless explicitly stated otherwise, are the opinions of the >author, and do not constitute legal or medical advice. This statement is added >to the messages for those lawyers who are too stupid to see the obvious. > > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
