Hello.
I must to update some info in a mySQL5 dataBase from third-party software.
I have a remote view updating a table in particular where is a DATETIME column.

the code is:

Replace myRemoteView.myDate WITH DATETIME ( )

When I do the TABLEUPDATE (.T.) It gives me the follow error message:

1585
Update conflict in cursor ...

Only with DATETIME column this happens, with the others columns of a any type it's works fine.

Already I have tried all SET DATE combinations.

It works perfectly well using SQL Pass Through.

Thanks in advance.