I know it's possible, but I don't know exactly how it works, so I didn't try
it yet, because the changing I do at the moment has to be ready and tested
until yesterday. So I will do It like this for the moment and give it a
deeper thought later on. But thanks anyway
:-)
Jan

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


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