Replace string in masterdata

Hello.
I have Fr3 file. and in this file there masterdata.
in this masterdata there is column that is named as [frxDBMain."salary"]

and i have one problem.
in my salary column there is some values that equal to zero.
i want to replace this 0 values with '-'.
can you help me?

Comments

  • Anu de DeusAnu de Deus Hampshire, UK
    edited 11:20PM
    Test this carefully, might not display correctly under some circumstances (try with lots of records in the dataset):
    procedure memo1OnAfterData(Sender: TfrxComponent);
    var
      lTxt : string;
    begin
      lTxt := VarToStr(Value);  // lTxt is not required, but good for debugging                             
      if lTxt = '0' then                 
         TfrxMemoView(sender).text := '';
    end;
    
  • edited 11:20PM
    Thank you.
    your code solved my problem.
    again thanks a lot.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.