Need VB script advice - dynamically change the DBname and table name in the Edit script

[#1]

Hi All,
I have one task. I have 3 different databases and all the database will have same table structure but the table name will be different. My database names will be like AView, DView and NView and tables like A_Analysis,D_Analysis and N_Analysis

I want to change the database name and table name dynamically and reload the report.
for /e.g/
I have created a report based on one database.

connection string:
CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DVIEW;Data Source=DB003;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DB003;Use Encryption for Data=False;Tag with column collation when possible=False];

SQL:
SELECT * FROM D_Analysis;

I want to change the only the first two letters of the database name and the table name dynamically. In the list box, lists all the names like D,N,A etc.

select the A in the list box and click the button to change the connection string and the query and reload the document. Previously was DView after reloaded AView.

How can i do that. How can i pass the the value from list box to edit script? or is there any other option to perform this task?

After reloading the document it should point to the select database records.

Thanks,
Raghu

[Anonymous · Accepted solution]

Raghu,
You can use variable. Allow it to be A, or D, or N. The connect string will be
... Initial Catalog=$(Var)VIEW...
And, in SQL
.. FROM $(Var)_Analysis

[#3]

Micheal,

thanks, Let me try and get back to you if i find any problem

thanks

RAghu.

[#4]

I have got a solution. Now i can dynamically change the database name and table name in the edit script. I have to select, which database i want. Reload the document it will take records from the selected values from the database tables.

I have changed the edit script what Micheal suggested. Thanks again.

Thanks,

Raghu.

[#5]

Hi Raghu,

I'm new to QlikView and have similar situation like you had. Could you pls. send me the script .

Thanks,
Pratul.

[#6]

Hi Pratul,

Check the attached file. Hope this file gives you some input.

regards,

Raghu.

[#7]

Thanks a lot Raghu.