The Service Bus for the Connected Business
I'm trying to dynamically set the "Command" property of the "Table Query" step and it does not appear to be accepting the values.
This is the command in the C# code step immediately preceding the "Table Query" step:
context.Data.SetProperty("sql","Command","EXEC IntegrationAPI.upGetCompaniesFull @i_bitIsGBCompany=1, @i_vchCompanyName='log'");
In the "Table Query" it has "Bindings" and I was able to successfully use an environment variable with the same value as above but the only problem is that the environment variable is static.
I need to be able to dynamically define this "Command".
Can you tell me how to do this? I read all the "Help" material, searched all the forums and haven't found an answer.
Views: 183
Replies are closed for this discussion.
you can find all the updated documentation for the Process designer here: http://www.neuronesb.com/neuron/Help3/Development/Developing_Neuron...
you'll find that if you go into the process step reference guide section, each step will be documented. in the step section, there is a "Dynamic Configuration" section that lists all the dynamic properties supported.
Command is not currently supported as a dynamic property.
however, you could accomplish a dynamic command using the ODBC process step....a bit more work though
I would like to put in a request to have the "sql.Command" string dynamically configurable via C# for the Table Query step in a Business Process. Is this a possibility?
ha ha...anything is possible. let me see what I can do.. will probably put it in our 3.6 release..
Thank you for updating 3.5.4.1240 with this dynamic functionality. It works great!! ;)
As a follow-up, I'd like to request a "future" (nice-to-have) feature that allows for the dynamic setting of the "Root Node Name" and "Row Node Name".
Thank you!
Neuron ESB Product Support Forums and Communities
© 2024 Created by Neuron Admin.
Powered by
