I use a MasterSource in the TIBOTable because I want the Datasource of one
grid react to changes of the pointer in a second grid.

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


> What do you mean ?? synchronize ??
>
> On Tue, 3 Sep 2002 13:30:51 +0200, Jan Turner wrote:
>
> >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/
> >
> >
>
>
> -------------------------------------------------
> Maik Wojcieszak
>
> wobe-team (http://www.wobe-team.com)
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>