What about the currency type... does this take up less space ?




>>Hi.
>>I've hit the 2 gig lim on a file in an app
>>It would be a huge job to start splitting up the file , or going to SQL SERVER so i'm trying to identify other options,
>>There arent that many characyer felds that I can reduce, but there are a few numeric fields I could optimise.
>>I have these now set to N 17 2 and would need to allow for 999,999,999.99
>>Whats the Least otimum numeric data type for this ??
>>Also, if there are any other suggestions ?
>>
>>Regards,
>>
>>Gerard
>
>Well I make that N 12 2 should do - no?
>If you don't need the dec places then integer would just do it.
>
>See "Data and Filed Types" in Help for capacities.
>
>HTH
>
>Terry