>What about the currency type... does this take up less space ?
Sure - only 8 bytes. But I've never used that and don't know what the disadvantages might be
>
>
>
>>>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.