You can add the SQL like this:
Table.SQL.Text := 'select * from...'
Like you would normally do in a TIBOQuery. I use the TIBOTable because I
need it to synchronize with another Dataset.

----- Original Message -----
From: "Maik Wojcieszak" <mw@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, September 03, 2002 12:13 PM
Subject: Re: [IBO] Problems with "order by" in TIBOTable


> 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/
> >
> >
>
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>