Results 1 to 2 of 2

Thread: Addnew Record Problems

  1. Mar 3rd, 2002, 09:11 AM #1
    loones
    loones is offline

    Thread Starter
    New Member
    Join Date
    Feb 2002
    Location
    malaysia
    Posts
    8

    Addnew Record Problems

    first of all, i using ADO control to connect database. the problem is
    instead of adding new record, they overwrite the current record..So how izit actually to add a new record?

    this is the code i use to add a new record

    DataSchedule2.Recordset.UpdateBatch adAffectCurrent
    DataSchedule2.Recordset.AddNew

    help plz
    Reply With Quote Reply With Quote
  2. Mar 5th, 2002, 05:35 AM #2
    oh1mie
    oh1mie is offline
    Frenzied Member oh1mie's Avatar
    Join Date
    Sep 2001
    Location
    Finland
    Posts
    1,043
    Try this

    DataSchedule2.Recordset.AddNew
    DataSchedule2.Recordset.UpdateBatch adAffectCurrent
    oh1mie/Vic

    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