🚀 go-pugleaf

I have done some experimenting and if I set the Parameter DataType each time
instead of once when the query is set up then it fixes the problem. Why is
my query losing it's parameter data on Access DB's?

"PS" <paul@nospam.stables1.freeserve.co.uk> wrote in message
news:8m63pr$29f$1@newsreaderg1.core.theplanet.net...
> I am using an ADO connection to an Access DB.
> I have a TADOQuery along the lines of:
>
> UPDATE Engineers SET Available = :LOGON, LastLogonOff = :TIMESTAMP WHERE
> EngineerID = :_SOURCE
>
> Where Engineers table fields are Available = Yes/No (True/False),
> LastLogonOff = Date/Time and EngineerID = Text.
>
> The parameter data is set to 'bool', 'TDateTime' and 'AnsiString' using a
> Variant type.
>
> The first time the query is run, it works fine.
> The second time the query is run I get a 'Data type mismatch in criteria
> expression' error.
>
> The same code works fine into a SQL 7 database of a similar structure.
>
> Thanks in advance,
> Paul Stables.
>
>