topic sql syntax problem in QlikView

sql syntax problem

Fri, 18 Feb 2011 11:17:06 GMT

I´m having a problem with my sql sentence. It goes like this

SQL SELECT *
FROM 'MYTABLE'
WHERE [FromDate]="17-02-2011";

I get an error - ODBC access driver - to few parameters??????????

sql syntax problem

Fri, 18 Feb 2011 11:17:50 GMT

the select works without the WHERE clause

sql syntax problem

prieper — Fri, 18 Feb 2011 12:40:37 GMT

Think that you are out of the SQL-syntax, the single aprostrophe and the square brackets also seem to belong to the Qlik-World. Most of SQL-drivers also expect the date to be delivered as MM/DD/YYYY. Thus try a statement like

SQL SELECT * FROM TableName_in_the_database WHERE "My Date" > "02/17/2011"

If still there are problems, try to eliminate the WHERE-clause and figure out, which date-format is required by your ODBC-driver.

HTH
Peter

sql syntax problem

Fri, 18 Feb 2011 13:22:24 GMT

Hi Peter

I tried your statement, but get the same error.

The dates are not "dates" but textfields

sql syntax problem

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 13:29:23 GMT

Hello,

Just make sure both field an value are in the same format in database:

SQL SELECT *FROM MYTABLEWHERE FromDate = '20100101';// Using YYYYMMDD or whatever the format is stored the field in

If you perform that query in your query analyzer, does it return the right records?

Hope that helps.

sql syntax problem

suniljain — Fri, 18 Feb 2011 14:05:06 GMT

SQL SELECT *
FROM 'MYTABLE'
WHERE FromDate= '17-02-2011';

sql syntax problem

Mon, 21 Feb 2011 07:32:08 GMT

This suggestion also fails.

I´m sorry to say, that its my own problem, not telling you that the script is connected to a access database, so beeing a date the answer is

much like Sunils with a litte change

SQL SELECT *
FROM 'MYTABLE'
WHERE FromDate= #17-02-2011#;