>>>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