' in dbField

yvesarchambaultyvesarchambault Lacolle, Qu?©bec
edited September 2011 in FastReport 4.0
Hi,
I try to concatenate 3 fields values on a memo line.
Stat = 'Mme'
Prenom = 'Florence'
Nom= 'D'Astous' <- that is the problem.
I what to see on the report in the variable ToutLeNom:
Mme Florence D'Astous
so I used the following code 
procedure MasterData1OnBeforePrint(Sender: TfrxComponent);
  var texte: String;                                               
begin
  Texte := Trim(<Cheque."STAT">) + ' ' + Trim(<Cheque."PRENOM">) + ' ' + <Cheque."NOM">;                                    
  Set('ToutLeNom', '''' + Texte + '''');
end;
I receive the following error: Error in expression "Mme. Florence D'Astous": ';' expected
I have try a few variation of that code to bypass the D'Astous problem without success.

Any idea welcome

Thanks

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 3:02AM
    try placing your fields in the memo instead of concatenating
    [Trim(<Cheque."STAT">)] [Trim(<Cheque."PRENOM">)] [<Cheque."NOM">]
  • yvesarchambaultyvesarchambault Lacolle, Qu?©bec
    edited 3:02AM
    Thanks, it working. >

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.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025