by the way, the hint with the IndexFieldName works perfectly. I didn't use
that cause I though it's only used with a Master-Source.
Thanks

""Jan Turner"" <jan.turner@...> schrieb im Newsbeitrag
news:011601c2533d$5bd03f40$7a01a8c0@Valentina...

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

> >
> >
>
>
>
>

___________________________________________________________________________

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