Execute SQL Query from a QVD file

[Viperidae]

Dear community,

I'd like to know if it is possible to execute SQL queries stored in a QVD file.

here is the example:

I have multiple queries saved in a qvd file and I want to execute them in the script editor, is it possible ?

Your help is greatly appreciated 🙂

[stevejoyce · Accepted solution]

I haven't done this exactly, but i would assume this can be done.  If you loop through each row in your qvd, store it into a variable, vSQLQuery = peek(...), and then run $(vSQLQuery), next loop.

[Viperidae]

Marvelous

Thank you so much, my problem has been solved.