function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
John SaundersJohn Saunders 

Custom Fields of Type Integer?

Although the API reference mentions several fields of type "int", I don't see a way to create a custom field of that type. Did I overlook something?

Creating a field of type NUMBER(8,0) produces a double, which is not what I had in mind.


P.S., what I had in mind was a fixed-point, preferably integer, field to hold a unique integer id from a foreign database. I have this terrible fear of non-normalized floating-point numbers, or of the fact that there's more than one way to represent the number 1 as a double...


John SaundersJohn Saunders

Anything new on this?



You still get end up with a real number that you will have to convert to an integer.

perhaps you could use a string field ?
John SaundersJohn Saunders

Thanks for the replies. I hate to leave threads hanging.

Just a "word to the wise": considering that most modern programming languages and databases support an integer data type, one is forced to wonder why doesn't allow the creation of custom integer fields. It would be interesting to know the reasoning behind this, as one is otherwise left to speculate that reason may not have been involved in the decision.