Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: TABLE LOCKED
Thread ID: 373287 Message ID: 373310 # Views: 47 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 6:55:58 AM         
   


> >
> > Hi Jun
> >
> > you mean to say all tables open shared in load event they used in select query.
> >
> >
> > Learning never ends
>
> As Stefan also writes, simply have Set Exclusive Off early in your code. Personally I have it in config.fpw. I also avoid DE, my experience is that DE causes much more problems than it solves.


Hello Tore,

Some experts also said before openly here to avoid using DE. However, I have been using DE for a long time now and I haven't experienced any problem with it. And AFAIK no one explained "why" we should avoid using DE, only that most says avoid it. Care to share some of the problems it may cause?


http://sandstorm36.blogspot.com
http://weblogs.foxite.com/sandstorm36

ENTIRE THREAD

TABLE LOCKED Posted by Pratik Singh @ 3/20/2013 7:25:10 PM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/20/2013 7:32:19 PM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 12:58:29 AM
RE: TABLE LOCKED Posted by Pratik Singh @ 3/21/2013 6:15:48 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 6:46:38 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 6:55:58 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 7:24:04 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 8:49:45 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 9:04:54 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 9:11:30 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 9:22:49 AM
RE: TABLE LOCKED Posted by mk sharma @ 3/21/2013 10:32:49 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 10:39:59 AM
RE: TABLE LOCKED Posted by mk sharma @ 3/21/2013 3:56:51 PM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 12:30:32 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 1:27:33 AM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 5:53:18 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 5:51:54 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 6:15:08 AM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 6:48:48 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 9:03:11 AM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 9:19:13 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 10:59:37 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 6:57:13 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 7:22:35 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 8:41:40 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 9:06:22 AM
RE: TABLE LOCKED Posted by Tore Bleken @ 3/21/2013 9:08:09 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/21/2013 9:01:32 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/21/2013 12:21:28 PM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 12:07:32 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 3:21:31 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 3:29:01 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 5:33:08 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 6:28:07 AM
RE: TABLE LOCKED Posted by Tom Saddul @ 3/22/2013 9:05:35 AM
RE: TABLE LOCKED Posted by Paul Gibson @ 3/22/2013 10:35:58 AM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 7:14:18 AM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 7:40:37 AM
RE: TABLE LOCKED Posted by Stefan Wuebbe @ 3/22/2013 8:51:44 AM
RE: TABLE LOCKED Posted by Paul Gibson @ 3/21/2013 5:52:57 PM
RE: TABLE LOCKED Posted by Jun Tangunan @ 3/22/2013 12:08:17 AM