Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
maxsheva
Creator II
Creator II

SQL DECLARE with a UserTable type

Hi,

I am trying to use SQL DECLARE with a UserTable type

SQL DECLARE @Variable UserTable;

It works properly in SSMS but error appears in QlikView

ErrorMsg: Parameter or variable '@Variable' has an invalid data type.

 

Any help would be appreciated.

 

1 Solution

Accepted Solutions
jonathandienst

You need to define the table in the declare:

DECLARE @ProductTotals TABLE
(
  ProductID int,
  Revenue money
)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst

You need to define the table in the declare:

DECLARE @ProductTotals TABLE
(
  ProductID int,
  Revenue money
)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

maxsheva
Creator II
Creator II
Author

Thanks for quick reply.

 

It works!