I have a cross-connection query where I’m trying to use sysdate, as in:
WHERE (RECALL.DATE_DUE >= sysdate)
But I get "Unknown column ‘sysdate’ in ‘where clause’ Make sure that the table is fully qualified…"
The help for Cross-Connection Query Functions lists sysdate as supported functions.
Using TDA Pro 3.2 on Win 7.