Datamine Discover KB - MapBasic Syntax

Is MapInfo SQL and Expression case sensitive?

kbadmin — Wed, 05 Nov 2025 03:43:33 GMT

For char or string fields, MapInfo expressions and SQL statements are NOT case sensitive.

For example if a cell value was "Test" then if the expression was Value = "test" it would return true.

Can I calculate Log10 in Mapinfo?

kbadmin — Sun, 03 Oct 2021 23:41:47 GMT

Occurrence

MapInfo SQL and Mapbasic syntax is missing a Log10 function. It only has the natural Log, or "ln", which is the "Log(x)" function.

Solution

You can calculate Log10 by the formula -

Log(x)/Log(10)

How do I calculate the area of polygons or length of polylines in my table?

kbadmin — Wed, 17 Mar 2021 02:24:54 GMT

Occurrence

I want to calculate the area for each polygon region in my table.

Solution

In MapInfo Pro, simply double left click on any Region/Polygon, Polyline or Point object to see its area, length, and coordinates.

To add the area/length to a column -

1.Open the Table and navigate to TABLE>Table>Modify Structure and add a field called Area of type Float.
2. Then navigate to TABLE>Update Column.
3. Select the Table as both the Table to Update and Table to get value from. Select the Area as the column to update.
4. Click the Assist button. Select SphericalArea or SphericalObjectLen from the Function list and click OK. You can also use CartesianArea or Ca ...

How do I insert a carriage return or new line when creating a label?

kbadmin — Tue, 09 Nov 2010 06:53:29 GMT

The syntax for a carriage return ('new line') in MapBasic is Chr$(13) or Chr$(10).

E.g. Field1 + Chr$(13) + Field2

For example, to create a label of the HoleID with the Auppm measurement below, use the following syntax HoleID + Chr$(13) + Auppm

Extract Point Symbol Rotation Angle to a Browser Column

kbadmin — Wed, 29 Apr 2009 04:01:52 GMT

Occurence
How do I extract the rotation angle�from a point symbol into a specified browser field?

Solution
Navigate to Table>Update Column in MapInfo, select the table and field to update which needs to be a float type field.
In the Value field type the following syntax:

StyleAttr(ObjectInfo(obj,2),4)