Hi,

how did you add this query to you TIBOTable ???
I tried witth Where SQL.

To order the Dataset you can set the IndexFieldName = recipient.

I prefer to have full control about the query and use TIBOQuery component
to execute select statements like yours. It's a little work to add all
SQL for update, edit, insert and Delete but it works perfectly and gives
you full control about sort order, filter, keylinks and so on.

maik

On Tue, 3 Sep 2002 11:46:57 +0200, Jan Turner wrote:

>I have a quite strange problem. I have an TIBOTable component and try to do
>a statement like this:
>select * from contacts where status=0 order by recipient
>
>In my IBExpert this works perfectly. In the TIBOTable it refuses to order
>the received datasets but doesn't give an error message. The CharacterSet of
>my TIBODatabase is ISO8859_1 and the field "recipient" has the charset
>iso8859_1 too and collation DE_DE
>
>Thanks in Advance
>Jan Turner
>----------------------------------------------------------------------------
>www.getgo.de - Ihr Full-Service-Ticketprovider
>
>getgo.de
>Jan Turner
>Albert-Einstein-Ring 10
>D-22761 Hamburg
>
>Fon: +49 40 41 911 310
>Fax: +49 40 41 911 111
>Mobil: +49 177 9395729
>jan.turner@...
>----------------------------------------------------------------------------
>
>
>
>
>
>
>___________________________________________________________________________
>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 !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>