Hi all,

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!

Any ideas?

Thanks in advance for your help.

Ben