Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Locking & Updating data using vb5.0 & ODBCDirect & VFP 6.0
Hello,
I have a database application that uses data bound controls in VB5.0 SP2 to update data in a Visual FoxPro 6.0 database using an ODBCDirect connection. It works OK except I want to make sure that it works in a multi user environment. At them moment the data bound controls do not give any error when 2 users update the same information at the same time.
I want to be able to lock the current record so that only 1 user can update it a time. I have tried setting the Options property on the data bound control to a suitable value ( eg to 'dbSeeChanges' ) but I get an error when loading the form if the Option is anything other than zero. Also I have tried opening an ODBCDirect RecordSet over the database so that I could lock the current record manually, but I am unable to open a recordset for update ( only allows readonly ).
My question is:
Is there a way of opening an ODBCDirect RecordSet for update over a Visual FoxPro database ?
How can I implement record locking using Data Bound Controls and ODBCDirect, Visual FoxPro ?
Thanks,
Aengus O'Sullivan
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement