Hi Scott,
Locking remote views don't lock underlying tables on backend. In order to lock them, you need to execute database's native command like Oracle has
LOCK TABLE. I don't know its equivalent in SYBASE but you can go through help to find it out.
Bye
Jayesh
>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
- Jayesh