=CURSORSETPROP("UpdateNameList", "id pr1.id, keyInDate pr1.keyInDate, unit pr1.unit")
=CURSORSETPROP("UpdatableFieldList", "keyInDate, unit" )

MartinJ


>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.