ADO recordset without connection
An easy way to do this is to open the recordset against the table with a
query that returns no records.
rst.open "select * from T where 1=2",cn
Then you can do
to add records to this table.
Thanks for your reply it works, Is there any other way of doing this.Since I
am holding the data in a recordset which does't know any thing about
database and query.
I got connection object,query string and want to pass to the recordset and
update the records.
Explanation of Scenario is user want to add some brand new data into the
table(which already has thousands of records) from a Form.So I created a
recordset with all the fields on the form(represents multiple tables
columns).User enters data and now he wants to save this record into the
I know the dsn and Query string but i want to pass this information to the
recordset and execute update.Is it possible or do we have any other way of
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!