topic Re: Using SQL scalar variables in qlikview script in QlikView

Using SQL scalar variables in qlikview script

Thu, 12 Jun 2014 11:16:14 GMT

Hi all,

I want to run a SQL query that makes use of several scalar variables. I replaced those with a fixed value with qlikview variables as it is the same thing, but there are some more declared with no initial value as it is dynamic.

Does anyone know how I can use the

SQL declare @bla int
SQL select...

bit in qlikview script? It doesnot seem to like the syntax no matter what I do.

Thanks

Re: Using SQL scalar variables in qlikview script

rbecher — Thu, 12 Jun 2014 11:22:28 GMT

Hi Joseph,

the SQL statement is passed directly to the database. This could probably work but syntax will not be checked on QlikView site.

- Ralf

Re: Using SQL scalar variables in qlikview script

Thu, 12 Jun 2014 11:55:14 GMT

Thanks Ralf, I am waiting for confirmation that the error codes dont have to do with the backend.

Re: Using SQL scalar variables in qlikview script

rbecher — Thu, 12 Jun 2014 12:03:29 GMT

Which error code? SQL errors? Just post here..