AddNew/Edit/Delete w/CRecordSet
-
I'm having a major brain freeze at the moment, which sucks cause I feel like an idiot, but... Can anyone give me a short concise example of how to add/edit/delete a record froma database using CRecordsets? I have it open and I can append to it, just not sure where to put the data that I am adding or updating. Or point me to a nice resource online. I had this all once but lost my examples in a comptuer crash. And I'm not sure where I got my previous method for doing this. Thanks for anyhelp on this. The wisest of the wise may err. - Aeschylus
-
I'm having a major brain freeze at the moment, which sucks cause I feel like an idiot, but... Can anyone give me a short concise example of how to add/edit/delete a record froma database using CRecordsets? I have it open and I can append to it, just not sure where to put the data that I am adding or updating. Or point me to a nice resource online. I had this all once but lost my examples in a comptuer crash. And I'm not sure where I got my previous method for doing this. Thanks for anyhelp on this. The wisest of the wise may err. - Aeschylus
:)hope these links will help.. http://www.codeguru.com/mfc\_database/querydef.shtml http://www.codeproject.com/useritems/ADOClasses.asp http://www.codeguru.com/mfc\_database/ http://freespace.virgin.net/paul.maker/examples.htm cheers.. Himanshu
-
:)hope these links will help.. http://www.codeguru.com/mfc\_database/querydef.shtml http://www.codeproject.com/useritems/ADOClasses.asp http://www.codeguru.com/mfc\_database/ http://freespace.virgin.net/paul.maker/examples.htm cheers.. Himanshu
Those links helped me to realize I can do what I need via SQL and the database connection. Not exactly how I wanted to do it, but since I can't quite get down the method using the AddNew() and the other, I will use SQL until I can find a precise example of what I need. thank you much for the links though. The wisest of the wise may err. - Aeschylus