Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: TABLE LOCKED
Thread ID: 373287 Message ID: 373289 # Views: 91 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 20, 2013 7:32:19 PM         
   


> Hi
> I have facing problem with select query in my reports. i am using query for generating reports like this
> select ..... from .. join into cursor ...
> my problem is after generating report all related tables are locked they are usning in query.
> so the other network user face problem (in the bottom status bar. writing on bar "wating for unlock")
>
> i also use set multilock on
> but no effect


Try "Set Exclusive Off" (because it's "On" by default, so that if the SQL "From" table is not open yet, the Vfp SQL engine would do so automatically (desired) in Exclusive mode (undesired).
(FWIW, "Set Exclusive" is one of the settings that are scoped to the current data session.)



hth
-Stefan

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