Problem migrating from 7.2.06 to 8.4.05 and 9.4.01

Author: mail@gandg.it (TheAleph)

Fields defined as Boolean (CheckBox) without Initial Value in 7.2 if not checked is stored in Oracle as field value F (False) if checked is stored in Oracle as field value T (True) after migration to 8.4.05 and from here in 9.4.01 if not checked is stored in Oracle as field value blank (!!!!!) if checked is stored in Oracle as field value T (True) !!!! Why blank ???? I can't insert F into initial value ; this will fail retrieve if I have to select records with both T & F (so it must to be blank). Please help me, thanks. Roberto

2 Comments

  1. Hello Roberto, we had the same problem years ago... we needed to put $STORE_BOOLEANS_AS_FALSE into our asn file(s). According to Uniface Library 9.5: $STORE_BOOLEANS_AS_FALSE When storing an uninitialized boolean, assign to it the value of FALSE, as in Uniface V7.2. In Uniface V8, the default value assigned to an uninitialized boolean is NULL, whereas in V7.2 it was assigned the value FALSE. To restore V7.2 functionality, include this assignment setting in your assignment file. Kind regards, Zdeněk PS: If I remember it correctly, the checkbox (boolean field) has to be painted or included in selectlist, otherwise it is stored as NULL anyway.


    Author: sochaz (zdenek.socha@fullsys.cz)
  2. Thanks Zdeněk for your answer, It works !! Problem solved Bye Roberto


    Author: TheAleph (mail@gandg.it)