RE: Tables left open when form closes

2012-09-03 Thread Peter Hart
This email has been sat in my outbox and I didn't realise it, it was originally sent about the 25th of August Very sorry for not replying sooner but we have had a severe lightning storm which blew out my router and a switch. It also caused a number of problems for clients and I had to see

Re: Tables left open when form closes

2012-08-29 Thread MB Software Solutions, LLC
On 8/25/2012 3:39 AM, Allen wrote: What is a good reason to use data sessions. I never do and never have these problems. I prefer control For starters, you can have the same table/cursor names open so you can code consistently moreso rather than having to create bizarre names for your cursors

RE: Tables left open when form closes

2012-08-25 Thread Allen
: Tables left open when form closes AUSED() only reports on the current session if a sessionid is not specified. In any case, it only reports on a single session. Fred ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com

Re: Tables left open when form closes

2012-08-24 Thread MB Software Solutions General Account
On Fri, August 24, 2012 4:11 pm, Peter Hart wrote: 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

Re: Tables left open when form closes

2012-08-24 Thread Fred Taylor
A private DataSession will close it's own use of a table. Are you sure that the table wasn't already open before your private DS form ran? If the tables were already open, the private DS will not close them, only its use of the tables, essentially like a USE AGAIN. Fred On Fri, Aug 24, 2012

Re: Tables left open when form closes

2012-08-24 Thread Eurico Chagas Filho
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

RE: Tables left open when form closes

2012-08-24 Thread John Weller
Try AUSED() to find which tables are open. John Weller 01380 723235 07976 393631 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Peter Hart Sent: 24 August 2012 21:12 To: profoxt...@leafe.com Subject: Tables left open when

Re: Tables left open when form closes

2012-08-24 Thread Fred Taylor
-Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Peter Hart Sent: 24 August 2012 21:12 To: profoxt...@leafe.com Subject: Tables left open when form closes I have an application which uses Arg Software Ribbon bars

Re: Tables left open when form closes

2012-08-24 Thread Tracy Pearson
Peter Hart ph...@peterhartcomputers.co.uk wrote: 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

Re: Tables left open when form closes

2012-08-24 Thread Ken Dibble
Is it possible to run through all used work areas to see if the tables required are in use and if so close them? You can use AUSED(), you may need to use SET DATASESSION also. You can use ASESSIONS() to get an array of data session IDs, and then loop through those, use AUSED() to get an