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