Creating a View Column with "not null" constraint
seidensc 22 Jul 2014 19:27
Within PS Application Designer (PT8.53) I created a CXCR_ID field with a type of Number and integer positions of 10. I inserted this field into a new view, setting the Record Field Properties to a Key, Search Key, and List Box Item. Within the Edits tab I set checked the Required checkbox.
Within the SQL Definition I defined the column as follows:
ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS 'CXCR_ID'
I then built the view. In MicroSoft SQL Server Management Studio (SQL Server 2008 R2) the field is listed as CXCR_ID(int, null). I would like the field to be defined as CXCR_ID(int, not null).
Does anyone know how to create the view in PS Application Designer so that the field is listed as CXCR_ID(int, not null)?
Thank you,
Steve