Subject | Collated and parameterised query |
---|---|
Author | SAFAK EBESEK |
Post date | 2003-09-28T09:14:44Z |
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
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