sql syntax error

[#1]

Hi QlikView Friends,

Please help me with this strange issue.

i'm running this syntax in qlikview on oracle database, but gives me error.

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >$(LASTRELOADTIME));

Thanks

vishwaranjan

[sujeetsingh]

Check for timestamp issue or Variable value?

[ajaykumar1]

Hi,

Is single code required?

>'$(LASTRELOADTIME)');

Regards,

Ajay

[jagan · Accepted solution]

Hi,

Include single quotes for variable names

TableName:

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >'$(LASTRELOADTIME)');

Regards,

jagan.

[Anonymous]

Try this:

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >    '$(LASTRELOADTIME)' );

[#6]

hi

thanks for response,but i had tried but not get success.

i havve also try according to this

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE TO_DATE(CPUDT ,'DD-MM-YYYY')>'$(LASTRELOADTIME)');

************************************************************************************************

and also try according to this

let  LASTRELOADTIME = date(date#(today()-1,'DD-MM-YYYY'),'DD-MM-YYYY');

let  date_key = 'to_date(CPUDT,'DD-MM-YYYY')';

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE '$(date_key)' >'$(LASTRELOADTIME)');

Thanks

[#7]

hi sir

your syntax execute successfully. but not compare both date in

WHERE CPUDT >'$(LASTRELOADTIME)');

here fetch all dates of CPUDT

Thanks

[jagan]

Hi,

Check date format LASTRELOADTIME and CPUDT.

Also use this statement

let  LASTRELOADTIME = date(today()-1,'DD-MM-YYYY');

Regards,

Jagan.

[dinuwanbr]

Hi,

Check out this

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >date('$(LASTRELOADTIME)'));

or

SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE date(CPUDT) >'$(LASTRELOADTIME)');

BR,

-dinu1

[#10]

hi sir

thanks for your response, i checked that both format are same as DD-MM-YYYY

problem is that, both date (CPUDT and LASTRELOADTIME ) are not match.