Loading Profile...
Hi Folks,
I have a table containing a BIT column (NOT NULL) and created a check box of type boolean in COT 8.7.8.0. When trying to create a new record the Server Default seems not to be inserted correctly. I tried enter the following Default Values in COT:
1
(1)
((1))
What did I wrong?
Regards
Petra
Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.
Twitter,
Facebook, or email.
Server Default is not working for columns of type BIT
-
1Hi Petra,
The Server Default reads directly from the database.
Enter ((1)) as a default value in the appropriate field in your database table then refresh COT.
COT will pick up the new server default value.
Cheers,
JonesyComment -
-
Hi Jonesy,
Thanks for the quick response. I thought that this feature will not rely on the database definition. I will add it in my table.
Ciao
Petra -
-
Hi Petra,
The Code Default (next property down from the Server Default) is the one that doesn't rely on the database value.
Cheers
Jonesy -
