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