topic SQL for SQL*server gives error in QlikView

SQL for SQL*server gives error

Mon, 28 Mar 2011 16:50:37 GMT

I am trying to load data from a SQL*Server database using the following script:

SQL

SELECT id, name, abbrev, threshold FROM Timesheet.dbo."WORK_LOCATIONS";

I get a script error that says 'invalid column name 'threshold'.

Threshold is a valid column name for the SQL*Server table that I am using. I verified by running the same script in SQL*Server studio management express and it runs fine.

Is this error because 'threshold' is a reserved key word in QlikView?

Thanks,

-Viral

SQL for SQL*server gives error

Anonymous — Mon, 28 Mar 2011 17:54:04 GMT

When I look at my SQL load script it looks like this:

Load id
name,
abbrev,
threshold;
SQL SELECT id,
name,
abbrev,
threshold

FROM Timesheet.dbo."WORK_LOCATIONS";

Does this work?

SQL for SQL*server gives error

Mon, 28 Mar 2011 20:13:18 GMT

Dennis,

That is exactly how I have my script. It still gives the following error:

SQL Error:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'threshold'.
SQL Scriptline:
SQL State:S0022
SQL SELECT id, name, abbrev, threshold
FROM Timesheet.dbo."WORK_LOCATIONS"

SQL for SQL*server gives error

Anonymous — Mon, 28 Mar 2011 20:19:42 GMT

Try dbl-quotes:
SQL SELECT id, name, abbrev, "threshold"
FROM Timesheet.dbo."WORK_LOCATIONS"

SQL for SQL*server gives error

Mon, 28 Mar 2011 20:26:02 GMT

Still no luck.

SQL for SQL*server gives error

pgalvezt — Mon, 28 Mar 2011 20:34:29 GMT

I think you missed the semicolon in the last value.

can you put the error?

SQL for SQL*server gives error

Mon, 28 Mar 2011 20:52:48 GMT

I believe I have the semicolon.

I tried the following variation of the script with same results:

"Work Locations":

LOAD id, name, abbrev, "threshold";

SQL SELECT id, name, abbrev, "threshold" from Timesheet.dbo."WORK_LOCATIONS";

Still same error.

SQL for SQL*server gives error

Anonymous — Tue, 29 Mar 2011 06:23:23 GMT

I would suggest to use the wizard (Select button) and check the option Preceding load, normaly this always returns a usefull code.

Other things you can try is to use [threshold]

Or maybe

SQL SELECT *
FROM .....

SQL for SQL*server gives error

Tue, 29 Mar 2011 12:38:26 GMT

I did it all over again using the wizard and it works now.

Must have been a syntax error.

Thanks you all for your help.

-Viral