As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.
To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email email@example.com.
I recently created a table spec with several columns where a null value is OK.
My assumption was, with a table spec when you set a columns required attribute it should create the table accordingly. So, can anyone tell me how I setup the table spec to allow NULL values for Int, TinyInt, SmallInt columns?
Unfortunately this is not supported through the SDK. I've always just used -1 as the default value and then nullif(COLUMNNAME, -1) in my code, not ideal but it works.
You can always write an alter script and have that ran as part of the deployment if the above mentioned hack isn't up to your liking.