I just want to check a thought on that -
do you mean with synchronize a master detail relationship
between datasets ?

In that case it is also possible to use a TIBOQuery because
you can use Fields from a given datasource as parameters
in the query - if there are changes in the DataSource (MasterSource)
the detail query will react.

I had a lot of problems with sorting and/or managing more complex
querys in masterdetail relationships when using a table component.

All you want to do you can do with a TIBOQuery but you can do a lot
more with it.

maik

On Tue, 3 Sep 2002 13:33:52 +0200, Jan Turner wrote:

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