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 them

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 cursor

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 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 ge

Re: Tables left open when form closes

2012-08-24 Thread Tracy Pearson
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 this is the first form >opened or

Re: Tables left open when form closes

2012-08-24 Thread Fred Taylor
t; 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 form closes > > &

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

Re: Tables left open when form closes

2012-08-24 Thread Eurico Chagas Filho
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 >To: "'profox@leafe.com'" >Sent: Friday, August 24, 2012 5:11 PM >Su

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 at

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 eit