+1Hi,
In FME2015 I want to use InlineQuerier with an UPDATE SQL statement to update data within my workflow. I'm pretty sure the syntax is correct and when I run the workflow there is no error, but nothing comes out of the output port that I generated.
However when I run a SELECT query on the same data with the InlineQuerier, this does output the desired results out of anoutput port.
Are you actually able to use UPDATE statements within InlineQuerier?
An UPDATE statement does not return any data, that is probably why.
Also, I suspect the InlineQuerier wasn't meant for this scenario at all, so I'm not sure if it's even possible.
David
+26You can use the SQLExecutor to do inline Update statements.
Or use the DatabaseUpdator transformer to do a Update at the end of the transformation.
+22An UPDATE statement does not return any data, that is probably why.
Also, I suspect the InlineQuerier wasn't meant for this scenario at all, so I'm not sure if it's even possible.
David
I suspect you could do an UPDATE statement and then on a subsequent output port a Select and you'd get the updated data out that subsequent port.
I suspect you could do an UPDATE statement and then on a subsequent output port a Select and you'd get the updated data out that subsequent port.
I've tested that before from my curiosity, but the UPDATE statement didn't affect the resulting table from the subsequent SELECT.
