Note on this:
As soon as you apply the format$() function, the original full accuracy
number is turned into a string with only 6 decimals and the rest is lost
"for ever".
As long as MapInfo shows the number with 3 decimals, the rest of them is
still there behind the scenes and ready to be used in any calculation.
Regards
Uffe
----- Original Message -----
From: "Driver, Greg 9434" <[EMAIL PROTECTED]>
To: "'Sprenz, Marty'" <[EMAIL PROTECTED]>; "Mapinfo-L"
<[email protected]>
Sent: Thursday, July 28, 2005 5:44 PM
Subject: RE: MI-L Query field properties
You could use Format$() -
format$((val(Mid$(LONGITUDE,3,3)) + (val(Mid$(LONGITUDE,6,7)) / 60 )) *
(-1), "#.######")
Greg.
-----Original Message-----
From: Sprenz, Marty [mailto:[EMAIL PROTECTED]
Sent: 28 July 2005 16:24
To: Mapinfo-L
Subject: MI-L Query field properties
Is there a way to format the properties of a field in a query? The
function
that Uffe helped me with is great but it only goes out to the 3rd decimal
place. I need it to go to the 6th decimal place.
Cingular Wireless
Marty Sprenz (RF Engineer - Contractor)
100 Concourse Pkwy
Birmingham, AL 35244
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Office: 205-444-3572
Mobile: 404-509-9820
Internet communications are not secure and therefore Surrey Police does
not
accept legal responsibility for the contents of this message. This email
and any attachments may be confidential. They may contain privileged
information and are intended for the named addressee (s) only. They must
not
be distributed without our consent. If you are not the intended recipient,
please notify us immediately and delete the message and any attachments
from
your computer, do not disclose, distribute, or retain this email or any
part
of it. Unless expressly stated, opinions in this email are those of the
individual sender, and not of Surrey Police. We believe but do not warrant
that this e-mail and any attachments are virus free. You must therefore
take
full responsibility for virus checking. Surrey Police reserves the right
to
monitor all email communications through their networks.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17299
