Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum DBF size
Message
From
19/12/2001 09:15:06
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
19/12/2001 09:03:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Maximum DBF size
Miscellaneous
Thread ID:
00596083
Message ID:
00596100
Views:
24
>You can:
>
>
  • Keep the text files as separate files, and only maintain a reference (the filename) in a DBF field.
    >
  • Split the DBF file horizontally, for instance by years.
    >
  • Split the DBF file vertically, if you have more than one large field.
    >
  • Use a database server, like Oracle or SQL-Server, as back-end.

    Hilmar,

    I understand how you could easily split the file horizontally as long as there is something logical like years to use. So you would have to have a logical break to do this? Is there a way to have 2 files and have Foxpro use them like they are only 1? Also, how would you handle the verticle split? Common key between them?

    You just got me thinking and now I want to know... :-)

    Renoir
    • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform