My problem is this;
I have a disconnected recordset which contains say 3 rows from a sql server database (ado 2.6) and normally i will change this data and then use a mts componet to update the recordset using updatebatch. This works find, the problem I have is when I have the 3 rows in the recordset and I discover that I need to add another row from the database table. Is there a way to issue a query to the database and tell it to append to the existing database??
I have tried to read the new record into a temp recordset then use the addnew on the original recordset and move the temp to the original field by field, however when I use the updatebatch it thinks this record I added is a new record to the database and of course fails on primary key constraint.
February 18, 2005 7:08 PM
February 28, 2005 5:19 PM