The first question is simple. You just put the COLLATE ... info right in the
OrderingItems property. That is merely a container for the ORDER BY CLAUSE
you want for the OrderingItemNo.

The second question is not very clear to me. Please repeat it with more
detail.

Also, please use one email per question.

Thanks,
Jason Wharton

----- Original Message -----
From: "SAFAK EBESEK" <safak@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, September 28, 2003 2:14 AM
Subject: [IBO] Collated and parameterised query


> Thank you for your help in the past.
> Please could You help me ?
> Thank You in advance...
>
> ** Fist Question:
> My Query is:
> SELECT * FROM CUSTOMERS ORDER BY NAME COLLATE PXW_1254.
>
> I set up the query as SELECT * FROM CUSTOMER on SOL.SOL Tab.
> I create the order definition as on SQL.Ordering Tab.
>
> Where is the best place to add "COLLATE PXW_1254" and how ?
>
> ** Second Question:
> I have parameterized query:
> SELECT * FROM CUSTOMERS WHERE CUSTNO :CUSTNO
> And I have two sorting fields CNAME, CAREA .
> Query works.
>
> After I cliked the title of field for sorting, Query appers empty.
> I checked parameters. Paremeters are empty too.
> How can I set up parameterised&sortable query ?
>
> Thanks
> Safak