Using VB6-SP2, ADO2.0, SQL7, MTS.
I've got a disconnected recordset (static cursor, batchoptimistic).
When I do an updatebatch, it checks the values in the underlying table
against those in the database. As you would expect, if any of them have
changed it doesn't allow you to update the record.
This can be slow on some tables that contain a lot of fields. Within SQL,
you can add a timestamp to the table, then use that for checking instead,
known as optimistic using rows. This then only checks to see if the
timestamp has changed, which makes the whole thing quicker and more secure.
My problem is that despite adding the timestamp to the table, updatebatch
still seems to be performing an optimistic using values type update. I
cannot find anything in MSDN etc that tells me how to get the cursor to use
row checking instead of values. Can someone tell me how? MSDN describes it
for FoxPro, but not for VB6, which I'm using.