Delphi-PRAXiS - Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)

- Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)

- - Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros (https://www.delphipraxis.net/197174-secrets-firedac-dynamic-where-clause-using-conditional-substitution-macros.html)

DP News-Robot

20. Jul 2018 00:10

Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros

If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called Macros which allows you to do a variable substitution in your SQL query similar to parameter substitution but for raw SQL. However, in addition to macro substitution you can combine it with

conditional substitutions which lets you do the real magic.

If you

Alle Zeitangaben in WEZ +1. Es ist jetzt 20:15 Uhr.