Try AUSED() to find which tables are open.

John Weller

01380 723235

07976 393631

> -----Original Message-----

> From: profoxtech-bounces@leafe.com [mailto:profoxtech-

> bounces@leafe.com] On Behalf Of Peter Hart

> Sent: 24 August 2012 21:12

> To: profoxtech@leafe.com

> 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: ProFox@leafe.com

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/000501cd823c$832bb220$89831660$@johnweller.co.uk

** 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.