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:
01379253
Views:
29
>>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform