CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. August 16th, 1999, 11:03 AM #1
    kuvo
    kuvo is offline Junior Member
    Join Date
    Aug 1999
    Posts
    14

    Recordset.AddNew

    lstrCommand = "select * from MyTable"

    With rs.Fields
    .Append "col1", adInteger
    .Append "col2", adInteger
    End With
    rs.Open lstrCommand, cnn, , , adCmdText
    rs.AddNew
    ---->The operation requested is not supported
    by the provider ???

    Note: the Recordset is opened sucessfully

    Thx

    Reply With Quote Reply With Quote
  2. August 16th, 1999, 11:34 AM #2
    kuvo
    kuvo is offline Junior Member
    Join Date
    Aug 1999
    Posts
    14

    Re: Recordset.AddNew

    Never mind
    The problem is I set
    rsTable.LockType = adReadLockOnly

    It should be
    rs.LockType = adLockOptimistic


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured