We have a very complex DOS-application using Btrieve, now some modules come new as VB-applications. We use SQL2000i/SDK with the latest service-packs.
In our DOS-application there are several functions which lock records explicit (i.e. an order which is locked as long a user edit this order).
In our new windows application (VB and PervasiveOLEDB) we didn't find a possibility to lock a record. Pervasive OLEDB doesn't know the LockType "adLockPessimistic", and "HOLDLOCK"-attributes in SQL-statements will be ignored.
Because DOS- and Windows-applications use the same databases we need a compatiblity in this case.
Can somebody help me?
Ronald Hoehn
In our DOS-application there are several functions which lock records explicit (i.e. an order which is locked as long a user edit this order).
In our new windows application (VB and PervasiveOLEDB) we didn't find a possibility to lock a record. Pervasive OLEDB doesn't know the LockType "adLockPessimistic", and "HOLDLOCK"-attributes in SQL-statements will be ignored.
Because DOS- and Windows-applications use the same databases we need a compatiblity in this case.
Can somebody help me?
Ronald Hoehn