Using SQL scalar variables in qlikview script

[#1]

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

[rbecher]

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

[#3]

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

[rbecher]

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