Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPT file 2GB Limit? A final answer?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00562711
Message ID:
00563276
Views:
19
>>Either way you look at it you are flirting with disaster if your memos are that large. If you have a dbf, fpt or cdx over 2 gig you should consider either redisigning your schema to scale better or use another data engine that doesn't have the size limitation of a dbf/fpt structure, IMO.
>
>Hi Eric,
>
>In pursuit of 'another data engine', I just priced SQL Server 2000 at $4678, which I dont think my client will swallow...
>
>I am going to try to store the data as character records in a table, copy them into an edit box for editing, then strip out carriage returns etc. and save each line as a record back to the table.
>
>I tried to find something that does this in the 'download' section of the UT but was unable.
>
>Thanks for your help.

You can also use MSDE which is the SQL Server data engine. I don't know whats it's limitations are, if any.

You could also try using a compression utility.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform