Message: Unable to create server table - MapBasic - 2023

MapInfo MapBasic Reference

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapBasic
Version
2023
Language
English
Product name
MapBasic
Title
MapInfo MapBasic Reference
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:32:32.686312

Issue: An ODBC or Oracle error displays stating, "Unable to create server table."

MapInfo Pro has a type for storing 64-bit (8 byte) integers called LargeInt. LargeInt variables and fields can store all numbers within the limits mentioned below. However, some operations that convert integers to floating-point numbers can result in a loss of precision, because floating-point numbers can store fewer significant digits than a 64-bit integer. Thematic maps are an example of such an operation. If you create thematic maps using LargeInt values that exceed approximately ±9 quadrillion (9 followed by 15 zeros), then the thematic bins may not be correct.

Name Description
SmallInt Whole numbers from -32768 to 32767 (inclusive); stored in 2 bytes.
Integer Whole numbers from -2,147,483,648 to +2,147,483,647 (inclusive); stored in 4 bytes.
LargeInt Whole numbers from –9,223,372,036,854,775,808 to +9,223,372,036,854,775,807 (inclusive); stored in 8 bytes.

Fix: There is no fix at this time.