Alpha Video Training
Results 1 to 9 of 9

Thread: Disappearing Data

  1. #1
    Member
    Real Name
    Howard Reisdorf
    Join Date
    Jan 2001
    Location
    Montoursville, PA
    Posts
    367

    Default Disappearing Data

    I had a call from a client today and whe was having a unique (to say the least) problem. She has a table with many fields, among them "date" and "charter number". If she selects the date field, then selects to sort a to z, most of the records disappear. If she sorts from z to a, all the records are displayed. The same happens with the charter number field but not any of the other fields. The table is indexed on both date and charter number. The application is running with A5v4.5 run time. I did an index update which didn't do any good. Any ideas?

  2. #2
    "Certified" Alphaholic
    Real Name
    Finian Lennon
    Join Date
    Apr 2000
    Location
    Atlanta, GA
    Posts
    1,805

    Default RE: Disappearing Data

    If the index file itself is corrupted you'll need to replace it rather than update. The easiest way is to go to the index window, select the indexes, Ctr-X to remove, click the lightning bolt, answer yes, then click Ctrl-V and click the lightning bolt again.

    Finian

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

    Default RE: Disappearing Data

    Howard,

    I've seen this occur when the user has entered a bunch of empty records. They sort to the top of the A to Z list, and the display of records (all of which are empty) makes it look like the data disappears. Before doing anything else ask the user to scroll down into the table further.

    -- tom

  4. #4
    Member
    Real Name
    Larry Ternowski
    Join Date
    May 2002
    Location
    Langley BC
    Posts
    238

    Default RE: Disappearing Data

    I had something similar happen today. I ran the database compact and the records came back???

    Larry

  5. #5
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,173

    Default RE: Disappearing Data

    Larry,

    When you compact, all tables are also reindexed. If the problem was an indexing problem, this would be corrected. You could first try just updating the indexes in the affected table.

    Jerry

  6. #6
    Member
    Real Name
    Howard Reisdorf
    Join Date
    Jan 2001
    Location
    Montoursville, PA
    Posts
    367

    Default RE: Disappearing Data

    Good thought, Tom, but I couldn't scroll anywhere. I had about half a screen of data and that was all there was.
    Thanks for the response.
    Howard

  7. #7
    Member
    Real Name
    Howard Reisdorf
    Join Date
    Jan 2001
    Location
    Montoursville, PA
    Posts
    367

    Default RE: Disappearing Data

    Thanks, Larry. I already tried that without success.
    Howard

  8. #8
    Member
    Real Name
    Howard Reisdorf
    Join Date
    Jan 2001
    Location
    Montoursville, PA
    Posts
    367

    Default RE: Disappearing Data

    The application is running in runtime. I don't think there is any way to remake the indexes, only update them. I tried the update, without success. I finally ran the application with the full program, remade the indexes, and the problem went away. Apparently, unless I am missing something, the user has no way to remake the indexes in runtime, unless the programmer has provided it through scripting.
    Howard

  9. #9
    "Certified" Alphaholic
    Real Name
    Finian Lennon
    Join Date
    Apr 2000
    Location
    Atlanta, GA
    Posts
    1,805

    Default RE: Disappearing Data

    It sounds like the index file was, indeed, corrupt since remaking it solved the problem when updating did not.

    The only way to duplicate this action in runtime is to code it. We have an autoindex routine we run nightly on our internet servers. We remove and replace the indexes on key tables as a preventative measure. It's not that difficult to code ...

    Finian

Similar Threads

  1. My data is disappearing
    By Susan Schlueter in forum Alpha Five Version 6
    Replies: 2
    Last Post: 05-17-2005, 10:32 AM
  2. Disappearing Data
    By Paul DeLosa in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-14-2004, 02:31 AM
  3. DATA DISAPPEARING
    By LEGRAN in forum Alpha Five Version 6
    Replies: 5
    Last Post: 08-02-2004, 04:51 PM
  4. Disappearing data in set
    By David Johnson in forum Alpha Five Version 4
    Replies: 6
    Last Post: 04-20-2001, 07:58 PM
  5. DATA DISAPPEARING
    By josephalee in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 01-29-2001, 12:24 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
  •