I use FDquery(Firedac), Uniquery(UNidac) to query ms access database on delphi. select asset &" - "& asset_n as nooot from t_komp. this query combines two columns without "-" sign.

NOTE: if I use ADoquery, this query works well.

I use FDquery(Firedac), Uniquery(UNidac) to query ms access database on delphi. select asset &" - "& asset_n as nooot from t_komp. this query combines two columns without "-" sign.

NOTE: if I use ADoquery, this query works well.

• sql
• delphi
• firedac
• unidac

• & is a special character for FireDac related to client side preprocessing. It denotes a substitution variable. Ref: docwiki.embarcadero.com/RADStudio/Sydney/en/… Try setting ResourceOptions.MacroExpand to false. – Brian Commented Jan 19 at 17:42

1 Answer 1

The failure might be due to using the character & employed by FireDAC to identify a macro: FireDAC Preprocessing Command Text - Substitution Variables.

You can try two approaches:

1. Set ResourceOptions.MacroExpands to false.

2. Modify your SQL query, depending on your DBMS, to:

   select CONCAT(asset,' - ',asset_n) as nooot from t_komp
   

   or

   select CONCAT(CONCAT(asset,' - '),asset_n) as nooot from t_komp