Hello all,
I'm new to using pass-through queries from Access to SQL Server but I do have some background in writing SQL statements and programming.
I was just wondering if it's possible to write a pass-through query and also use variables? For example:
------------------------------------------------------------
DIM MYWHERECLAUSE AS STRING
MYWHERECLAUSE = "MYTABLE.NUMBER='1' OR MYTABLE.NUMBER='2' OR MYTABLE.NUMBER='3'"
SELECT MYTABLE.NUMBER
FROM DEBITHIST
WHERE MYWHERECLAUSE
------------------------------------------------------------
is this possible?
Thanks,
I'm new to using pass-through queries from Access to SQL Server but I do have some background in writing SQL statements and programming.
I was just wondering if it's possible to write a pass-through query and also use variables? For example:
------------------------------------------------------------
DIM MYWHERECLAUSE AS STRING
MYWHERECLAUSE = "MYTABLE.NUMBER='1' OR MYTABLE.NUMBER='2' OR MYTABLE.NUMBER='3'"
SELECT MYTABLE.NUMBER
FROM DEBITHIST
WHERE MYWHERECLAUSE
------------------------------------------------------------
is this possible?
Thanks,