Search/replace a boolean field

mdPartnerNL
mdPartnerNL Member Posts: 802
edited 2012-06-22 in NAV Tips & Tricks
I've found this by accident while renaming,renumbering fields

You can't search and replace on a Checkbox

> Export the form with the checkbox to .txt
> Edit the .txt and change ;CheckBox; to ;TextBox;
> Import the .txt and compile

and now you have a Yes/No field and .. search/replace works

ps.
I have seen this done without a .txt file too. Please let me know how?

Comments

  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    hehumm :)

    > in CA/L just add a text field to a form
    > change the source expression to a boolan field
  • RWendler
    RWendler Member Posts: 1
    In this case i would create a report with the record as the dataitem and set a tableview to change only selected records. After it, you can easily write two line code in OnAfterGetRecord:

    BooleanField := TRUE/FALSE;
    MODIFY;

    Press Strg+r and run the report. This ist much more effectiv.
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    Yesterday I spend 15 minutes explaning the customer to use ctrl+Home key. Not realising in German this is called Strg+Home. :)

Categories