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)