Hi, i want to update a datetime-field in a mssql database.
If I update fields directly, I can just use
myTable.myField = DateSys+TimeSys
HModify(myTable)
To speed things up, when updating many records, I want to use HExecuteQuery().
I made a simple update-query and use a parameter for the field I want to update.
myQuery.Param1 = DateSys+TimeSys
HExecuteQeury(myQuery)
This will give me an error!! "Conversion failed when converting datetime from character string".
Do i need pre-format the query-parameter?
I'm using WD12 and OLEDB.
Arie