Salesforce

Using a MSSQL Table with Bigint Fields (Magic xpa 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Using a MSSQL Table with Bigint Fields (Magic xpa 3.x)

Objective

Magic xpa supports numbers up to 18 digits. However, with a bigint field on an MSSQL table you can have a lot more digits and Magic xpa maps the field to be Alpha instead of Numeric.

Solution

There are two options for working with the bigint data type:

  1. Working with a string – The main problem here is calculations that you will have to do. If these calculations won't need more than 18 digits you will need to convert the Alpha to Numeric and back. If the calculations will need more than 18 digits it will be a lot more problematic.

  2. Working with the XXLNumericSize=Y special setting in the [MAGIC_SPECIALS] section of the Magic.ini file – This special allows numbers up to 38 digits in Magic xpa. However, it will decrease the performance of the Magic xpa engine, but calculations will not be complicated (for the developer).

Reference
Attachment 
Attachment