hi everyone.
I'm sorry to appear so many times.
I have a trouble when I set value with 'SetAdHocCondition'.
In Help Page,
-----------------------------------------
Sub SetAdHocCondition( AdHocParameter Name,
"Table.Column",
"Data Type",
value of AdHocParameter )
------------------------------------------
When I use undermentioned SQL Statement,
my expression is correct or not ??
SELECT
A.KeyColumn,
A.Item1,
A.Item2,
B.Column1,
B.Column2
FROM
TABLE_A A,
TABLE_B B
WHERE
A.KeyColumn = B.KeyColumn AND
:?KeyColumn
SetAdHocCondition(KeyColumn,
"A.KeyColumn",
"String",
:? KeyColumn)
I tried to make it possible so many many times,
but error message shows my faults.....
Does anyone find my faults ??
Thanks,
japanese
I'm sorry to appear so many times.
I have a trouble when I set value with 'SetAdHocCondition'.
In Help Page,
-----------------------------------------
Sub SetAdHocCondition( AdHocParameter Name,
"Table.Column",
"Data Type",
value of AdHocParameter )
------------------------------------------
When I use undermentioned SQL Statement,
my expression is correct or not ??
SELECT
A.KeyColumn,
A.Item1,
A.Item2,
B.Column1,
B.Column2
FROM
TABLE_A A,
TABLE_B B
WHERE
A.KeyColumn = B.KeyColumn AND
:?KeyColumn
SetAdHocCondition(KeyColumn,
"A.KeyColumn",
"String",
:? KeyColumn)
I tried to make it possible so many many times,
but error message shows my faults.....
Does anyone find my faults ??
Thanks,
japanese