Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking & Unlocking Remote Views
Message
From
05/10/1998 10:35:41
 
 
To
05/10/1998 07:43:49
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00143807
Message ID:
00143876
Views:
21
Hi Scott ---

Local LOCKs and FLOCKs have no bearing on what Sybase is doing with the table. However, experiment with using different local buffering schemes (CURSORSETPROP); you may be able to optimize server access to avoid locking out other applications. Finally, check your Sybase settings to see how it is handling database requests.

>I have an application that connects via ODBC to Sybase. The app was built in VFP 3.0b. Another application, built in Powerbuilder also goes against the same database.
>
>I have several remote views into Sybase. My problem is my app tends to lock the powerbuilder app after access to a specific table. My app issues an FLOCK() against the table while it is using the data, then issues an UNLOCK IN to release the lock. After this happens, the other app locks.
>
>My second question pertains to the first. Does an FLOCK() issues the lock against the sybase table or only against the remote view, if not, how do I issue a lock against the sybase table and then unlock it when done.
>
>Thanks in Advance.
>
>Scott
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform