General information
Category:
Internet applications
Stephane,
If the recordset is the same as the layout in the database and you will be adding any new records from your temp rs. The easiest way to do it would be to retrieve a recordset of the table, setting the recordset to return 0 records. That way you will have an empty recordset but it still points to the table on the server. You can add,delete,update and then write it back with updatebatch command. I have been using ADO and VB for about a year and there are several things to consider. You need to be aware however if you add a record to the recordset and just close the recordset, depending on other recordset properties, it will go ahead and add the new records to the server table even if you did not want to. You would have to use something like the following: rs.cancelbatch rs.close I have some other ways to handle this too if you do not wish to try this or if you have additional questions let me know.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only