AnsweredAssumed Answered

How do you solve vardefs mismatch with checkbox fields  on Microsoft SQL server?

Question asked by Greg Mackey on Apr 27, 2016
Latest reply on Jun 22, 2017 by Greg Mackey

Hi All

 

We have Enterprise 7.6.2.1 running on Microsoft Server on a SQL stack

 

IN a module we have a custom field that is of type checkbox

 

Everytime we run a Quick repair and rebuild on this field we get a "mismatch with Database" hit in the SQL for Differences between the Database and the vardefs..

/*COLUMNS*/

/*MISMATCH WITH DATABASE - concluded -  ROW [name] => 'concluded'  [type] => 'bit'  [len] => '1'  [default] => '0'  */

/* VARDEF - concluded -  ROW[required] => ''  [name] => 'concluded'  [vname] => 'LBL_CONCLUDED'  [type] => 'bit'  [massupdate] => ''  [default] => '0'  [no_default] => ''  [comments] => ''  [help] => ''  [importable] => 'true'  [duplicate_merge] => 'enabled'  [duplicate_merge_dom_value] => '1'  [audited] => ''  [reportable] => '1'  [unified_search] => ''  [merge_filter] => 'disabled'  [calculated] => ''  [len] => '255'  [size] => '20'  [dbType] => 'bool'  */

ALTER TABLE sior_referrals DROP CONSTRAINT DF__sior_refe__concl__33FF9E21;

ALTER TABLE sior_referrals ALTER COLUMN concluded bit NULL;

ALTER TABLE sior_referrals ADD   DEFAULT 0 FOR concluded;

;

Now we can execute this SQL all we want but it does not resolve the missmatch.

 

I know the DB is essentially valid, but I would rather clean this sort of thing up.

What can be done to resolve this?

 

Regards

Greg

Outcomes