topic Re: Cannot load data from database - error in simple small script in QlikView

Cannot load data from database - error in simple small script

Mon, 21 Apr 2014 22:04:18 GMT

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '`'.

SQL

select `FirstName`, `LastName`

from `Person.Person`

where `FirstName` = 'Ken'

How do i make it work ?

SQL is -

select FirstName, LastName

from Person.Person

where FirstName = 'Ken'

its_anandrjs — Mon, 21 Apr 2014 22:08:18 GMT

Write and try like

select `FirstName`, `LastName` where `FirstName` = 'Ken';

from `Person.Person`

Mon, 21 Apr 2014 22:12:26 GMT

Correct way is -

LOAD FirstName, LastName;

SQL SELECT FirstName, LastName

FROM AdventureWorks2008R2.Person.Person

WHERE FirstName = 'Ken';