cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

How to store null value or empty value in numeric field of infotable

AP_10343008
15-Moonstone

How to store null value or empty value in numeric field of infotable

How to store null value or empty value in numeric field of infotable

5 REPLIES 5
Velkumar
19-Tanzanite
(To:AP_10343008)

Hi @AP_10343008 

 

You can assign a null value to your field and add a row to infotable

 

Velkumar_1-1698819847309.png

 

/VR

 

 

AP_10343008
15-Moonstone
(To:Velkumar)

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. 

Velkumar
19-Tanzanite
(To:AP_10343008)

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)

Velkumar_0-1698830497123.png

Based on this, if you are storing data in DataTable it is not possible to have null primary key value

 

/VR

AP_10343008
15-Moonstone
(To:Velkumar)

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.

Velkumar
19-Tanzanite
(To:AP_10343008)

Hi @AP_10343008 

 

Could you please post some screenshots to understand better

 

/VR

Announcements


Top Tags