Is there anyway to update a variable from a SQL node or do I need to use a Procedure node?
Hi,
You can reference a variable to grab its contents from within a SQL node, but there is no way of updating it from within the node. Your best bet is to use a procedure node to update the variable.
If you want to return the results of a select (for example) into a variable, just use a lookup() function within your Procedure node
eg
$YourVariable := lookup('Your Data Source','select max(xxx) from yyy');
Cheers!
MF.
Thank you.