var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete a record on a Join rs with ADO
I have to edit or delete a record of the side "one" of a join.
DAO simply edits or deletes the record of the main table. With ADO, i get an error ("no information for key column"). Can I set an option, or something like that, to let ADO knows the main table ?
The only workaround I found is to find that record on another recordset (just the main table); edit or delete it; refresh the join recordset. I'd rather do on the join recordset itself.
Many thanks in advance.
Which database are you using ? What is your original query that creates the recordset ?
I have this problem with Access 2000 and with SQL Server. I'm pretty sure it's an option to set on the ADO recordset...
The join is a classical inner join between two tables (main/detail).