I'm having difficulty working out the locking mechanism using VB5 and
SQL Server 6.5 using stored procs ( and RDO).
You can only declare a read only result set against a stored proc. How
now, do you lock, either optimistically or pessimistically, the
records in SQL server.
Two possible methods : Implement the ODBC scheme of keeping a copy
locally and then re-reading the server data to detect change or
implement a semaphore locking table on the server.
Any advances?