Alpha Video Training
Results 1 to 2 of 2

Thread: Overwritten / Disappearing records

  1. #1
    Member
    Real Name
    Trent Thomas
    Join Date
    May 2006
    Posts
    7

    Default Overwritten / Disappearing records

    We have A5v1.0.2 running on XP machines in our small network. The applications we're using were originally created back in A4 for DOS, and ported over to A5. There are several different databases, one for each sales division in our company, and we use them to track detail on loads sold by our sales force.

    Recently, in about the last 3 months, we began to occasionally "lose" records. I'm not sure exactly what is happening, but it seems that the data input for a record (either a new record or an edit of an existing record) will overwrite another existing record, causing the second record to be completely lost.

    It seems to be somehow related to the method we use to change from one record display to another - using the "PgUp" or "PgDn" keys to move sequentially does not cause a problem, but if we use the "locate" function to skip directly to another record there is a chance that record Will disappear.

    Any ideas what might be happening, or suggestions on how to fix the database files?

    Thanks.

  2. #2
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,874

    Default

    When you do a "locate", does the record pointer actually get updated? Or would it be better to then do a "Find" or use some other method to insure that you are actually AT the record you think you are. It seems that the locate doesnt actually retrieve the record into the "current record", so when you begin changing, you are actually changing some other record (most likely the last successfully retrieved record)

    Just my thoughts.

    Tom

Similar Threads

  1. Disappearing files
    By kyoshi1 in forum Alpha Five Version 7
    Replies: 0
    Last Post: 12-19-2005, 12:08 PM
  2. disappearing look up value
    By Fred Sides in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-28-2004, 09:27 AM
  3. adb files being overwritten
    By Mark Milton in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-16-2003, 12:31 AM
  4. disappearing records
    By Jeff, Richards in forum Alpha Five Version 5
    Replies: 3
    Last Post: 06-24-2003, 04:11 PM
  5. The disappearing A4V7
    By Joan Hannan in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 01-11-2003, 02:26 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
  •