Subject | [IBO] Re: ClientSql vs ServerSql |
---|---|
Author | tomjanczkadao |
Post date | 2008-12-11T00:05:55Z |
> More complex changes to the statement will occur if you are usingthe OrderingLinks and OrderingItems mechanisms, i.e., there will be an
ORDER BY clause in the Serversql that is not in the Clientsql.
Similarly so if your app is using other methods that alter the
statement in run-time, such as SQLWhereItems.
>SQL. There are other run-time things that can result in changed
> These are just some examples of where the parser might change the
SQL...You can watch what is going on by using a TIB_Monitor.
>Actually i did some tests and both ClientSQL and ServerSQL contain
> I hope this is more helpful this time. :-|
>
> Helen
>
chanegs made by parser to the query.
i've applied OrderingLinks and Filter to pure query e.g.
'select field from table'
and ClientSQL was 'select field from table where ... order by ...'
Regards, Tomek