AddNew with msSQL?

Results 1 to 4 of 4

Thread: AddNew with msSQL?

  1. #1
    Join Date
    Dec 1969

    Default AddNew with msSQL?

    Do "update" and "addnew" work with msSQL server??<BR><BR>My code which works perfectly fine with access <BR>doesn&#039t work with msSQL--I can retrieve records from <BR>the DB, but am unable to modify them. Do <BR>I have to use "update","delete","insert" in my<BR>sql statements instead? <BR>THANKS!

  2. #2
    Raja V. Guest

    Default RE: AddNew with msSQL?

    Yes AddNew works with MS SQL .<BR>The thing you have to take care is that the lock type for your cursor should not be default(i.e adReadonly)

  3. #3
    jknight Guest

    Default RE: AddNew with msSQL?

    Thanks! Good to know-- ... so what *should* the cursor lock type be? :)

  4. #4
    Raja V. Guest

    Default RE: AddNew with msSQL?

    Yeah! I know you might be using default type by accident ;-)<BR>The lock type should be either of <BR>adLockpessimistic/adLockOptimistic/adBatchOptimistic<BR>For detailed info on these type you have an article in this site.<BR>Happy Programming !

Posting Permissions

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