- Buck Woolley
- PowerBuilder
- Friday, 31 March 2023 10:27 PM UTC
Within the [MS_SQLSERVER_SYNTAX] section of the pbodb190.ini file the SelectDefault parameter doesnt seem to be working. So the dw.update() is trying to insert NULL values into not null columns. All the constraints have been defined in the database to provide default values for these columns. This was working in the prior version Powerbuilder 10. Is there a setting or config that I am missing that prevents the defaults from being set when the insert syntax is being created?
The parameter is SelectDefault='select y.name, x.text from syscomments x, syscolumns y where x.id = y.cdefault and y.id = OBJECT_ID(''&TableOwner.&TableName'')' and seems to be correct.
Thanks...
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.