Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table too large
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01379241
Message ID:
01379276
Views:
35
>>>>Hi Gang!
>>>>
>>>>In this app, I have some code doing an INSERT INTO command, adding records to a FREE table.
>>>>
>>>>The user can select how much data they wish to place into this table, to be converted into a text file, then sent by the internet to another location.
>>>>
>>>>Problem is, they COULD chose a lot of data to send at one time.... enough to overload the table and get it over 2 Gigs in size!
>>>>
>>>>Well, I get an error message from the system about it.
>>>>
>>>>Any way to catch this using a TRY/CATCH error trap?
>>>>
>>>>Thanks!
>>>
>>>Yes, try with TRY/CATCH. Also you may try to pre-calculate the size and issue a warning in advance.
>>
>>Is there a particulare error code for this circumstance I can check in the CATCH statement?
>
>I think the error would be NOT A table, but I'm not 100% sure.
>
>See also File "name" is too large (Error 1190)
>
>
>
>The file is too large to be modified.
>
>The file is larger than 2 GB.
>
>Use another method to reduce the file size, and then try again.

Thanks for the info.

The TRY/CATCH worked fine.
Tommy Tillman A+ NetWork+ MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform