tDBInput using tDBConnection dynamically

[decimatum]

Hi, I am trying to use database connections dynamically for example

I have 3 tDBConnections

1. tDBConnection_1, tDBConnection_2,tDBConnection_3

In my tDBInput, I want to use a context variable to select which tDBConnection to be used.

For example, context.tDBConnection = "tDBConnection_1"

Is there a way to do so?

[jzhao]

Hello,

You can use the Dynamic setting in some Database components:

Regards.

[decimatum]

hm. I tried this. but it did not work.

for example , set context.connectionid = "tDBConnection_2" as a string. but does not work.

may i know how you set the context.connectionid?

[jzhao]

it's in Contexts view.

[jzhao · Accepted solution]

Just recheck the generated code, when using the dynamic setting in the DB component, need to use a workaround: the dynamic setting should be set:

" + context.connectionid + "

can't set the value directly.

[decimatum]

Thanks! it works now. " + context.connectionid + " is the solution.