I encounter strange but fatal problem on wd 28 can anyone help test ?
1. query object no longer allow sub query
i have old program not sure using which version of wd I build.
the following sql previously work using hexecutequery without disable correction
select
*
from
(
select * from table1
) P
inner join table2
on table2.id = p.id
where
p.date between {p_d1} and {p_d2}
i get error on wd28 now , when i debug the sql become
select
*
from
(
'P'
) P
inner join table2
on table2.id = p.id
where
p.date between {p_d1} and {p_d2}
what going on , why like that
2. on report with external query, the independent hfsql function become useless
if anyone run hexecutesqlquery() in a window then call iprintreport . the report will not show data from hexecutesqlquery()
depend on the sql , the iprintreport may come out but the static text in report all gone and the body only print few record lines
is this permanent changes or bugs ?
