I have created a DataShape with an integer as a Primary Key. But it is stored as a decimal value and any query to the data table requires the key ending with the decimal.
For example 1 (integer) is stored as 1.0 (Key) and thus the query search based on key should be 1.0.
This gets worse when there are 2 primary keys in a data shape. It is stored as 1.02.
I dont know what's a good way to get around it....pass every key as a text.string ..i'm not sure what problems this would create. For one, validation based on key is out of the window!.
Retrieving data ...