Hi Iwan

'rows 100 to 200' is not syntax that I have seen before.
Do you mean
Select first 100 skip 100 id, name, address
from customer
rows 100 to 200
order by id ?

Regards
Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of send2iwan
> Sent: 28 May 2008 09:47
> To: IBObjects@yahoogroups.com
> Subject: [IBO] SQLWhereItems help...
>
> Dear all,
>
> i am using SQLWhereItems everything ok, until change my query
> like this select id, name, address from customer rows 100 to
> 200 -> add this line
>
> after check with monitor query became
> select id, name, address
> from customer
> rows 100 to 200
> order by id -> this make error
>
> how to solve this one?
>
> please some hints.
>
> thanks.
> Iwan
>
>
>
>
>
> ------------------------------------
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> ! Yahoo! Groups Links
>
>
>