I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.
Solved
SQLExecutor - can a user parameter serve as the Initiator?
+10- Contributor
Best answer by ebygomm
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Evangelist
- Best Answer
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
+10- Contributor
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
Thanks, that did it.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.