Page 1 of 1

is filterSQL on tIbcquery can make limit query ?

Posted: Sat 23 Jul 2016 16:14
by donlego
is filterSQL on tIbcquery can make limit query
like select first 1 skip from ?

Re: is filterSQL on tIbcquery can make limit query ?

Posted: Mon 25 Jul 2016 10:40
by ViktorV
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