is filterSQL on tIbcquery can make limit query ?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
donlego
Posts: 3
Joined: Sat 10 Sep 2011 06:16

is filterSQL on tIbcquery can make limit query ?

Post by donlego » Sat 23 Jul 2016 16:14

is filterSQL on tIbcquery can make limit query
like select first 1 skip from ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: is filterSQL on tIbcquery can make limit query ?

Post by ViktorV » Mon 25 Jul 2016 10:40

The query you have provided can't be set for the FilterSQL property, since the FilterSQL property add a value to the WHERE condition, and the first and skip operators are used in the SELECT clause.
See more details about this property in IBDAC help: https://www.devart.com/ibdac/docs/?deva ... tersql.htm

Post Reply