SQL Passthrough Query - Where Criteria

Question

Below is my current code:

SELECT SSOM.sa, SSOM.kps, SSOM.le
FROM SSOM
WHERE SSOM.sa=1419116

However i want to make it so whenever you run the query you get a popup box asking you what where criteria you want?

Adjust your SQL before making the call. The link from TT tells how to do it. — Gustav, Jul 20 '15 at 10:33

score 1 · Accepted Answer · answered Jul 20 '15 at 08:23

1

SELECT SSOM.sa, SSOM.kps, SSOM.le
FROM SSOM
WHERE SSOM.sa=[MyValue]

answered Jul 20 '15 at 08:23

John

I get the following error: ODBC--call failed. [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (#301) – Chris Jul 20 '15 at 08:46
Right Click your query and choose parameters from the menu. Then add your [MyValue] in there and select the correct data type. – JMG Jul 20 '15 at 11:35
Cheers JMG however when i right click my query i don't get the option to choose parameters? – Chris Jul 20 '15 at 13:44
The above will NOT WORK since we talking about a pass-though query. – Albert D. Kallal Jul 20 '15 at 21:13

1 Answers1