Subject | TIB_Query forget parameters? |
---|---|
Author | linaesztigege |
Post date | 2005-05-08T21:35:54Z |
Hi,
I have a TIB_Query and an IB_Grid. (IBO 4.2I)
SQL.Text:
SELECT
ITEMS.ID AS ITEM_ID,
ITEMS.NAME AS ITEM_NAME,
FROM
ITEMS
left outer join item_hierarchy_relations IH on (ITEMS.ID =
IH.CHILD_ITEM_ID and IH.ITEM_HIERARCHY_ID = :IHID)
(Left outer join with parameter)
OrderingItems:
Name=ITEMS.NAME;ITEMS.NAME DESC
OrderingLinks:
ITEM_NAME=ITEM=1
If I click to header of grid the grid will be empty.
When I debug this I suprised:
The order changing clear the parameters of query.
My question is why and how can i solve this problem?
THANKS
Endre
I have a TIB_Query and an IB_Grid. (IBO 4.2I)
SQL.Text:
SELECT
ITEMS.ID AS ITEM_ID,
ITEMS.NAME AS ITEM_NAME,
FROM
ITEMS
left outer join item_hierarchy_relations IH on (ITEMS.ID =
IH.CHILD_ITEM_ID and IH.ITEM_HIERARCHY_ID = :IHID)
(Left outer join with parameter)
OrderingItems:
Name=ITEMS.NAME;ITEMS.NAME DESC
OrderingLinks:
ITEM_NAME=ITEM=1
If I click to header of grid the grid will be empty.
When I debug this I suprised:
The order changing clear the parameters of query.
My question is why and how can i solve this problem?
THANKS
Endre