If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

ADO AddNew gets no error but does not add

I am using ADO and can read the recordset from beginning to end. When I get to the end I am trying to add records but they do not get added. I am using a SQL Select with adOpenDynamic for CursorType when opening the table. After opening the following are both true:

The EditMode is 0 before the AddNew, 2 after the AddNew and 0 again after the Update. There are no errors but thare are also no records added. Is there anything more I need to do to get the records added?

I did forget to search the current KB. I did search the MSDN I have installed in my system but it is an old copy. I also searched the current SDK documentation for AddNew. There are samples of AddNew in the SDK documentation. I did not see anything more that is needed in the samples I found. I will look at the sample in that KB article.

I suspect that the problem might be related to the fact that I read the recordset first. If so then the samples are less likely to help. I posted this question in case someone experienced with ADO knows the answer. I have already spent a lot of time trying to find the answer but I am continuing to look.

The ReadMe.txt file for that sample in that KB article made clear something that the documentation does not make clear and that is easily overlooked in the sample. Now that I know the answer the documentation seems clear enough. The answer is that "you must use the AddNew and Update in the IADORecordBinding interface to make changes to the recordset". So I changed:

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.