Hi Kevin,

It's easy to calculate Max # of record using HEADER() and RECSIZE() functions

ln2Gb = 2*1024*1024*1024
USE mytable
lnMaxRecs = FLOOR( (ln2Gb - HEADER() -1 ) / RECSIZE() )

>Been a while since I posted on here, hope everyone is keeping well.
>
>I'm writing an app and due to the large amounts of data it's going to be storing I need to be careful about the 2Gb table limit.
>
>2 questions really:
>
>a) Is it possible to project table-size, if I have a table with say, 4 columns, would I be able to get a "rough" idea of how many records it will populate without reaching the limit?
>
>b) Secondly, I want to ensure that the 2Gb limit won't be reached, what's the best way to ensure it doesn't reach it? If there is an answer to question a then I'll keep an eye on the record count, however if this is not possible I'll need some other mecahanism.
>
>Thanks
>Kev