As requested I'm posting the SUM for my "algebra question". It seems there are MI
users without MB and the manual doesn't help.
From: "Warren Vick, Europa Technologies Ltd." <[EMAIL PROTECTED]>
As an additional to Ole's list, you can get base 10 (or indeed any base) log
of x from the natural log function using;
(log(x) / log(10))
Replace 10 with any base.
From: Bill Thoen <[EMAIL PROTECTED]>
Square root of n is n^0.5 (n raised to the one-half power) or in
MapInfo, it's sqr(n). Log(n) in MapInfo is actually the natural
log, but to get log-base-10, it's just ln(n)/ln(10), or in
MapInfo it's log(n)/log(10). PI is a constant, irrational though
it may be, and 3.141592654 is pretty close.
- Bill Thoen
From: "Leduc, Yannick" <[EMAIL PROTECTED]>
Hi Dyan,
from the Mapbasic on-line help, here are the math function usable
within MapInfo. Square root (SQR) and Log is there. PI is a number. Ln is
not there but Exp (e= 2.7182818) is. You can include all these functions
when updating a column or run a SQL.
Trigonometric functions: Cos( ), Sin( ), Tan( ), Acos( ), Asin( ),Atn( )
Geographic functions: Area( ), Perimeter( ), Distance( ), ObjectLen( )
Random numbers: Randomize, Rnd( )
Sign-related functions: Abs( ), Sgn( )
Truncating fractions: Fix( ), Int( ), Round( )
Other math functions: Exp( ), Log( ), Minimum( ), Maximum( ), Round( ),Sqr( )
Hope this help...
Au revoir!
Yannick Leduc
From: Ole Gregor <[EMAIL PROTECTED]>
You dont need to export and the functions is inside Mapinfo.
The only problem is, that you need more knowledge about Mapbasic - one
source is Jacques Paris, but it's would bee a great help if Mapinfo Corp.
had included this information in the normal help and reference material.
I have copyed a bit from the Mapbasic help file
The syntax is;
Exp(column) Returns the number e raised to a specified exponent
sqr(column) for square root
log(column) for natural log (ln in normal math)
+ Addition. Example: x = a + b
- Subtraction or negation. Example: x = a - b
* Multiplication. Example: x = a * b
/ Division. Example: x = a / b
\ Integer division (remainder is dropped). For example, the expression:
10 \ 8 has a value of one.
Mod Remainder from integer division. For example, the expression: 10 Mod 8
has a value of two.
^ Exponentiation. For example, the expression: 2 ^ 3 has a value of
eight.
From: <[EMAIL PROTECTED]>
Dyan - You can use the SQR() function for square root, and the LOG() function
for natural logs. PI you'll have to type in. If you use Mapbasic, you could
add DEFINE PI 3.141593 to mapbasic.def.
-Tim Nuteson
Dyan C. Catamaran
Phero Tech Inc.
--------------------------
604-940-9944
604-940-9433
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
