Hi Marco,
we kind off found a workaround. The faulting query schematic was:
SELECT lin.*
,tot.*
,someextrafields
,:variablename extrastringfield
FROM (SELECT fields
FROM TABLES
UNION ALL
SELECT fields
FROM TABLES) lin
,(SELECT * from TABLE WHERE ses=1) tot
WHERE lin.trn=tot.trn
ORDER BY ORDERFIELDS;
if we move the variable to the Union parts it works:
SELECT lin.*
,tot.*
,someextrafields
FROM (SELECT fields
,:variablename extrastringfield
FROM TABLES
UNION ALL
SELECT fields
,:variablename extrastringfield
FROM TABLES) lin
,(SELECT * from TABLE WHERE ses=1) tot
WHERE lin.trn=tot.trn
ORDER BY ORDERFIELDS;
It works but we don't understand why it works.
Do you? Its a normal string variable that gets its value in both situations.
kind regards
Ruud