Problem on SQL-Update Statement with a Data-Control in VB 5 and SQL Server 7.0
That comes from using Optimistic Locking by Row Values.
This method of locking allows the UPDATE statement to fail gracefully when someone else has edited the row you are trying to update between the time when you read the row and the time you try to update it.
Read up on locking strategies particularly Optimistic Locking by Row ID which may be better for your application.
Regards,
Simon Jones
MillStream Designs Ltd
Independent IT Consultants
Im using the Data-Control in VB-5 and connect to a SQL-Server 7 using
the DAO-Type. If I change a record, the ODBC-Driver generates an SQL-
Statement like the following:
Update POS Set Pos_TEXT = 'Monitor' WHERE xxx = xxx, xxx = xxx
The Kriteria for the Record is including all other Fields of the
record and not only the Key-Column.
Has anyone an idear?
Mfg Robert Holzmann
Austria / Salzburg
