Actuate textual Query Editor Syntax Question

[Whitebat]

Hi,
i am trying to write a query in Actuate that looks like this and it is running fine under sql plus.
...
FROM (SELECT LDKEY, LDTEXT REMARK FROM LONGDESCRIPTION WHERE LDOWNERCOL = 'REMARK') R
...

Actuate however gives me the error message invalid variable use in From clause. Does anybody know what the syntax here for is in actuate ?



Thanks Whitebat

 

[mal2ty]

Is LDTEXT REMARK one column or two?