June 23rd, 2003, 07:05 AM
Updating multiple tables using CRecordset and SQL
wondering if anyone knows how to update data derived from multiple tables in an SQL query using CRecordset and CDatabase objects?
For example, I have an SQL query that performs a join on two tables to derive its data, however, when I try to update the data i get the error "Recordset is read only".
After several hours reading, I am starting to think that this isnt possible, but doesnt seem right!
Thanks in advance for your help.