Alpha DevCon 2018
Results 1 to 4 of 4

Thread: Various problems

  1. #1
    Member
    Real Name
    Robert Westbrook
    Join Date
    Mar 2012
    Posts
    3

    Default Various problems

    I am trying to restore a fractured database - ( bunch of data and tables ) in a single line comma delimted database.
    I hit a point in joining two of the tables where I get an error message telling me I tried to move a pointer to the beginning of a file. This isn't correct.

    Also, I notice that when my dbf file passes 2.1 gig - I start throwing errors like this. Is there a limit on file size?

    Finally, what is the difference between join and intersect tables. The docs aren't clear on it.

  2. #2
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,775

    Default Re: Various problems

    2GB is the limit on DBF tables. That's not an Alpha restriction, its universal for that database type.

    By "fractured" do you mean normalized?

    Join will combine the two tables (master and transaction), including all unique records from both tables based a selected primary key
    Intersect is exactly the same BUT the resulting table will only contain records from the master table based on the selected primary key.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  3. #3
    Member
    Real Name
    Robert Westbrook
    Join Date
    Mar 2012
    Posts
    3

    Default Re: Various problems

    I buy data from various governmental concerns. This particular base was created by a moron who felt he had toa create a table for everything. I get it broken up and need to restore it to it's original single line comma delimted form (thus making it useable for my purposes)

  4. #4
    Member
    Real Name
    Robert Westbrook
    Join Date
    Mar 2012
    Posts
    3

    Default Re: Various problems

    and thanks for the info. I'll reduce the size by cherry picking the fields I need.

Similar Threads

  1. .and. problems
    By Blake in forum Alpha Five Version 6
    Replies: 15
    Last Post: 10-07-2005, 05:56 PM
  2. Several Problems Please help
    By Michelle Murphy in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-05-2004, 09:34 AM
  3. Two problems
    By Curtis Nunn in forum Alpha Five Version 5
    Replies: 4
    Last Post: 06-15-2004, 11:44 AM
  4. Problems ...
    By drgarytraub in forum Alpha Five Version 5
    Replies: 12
    Last Post: 04-10-2003, 01:57 PM
  5. Two problems
    By Phyllis B. Quarg in forum Alpha Five Version 4
    Replies: 4
    Last Post: 03-26-2001, 08:37 AM

Posting Permissions

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