ADO Recordset

[User 1275958]

hi all , i am using Ado in mfc and i want to insert a record in the recordset but not in the database. Could i insert a record in recordset after i close the connction to the database. if some one can help pls reply soon ....

[User 1418550]

I am not exactly sure whether it can be done or not, but even it can be done or not, what will you do by inserting a record in a recordset if you do not want to insert it in the database. As far as my knowledge goes, the recordset is used as an interface between the user and the actual database, and once the connection is closed with the databse the recordset will not exist !!! Pankaj

[Kurt _B]

I know you can have disconnected recordsets in ADO. I think you do this by setting the ActiveConnection property of the Recordset to NULL. As far as inserting a record I would imagine it would work. Hope this helps.