Alpha Video Training
Results 1 to 6 of 6

Thread: Lost Records Sometimes

  1. #1
    Bruce MacPherson
    Guest

    Default Lost Records Sometimes

    I have a table with 4500 entries when I look at the table in browse mode sorted by record number all the entries are there ordered by record number.
    When I quick sort in ascending order some records disappear.
    When I quick sort in decending order they are all there again.

    When another table does a lookup on this one guess what, they are not all there. :( and this is causing much grief.

    Any suggestions would be appreciated.

  2. #2
    Member
    Real Name
    John Cunradi
    Join Date
    Aug 2000
    Posts
    464

    Default RE: Lost Records Sometimes

    If you are sure that you are not doing a quick-filter by mistake, try pressing F5 to refresh or add/use the show-all operation.

    Hope that helps.

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

    Default RE: Lost Records Sometimes

    'Blank' records will seem to be 'not' there.

    Is it possible you have some blank records that are being sorted to the top of the stack... making it seem like you have a bunch of empty records?

    -- tom

  4. #4
    Bruce MacPherson
    Guest

    Default RE: Lost Records Sometimes

    No filters and the items are in the middle

    I have sent a file

    try Product Id 162-0135

  5. #5
    "Certified" Alphaholic
    Real Name
    Peter Wayne
    Join Date
    Apr 2000
    Posts
    1,728

    Default RE: Lost Records Sometimes

    i just unzipped your table and did quicksorts in ascending and descending order and the product 162-0135 is present in both orders.
    do you have any indexes on the file that might be out of
    date? if you have an index that might be out of date, then
    alpha five might be using the index when doing a quicksort.
    try rebuilding all your indexes. also, make sure that in
    Settings you tell alpha five to remove all .mpx files on exiting - you may have an old query list that is out of date.

  6. #6
    "Certified" Alphaholic
    Real Name
    Peter Wayne
    Join Date
    Apr 2000
    Posts
    1,728

    Default RE: Lost Records Sometimes

    i just unzipped your table and did quicksorts in ascending and descending order and the product 162-0135 is present in both orders.
    do you have any indexes on the file that might be out of
    date? if you have an index that might be out of date, then
    alpha five might be using the index when doing a quicksort.
    try rebuilding all your indexes. also, make sure that in
    Settings you tell alpha five to remove all .mpx files on exiting - you may have an old query list that is out of date.

Similar Threads

  1. lost records
    By Marie Eastman in forum Alpha Five Versions 2 and 3
    Replies: 3
    Last Post: 11-19-2004, 01:12 PM
  2. lost child records-complicated problem?
    By Andy Neufell in forum Alpha Five Version 1
    Replies: 2
    Last Post: 09-11-2002, 11:40 AM
  3. Why do records get lost or changed?
    By Brett Heintzman in forum Alpha Five Version 4
    Replies: 3
    Last Post: 05-14-2001, 04:45 AM
  4. Export - lost records from DB - help
    By Roland Hughes in forum Alpha Five Version 4
    Replies: 7
    Last Post: 05-01-2001, 04:41 AM
  5. Lost Records
    By Ron McCormack in forum Alpha Five Version 4
    Replies: 6
    Last Post: 04-17-2000, 04:14 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
  •