Re: ADO 'AddNew' fails to add first record.

Bob Barrows [MVP] wrote:
ADODB::_RecordsetPtr pRecordset;
TESTHR(pRecordset.CreateInstance(__uuidof(ADODB::Recordset)));
pRecordset->Open(TABLE_NAME, _variant_t((IDispatch
*)pConn,true),ADODB::adOpenKeyset, ADODB::adLockOptimistic,
ADODB::adCmdTable);

This is the only potential problem I see: I believe that adOpenKeyset
and adCmdTable are mutually exclusive.

Actually, i'm not sure of this statement. You should check the value of the
CursorType property after opening the recordset (at runtime) to see what it
is

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: How to summarize recordset...Select Distinct alternative?
    ... and disconnect it before processing it (after opening it) ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Clearing a Table (Access MDB file)
    ... they will have the DSL going again when I get home tonight. ... Phillip Windell [MCP, MVP, CCNA] www.wandtv.com "Bob Barrows" wrote in message ... This email account is my spam trap so I> don't check it very often. ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL Stored Proc - ASP Page - Return Value
    ... >> There are few (let me rephrase that) none on here that I have worked ... > While complimenting one, you might want to try to resist such an ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: displaying a only part of a field along with other fields of a recordset
    ... Bob Barrows wrote: ... > him to apply proper database design techniques to it. ... > Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Assistance needed: Cant timeout calling MSXML2.XMLHTTP control
    ... When I take out the echo statements in the original code, ... Doesn't using sleep negate the value of using an asynchronous Send? ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)