Hi Andrew The floating point (float) which is double precision holds numbers to "at least 15 digits of precision". This quote is from Microsoft Visual Studio help. I would have thought this is a bit too close to your requirement though, and that you would be better holding the numbers as a character string.
If you need to convert the string to a number, again you are close to the specification for a double and might not maintain this accuracy. However that is a lot of significant figures! You can use the MapBasic format command to print out more than six decimal places for a double precision number. Hope this helps. Regards Bob @www.MapsByDesign.co.uk Andrew Tracey <[EMAIL PROTECTED]> writes >Dear All > >I have a table containing 68000 records, which has a column, which should have >a >value to 15 decimal places, when I import the data it seems to truncate to 6 >decimal places, is there any way of creating a field, which would hold the 15 >decimal places? > >Thanks in advance > >Andrew Tracey >Information Support Officer >Corporate Information >Corporate Development >South Tyneside Council >Westoe Road >South Shields >NE33 2RL > >Tel: 0191 4247561 >E-Mail : [EMAIL PROTECTED] > >******************************************************************************** >**************** >******************************************************************************** >**************** >Please do not print this e-mail if you can help it - and help protect the >environment. >******************************************************************************** >**************** >This Message may contain confidential information and is protected by >copyright. >If you receive it in error please notify us and delete it without making use >of >or copying it. >The addressee and other employees within the Council may read and copy any e- >mail >reply to this message and other e-mails you send to us. >Whilst we use virus checking procedures we accept no liability for viruses and >recipients >must rely on their own virus checking procedures. >******************************************************************************** >**************** >The Council's web site address is www.southtyneside.info > >_______________________________________________ >MapInfo-L mailing list >MapInfo-L@lists.directionsmag.com >http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- bob young _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
