Hi, I am having trouble running a query in a Open SQL statement what I have in SQL statement is: "SELECT TEMP2.* FROM TEMP2 WHERE Repair_Code=Locals.Repeted_Fault[1]" I am getting error: " Error executing substep 'Post'.The following SQL command failed: 'SELECT TEMP2.* FROM TEMP2 WHERE Repair_Code=Locals.Repeted_Fault[1]...'Native error code -2147217900 0x80040e14Microsoft JET Database Engine: Syntax error (missing operator) in query expression 'Repair_Code=Locals.Repeted_Fault[1]'. " It does work if I remove the local varibale(number) and use absolute number. I have tried various option like leave the local out of quotes, add single quote to query etc. None worked out. I have Statement requires parameters box unticked. I have similar problem using a local variable of type string. But sorted out using Build example. Any help please... Thanks MAMA007

NI TestStand

Thanks Ray , it also worked for me perfectly.

Message 11 of 11

(711 Views)

What do you need our team of experts to assist you with?

How can we help?

Please enter your information below and we'll be intouch soon.

This field is required

Preferred communication method

Email Phone call

What do you need our team of experts to assist you with?