here is my SPT command :

lconn = SQLSTRINGCONNECT("DRIVER=MYSQL;SERVER=127.0.01;DATABASE=test;UID=root")
SQLEXEC(lconn,"SELECT * FROM pr1","cPr")
=CURSORSETPROP("TABLES", "pr1","cPr")
=CURSORSETPROP("UpdateNameList", "id pr1.id keyInDate pr1.keyInDate unit pr1.unit")
=CURSORSETPROP("KeyFieldList", "id")
=CURSORSETPROP("UpdatableFieldList", "keyInDate unit" )
=CURSORSETPROP("SendUpdates", .t.)

ok, let me rekey the value for the unit field from 'KG' to 'KG'. issue TABLEUPDATE()

Then I will receive :

Update conflict, ok, revert, help ...

but if I key in differ value, eg, from 'KG' to 'PCS' then it is fine.

what wrong with my command?

TIA.