ALTER TABLE USR_TABLE ALTER COLUMN USR_COLUMN BIT NULL;

John Zack
John Zack New Member
Tenth Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud CRM Developer Discussions

Hi All,

Does anyone know how to allow null for a bit column in a table spec for CRM? I can run this alter statement and set it after the fact but if its ever load spec'd again it will revert.

Thanks in advance!
John

Comments

  • Charles Harkins
    Charles Harkins New Member
    Third Anniversary Facilitator 1

    Unfortunately, this is a limitation of the SDK. The LoadSpec routine will not allow for the creation of nullable columns for bit, numeric (int, tinyint, long etc) and currency (money) fields. They all must have at least a default value, or one must be provided on insert. Exceptions include uniqueidentifier and datetime.

Categories