' in dbField

yvesarchambault

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

gordk

try placing your fields in the memo instead of concatenating
[Trim(<Cheque."STAT">)] [Trim(<Cheque."PRENOM">)] [<Cheque."NOM">]

yvesarchambault

Thanks, it working.