Hello, i’m using scriptcase version 8.00.0032.
In grid application, if I use the following query:
select cat , dog from animals00
and I use variable “number” for table function, it works perfectly.
This is the resault in the php code:
$nm_comando = str_replace("<<00>>", $_SESSION[‘number’], "select … FROM animals<<00>> … ");
If i use a more complex query such as:
SELECT
alias2.alias9,
alias1.alias8,
alias1.field3,
(
alias2.alias3 DIV 60
) AS alias3,
(alias2.alias4 DIV 60) AS alias4,
(alias2.alias5 DIV 60) AS alias5,
(alias2.alias6 DIV 60) AS alias6,
(
alias2.alias7 DIV 60
) AS alias7
FROM
(
SELECT
tab1.field12 AS alias8,
tab2.field3 AS field3
FROM
tab1
JOIN tab2 ON tab1.field12 = tab2.alias8
WHERE
field11 = ‘house’
) AS alias1
LEFT JOIN (
SELECT
field9 AS alias9,
field10 AS alias8,
SUM(field4) AS alias3,
SUM(field5) AS alias4,
SUM(field6) AS alias5,
SUM(field7) AS alias6,
SUM(field8) AS alias7
FROM
tab00 <<<<<---------------------- here it is the ‘00’ for Variable for Table fuction
GROUP BY
field9,
field10
) AS alias2 ON alias1.alias8 = alias2.alias8
WHERE
alias9 IS NOT NULL
ORDER BY
alias2.alias9,
alias1.field3
Variable for Table function doesn’t substs the table name, and it continues to query table ‘tab00’.
It seams to work only for simple queries, without brackets and without join.
Thank you
Fabrizio