AUSED() only reports on the current session if a sessionid is not specified. In any case, it only reports on a single session.
Fred On Fri, Aug 24, 2012 at 2:07 PM, John Weller <[email protected]> wrote: > 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 > > [excessive quoting removed by server] _______________________________________________ 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/cajcbksqlcbx+3tblujpxomvb0f_yzqtq21svberys-yrdbp...@mail.gmail.com ** 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.

