Results 1 to 3 of 3

Thread: ADO Recordset Update..?

  1. May 25th, 2001, 04:13 AM #1
    hexed_keiyu
    hexed_keiyu is offline

    Thread Starter
    Member
    Join Date
    Feb 2001
    Location
    Philippines
    Posts
    58

    ADO Recordset Update..?

    Hi!

    How do i cancel my ADO Recordsert from updating if the user has entered an already existing data..i was able to do so when i tried using an SQL Statement but i was wondering about the ".CancelUpdate" property of the recordset..can anyone tell me how to use this properly..pls advice..tnks in advance..!

    Keiyu
    Reply With Quote Reply With Quote
  2. May 25th, 2001, 08:22 AM #2
    seoptimizer2001
    seoptimizer2001 is offline
    Frenzied Member seoptimizer2001's Avatar
    Join Date
    Apr 2001
    Location
    Toledo, Ohio USA GMT -5
    Posts
    1,075
    After you find out whether or not the record already exists use rs.update if it doesn't and rs.cancelupdate if it does.
    Reply With Quote Reply With Quote
  3. May 25th, 2001, 09:51 AM #3
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    Or, just set the value back to it's original. For instance.

    Code:
      '//User makes some changes, but decides to cancel now...
  txtFirstName.text = RS!FirstName
    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