My "option" parameter (in connectstring) contain value 131072 (check
MySQL ODBC parameters)
MartinJ
>if mySQL table has a blank datetime value, VFP remote view doesn't understand and generates an conflict update error.
>Otherwise, if column has a null value VFP (can be a default value) VFP R.V. can save datetime info without a problem.
>
>This trick just works with remote views in SQL Pass Through isn't necessary.
>
>Weird, no ?
>
>
>>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.