Re: Parameterized Queries - Variables, and Access

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in
news:ONxjNkHFHHA.3288@xxxxxxxxxxxxxxxxxxxx:


Otherwise in what way do you solve this problem.

My only other solution at the moment is to use two ? placeholders and
declare two identical Parameters in the Parameters collection.

Do you mean you have this working? Please show us an example.

Nope, sorry Bob. That was my next plan of attack based on my understanding
from SQL Server, but as you say Access does not support batched queries.

I would be interested to know if there is a better way when using SQL
Server, than my method using DECLARE. I once tried to use the variable
name that I setup with the parameters collection but of course this kind of
named parameters does not work with parameterized queries only stored
procedures.

.

Relevant Pages