is filterSQL on tIbcquery can make limit query
like select first 1 skip from ?
is filterSQL on tIbcquery can make limit query ?
Re: is filterSQL on tIbcquery can make limit query ?
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
See more details about this property in IBDAC help: https://www.devart.com/ibdac/docs/?deva ... tersql.htm