sql statement with a where clause causing an error

[samuel_brierley]

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'))';

[alex_millan]

Hi,

try:

WHERE dbo_bak_fms_equipment.Contract_Id='2';

Regards

[er_mohit]

Try this

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

[vishsaggi · Accepted solution]

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;

V.

[samuel_brierley]

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.

[buzzy996]

simply u can pass like this with single quotes.

WHERE dbo_bak_fms_equipment.Contract_Id='2';