Alpha Video Training
Results 1 to 2 of 2

Thread: File display data but access not available

  1. #1
    Member
    Real Name
    robert adler
    Join Date
    Apr 2000
    Location
    Boynton Beach, BL
    Posts
    591

    Default File display data but access not available

    I attempted to enter this request last night but aborted because file is over 3 million bytes.

    I have a production system running for over two years. the file is uses as transactions to post to other files.

    if i sort the file on SSN in table view and do a find by key i find all records related that SSN. If i do a query by table and request the ssn and year applied only one record is retrieved. the other nine records for the year do not appear in the query. If a use the existing posts none of the records are recognized. The same goes for a report that is used. reuslts 0.

    I have built new posts and new reports the results are the same. all processing is done with operations and creations of reports by A5.

    I have compacted, reindexed, copied the file and then appended back to the original file. results are the same. Data is not available to the operations.

    any ideas or help appreciated. I did try to create a smaller version of the file with the offending records, but copy does not see them.


  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: File display data but access not available

    Try creating a copy of the table, zapping the copy, and sending that. Maybe by looking at the table structure, field rules, indexes, etc we can see something.

Similar Threads

  1. limiting data display
    By Peter Wade-Graham in forum Alpha Five Version 6
    Replies: 0
    Last Post: 09-23-2005, 12:47 PM
  2. Text file display
    By Mike Vance in forum Alpha Five Version 6
    Replies: 11
    Last Post: 05-06-2005, 11:17 PM
  3. Display data from alpha table without WebComponent
    By David Brown in forum Alpha Five Version 6
    Replies: 3
    Last Post: 01-12-2005, 05:05 AM
  4. Table lookups -- data display
    By dik_coleman in forum Alpha Five Version 6
    Replies: 2
    Last Post: 12-15-2004, 08:30 AM
  5. Sample Xdialog Script - Display data from a Set
    By Selwyn Rabins in forum Alpha Five Version 5
    Replies: 0
    Last Post: 10-31-2002, 02:43 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
  •