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: 373317 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 8:41:40 AM         
   


> >
> >
> > No. I mean the tables that will be used later on an SQL SELECT anywhere in your form should be opened SHARED. Because if not, SQL SELECT will open those EXCLUSIVE.
> >
> > http://sandstorm36.blogspot.com
> > http://weblogs.foxite.com/sandstorm36
>
> That's only true if you have Set Exclusive On. I have always had it off as default, and have never experienced any similar problems.

And I wonder why VFP has seem it fit to SET EXCLUSIVE on the ON status as default. With the demand for multi-tasking in the later life of VFP or databases, they should have changed the default to OFF. :-)


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