topic Re: sql statement with a where clause causing an error in QlikView

sql statement with a where clause causing an error

samuel_brierley — Fri, 17 Jul 2015 10:18:14 GMT

can someone please correct the below for me.

thanks

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\samuel.brierley\Desktop\External Projects\NRA\AFMS.accdb];
SQL SELECT *
FROM `dbo_bak_fms_equipment WHERE (((dbo_bak_fms_equipment.Contract_Id)='2'))';

Re: sql statement with a where clause causing an error

alex_millan — Fri, 17 Jul 2015 10:20:20 GMT

Hi,

try:

WHERE dbo_bak_fms_equipment.Contract_Id='2';

Regards

Re: sql statement with a where clause causing an error

er_mohit — Fri, 17 Jul 2015 10:20:32 GMT

Try this

SQL SELECT *
FROM `dbo_bak_fms_equipment` WHERE dbo_bak_fms_equipment.Contract_Id='2';

Re: sql statement with a where clause causing an error

vishsaggi — Fri, 17 Jul 2015 10:24:31 GMT

Hello Samuel,

Can you post the exact error you are getting. And why there is a apostrophe after the FROM clause just wondering to know. The field name you have used Contract_Id is that a Numeric field or a text?

Try and let us know

SQL SELECT *

FROM dbo_bak_fms_equipment WHERE dbo_bak_fms_equipment.Contract_Id = 2;

Re: sql statement with a where clause causing an error

samuel_brierley — Fri, 17 Jul 2015 10:29:34 GMT

Thanks,

the reason there was an apostophe is because when i select the table using the qlikview tool the below is what is generated.

SQL SELECT *

FROM `dbo_bak_fms_equipment`;

i figured therefore that was some slight tweak to the syntax QlikView requires.

Re: sql statement with a where clause causing an error

buzzy996 — Fri, 17 Jul 2015 10:30:05 GMT

simply u can pass like this with single quotes.

WHERE dbo_bak_fms_equipment.Contract_Id='2';