Using an SQLite Table with Bigint Fields as a Local Table (Magic xpa 2.x)
When working with the XXLNumericSize=Y special setting in the [MAGIC_SPECIALS] section of the Magic.ini file, it is possible to enter numbers up to 38 digits in Magic xpa.
This data is stored in Binary in an SQLite data source and in a Numeric String in a Local data source.
When using XXLNumericSize=Y in one of the fields and copying the SQLite database as a file to be used as a Local data source, you will get an error.
If you copy a server SQLite database as a file from the server to the client and this database contains large numbers, you should specify BINARY () in the SQL -> Type property of the large number column.
Note: Using XXLNumericSize=Y is not recommended since it will decrease the performance of the Magic xpa engine.
Since version: 2.5a
