Function getdatatypedb - Data type of database of specified column and specified row

Writing functions:

getdatatypedb(table, column)

Where table is a variable returned by the opentable function, column is a number, row is a column name or column index, where numbering starts from 0 (from the 1st column)

This function returns a specific data type. The return value is numeric:

Data type	Data size, bytes	Return value
Bytes - up to 256	1	1
Short - up to 32000	2	2
Integer - up to ~ 2 billion	4	3
Big Integer - up to ~ 9 quintillion	8	4
Float - up to 10^306	8	5
String	Variable length	6
Date/Time	Variable length	7
Exact time value	Variable length	8
Extreme number	Variable length	9
Coordinate	Variable length	10
Extreme Fraction	Variable length	11
Formula	Variable length	12
Matrix / Array	Variable length	13
The coordinate matrix	Variable length	14

Note
- "Exact time value" - not used yet.
- Return values greater than 8 are used only in the internal database.

 

 

Help on built-in functions
The rules of programming scripts
Programm options
Color constants