Devart Forums

Also noticing it only seems to happen on a 64bit machine

If I give you an example:

UPDATE myTable SET myDateField = :MyDateParameter


using this in RemObjects with SDAC creates you a parameter of
MyDateParameter and by default set to type Unknown

When you come to use this update statement, the code sets the date input parameter and executes the update statement.

I have no control over the field type used as its managed by (far as I can see) by SDAC

Hi,
Using RemObjects/SDAC to insert some data into a SQL2008 system (64bit), I’m occasionally seeing the message,
Operand type clash: datetime2 is incompatible with int(#0)
When one of the parameters is a DateTime field.

Any ideas?

Hi,
So really there's no simple solution other than to explicitly state it's a datetime field or use cast/convert