Skip to main content

1 reply

19-Tanzanite
November 1, 2023

Hi @AP_10343008 

 

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

 

Velkumar_1-1698819847309.png

 

/VR

 

 

16-Pearl
November 1, 2023

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. 

19-Tanzanite
November 1, 2023

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