Trying to declare an SQL statement with a variable, but I just can't get it to work. Using FM 15.
publicaddress = $$publicaddress;
ExecuteSQL ("select DISTINCT app, dport, protocol FROM pathfinder
WHERE dstloc IS NOT NULL
AND fromzone = 'ae_ext_in'
AND tozone = 'ae_ext_out'
AND src = ?
ORDER BY app";
If I replace the AND src = 'xx.xx.xx.xx' it works just as it should. I've also tried public address = "'" & $$publicaddress & "'" with no luck. The $$publucaddress value is text and I've also tried GetAsText() with the same result.
This can't be that difficult