CA Service Management

 View Only

  • 1.  change column type from bool to actbool

    Posted Mar 03, 2025 09:20 AM

    Hi,

    During the implementation of  a new custom field, it was wrongly created as a boolean 0/1 (bool) instead of a actbool (active/inactive).   As both bool and actbool are integer columns in database, I was thinking to update it using the web screen painter to a actbool column. Does anyone had a similar situation? Thank you.



  • 2.  RE: change column type from bool to actbool

    Posted Mar 10, 2025 08:36 AM
    Edited by Cristi Mitrana Mar 10, 2025 08:36 AM

    The info regarding the SREL of the new custom field is kept also in the majic\wsp.mods file and probably declared somewhere else also. Even if the column types are compatible (bool vs actbool) it's better to remove the field and then re-add it correctly so the information is correctly updated in all places.