[fpc-pascal] Create dynamic SQL according to available params

Marcos Douglas md at delfire.net
Thu Apr 7 17:41:40 CEST 2016


On Thu, Apr 7, 2016 at 12:30 PM, Luiz Americo Pereira Camara
<luizamericop at gmail.com> wrote:
> Thanks for all the responses
>
> The Marcos' one is particular interesting since goes in a direction a did
> not think earlier

Thanks. I do this for years.

The major advantage, I think, is doesn't need to change the SQL in pieces.
You can put the original SQL in a Query component or file integrally.
The DBMS engine is smarter enough to optimize all that.

Best regards,
Marcos Douglas



More information about the fpc-pascal mailing list