Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
How to store null value or empty value in numeric field of infotable
Thanks. In the scenario iam using two columns together as primary key. One column is string datatype and another column is number datatype together considering as unique row. In Some combination i want to leave number column empty. As number column is primary key, it should not be empty. So how to pass null value to number column even if it is primary key.
Hi @AP_10343008
Please refer to this article - Article - CS352005 - Getting Key field [xxx] had no value exception when adding data table entry without primary key value in ThingWorx Platform (ptc.com)
Based on this, if you are storing data in DataTable it is not possible to have null primary key value
/VR
Ok Thanks. Then Ill Add any dummy data.
Is it possible to show the unique id column in grid, at the same time the particular value "part" in the column need to be invisible as it is supposed to be blank.