I'm trying to create a Boolean field into my custom schema with default value set as "true".
I tried with the following statement:
<attribute default="true" label="Export to FOX" name="foxExportFlgg" type="boolean"/>
Unfortunately the default value is always set as false.
This is the generated SQL code:
ALTER TABLE NmsDelivery ADD iFoxExportFlgg SMALLINT;
UPDATE NmsDelivery SET iFoxExportFlgg = 0;ALTER TABLE NmsDelivery ALTER COLUMN iFoxExportFlgg SET Default 0;ALTER TABLE NmsDelivery ALTER COLUMN iFoxExportFlgg SET NOT NULL;
Could you please help me?
Please use the sqlDefault attribute and set it to value of choice.
Boolean field at SQL level transforms to an integer of 8 bit and can hold value as 0 or 1. 0 corresponds to False and 1 corresponds to True.
If you use the code like this it will work as required
<attribute default="true" label="Export to FOX" name="foxExportFlgg" type="boolean" sqlDefault="1" />
Hope this helps.
Thank you very much for your support guys!
It is working.
I believe the SQL script is generated when you try to update the DB structure . If this is true , the script is editable.
Can you change the SET DEFAULT to 1 from 0 and see if the default changes to True.