I would like to know the correct way to use the ADO Recordset's Unique Table, Unique Schema and Unique Catalog properties. I have a stored procedure that uses a join and before I am opening the recordset I am issuing these commands:
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
.CursorLocation = adUseClient
.Source = strQuery
.Properties("Unique Catalog") = "QFM"
.Properties("Unique Table") = "RoomBooking"
.Fields("Name") = "NewName"
The column name is not in RoomBooking but it still gets updated.
Is there an obvious explanation for this?