Subject Collated and parameterised query
Author SAFAK EBESEK
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