Mandar D S
January 14th, 2000, 02:37 PM
Hello all,
MSDN mentions a dynamic property called 'Unique Table' for ADO recordsets. Can someone please suggest how to set value for this property? Following is the usage in short:
Consider an SQL having a join on two or more tables. Let a disconnected static recordset with properties, client side cursor and optimistic locking for batch update be based on that query. One can call addnew method and then set values for required columns. However, updatebatch method of such recordsets cannot be called as in normal case due to presence of a join statement. For this MSDN suggests use of a property called 'Unique Table' wherein, the primary key of the 'Unique Table' becomes primary key for the recordset retrieved by join SQL query and that table becomes the default table for update purposes. Thus calling a updatebatch / update statement on such a recordset is equivalent to, calling an exclusive update query, just on that 'Unique Table'. MSDN also proposes the concept of 'Unique Schema', etc. in relation with dynamic properties of ADO connection, recordset objects. However, I could not find how to set the 'Unique table' property, nor could locate some example in MSDN. Please help me out.
Thanks
Mandar
MSDN mentions a dynamic property called 'Unique Table' for ADO recordsets. Can someone please suggest how to set value for this property? Following is the usage in short:
Consider an SQL having a join on two or more tables. Let a disconnected static recordset with properties, client side cursor and optimistic locking for batch update be based on that query. One can call addnew method and then set values for required columns. However, updatebatch method of such recordsets cannot be called as in normal case due to presence of a join statement. For this MSDN suggests use of a property called 'Unique Table' wherein, the primary key of the 'Unique Table' becomes primary key for the recordset retrieved by join SQL query and that table becomes the default table for update purposes. Thus calling a updatebatch / update statement on such a recordset is equivalent to, calling an exclusive update query, just on that 'Unique Table'. MSDN also proposes the concept of 'Unique Schema', etc. in relation with dynamic properties of ADO connection, recordset objects. However, I could not find how to set the 'Unique table' property, nor could locate some example in MSDN. Please help me out.
Thanks
Mandar