Try AUSED() to find which tables are open. John Weller 01380 723235 07976 393631
> -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Peter Hart > Sent: 24 August 2012 21:12 > To: [email protected] > 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 _______________________________________________ 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.
