Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Schema Boolean Default value

Avatar

Level 2

Hi All,

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?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi,

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.

Regards,

Vipul

View solution in original post

3 Replies

Avatar

Employee

Hello Andrea,

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.

Avatar

Correct answer by
Employee Advisor

Hi,

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.

Regards,

Vipul

Avatar

Level 2

Thank you very much for your support guys!

It is working.

Best,

Andrea