Alpha Video Training
Results 1 to 5 of 5

Thread: undelete record

  1. #1
    Nora Peeples
    Guest

    Default undelete record

    I recently deleted a duplicate record which contained a client number, but when I deleted it, it also deleted the client number. Is there a way to use the deleted client number again?

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: undelete record

    Except for autoincrement field values, it's generally possible to re-use any values from deleted records in new records. Is this what you meant to ask?

    -- tom

  3. #3
    Nora Peeples
    Guest

    Default RE: undelete record

    Thanks. That's what I wanted to know, unfortunatley, my problem lies with an autoincrement field. So there's no way to reuse the deleted client numbers which are in an autoincrement field?

  4. #4
    Nora Peeples
    Guest

    Default RE: undelete record

    Thanks. That's what I wanted to know, unfortunately, my problem lies with an autoincrement field. So there's no way to reuse the deleted client numbers which are in an autoincrement field?

  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: undelete record

    It can be done, but it's a tedious process and error prone.

    1) turn off the autoincrement field rule.
    2) enter new records and supply number values by hand
    3) conclude by entering a new 'last' record, with the next number you want the series to resume with
    4) turn on the autoincrement field rule.

    Frankly, I've never had much luck doing this, and have reconciled myself to 'gaps' in the numbering sequence.

    -- tom

Similar Threads

  1. Undelete record
    By Doris Davidoff in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-13-2004, 07:13 PM
  2. Undelete or Recover
    By Fletch in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-24-2003, 09:49 PM
  3. Undelete Record
    By forskare in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-21-2003, 07:44 PM
  4. Undelete records
    By Monty Parrish in forum Alpha Five Version 5
    Replies: 7
    Last Post: 09-17-2002, 11:29 AM
  5. Undelete Record function
    By csda1 in forum Code Archive
    Replies: 1
    Last Post: 09-19-2001, 12:01 PM

Bookmarks

Posting Permissions

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