>
>SQLEXEC( Handle, "select * from transactiontest", "TranTest" )
>CURSORSETPROP("Tables", "TranTest" )
>CURSORSETPROP("UpdateNameList", "Field1 TranTest.Field1, Field2 TranTest.Field2" )
>CURSORSETPROP("KeyFieldList", "ID" )
>CURSORSETPROP("UpdatableFieldList", "Field1, Field2" )
>CURSORSETPROP("SendUpdates", .T. )
>SELECT TranTest
>thisform.Refresh
>

This what I use


= SQLEXEC(gnConnHandle, 'SELECT * FROM realtable', 'c_temptable')
=cursorsetprop("buffering",5,"c_temptable")
=cursorsetprop("keyfieldlist","f1,f2","c_temptable")
=cursorsetprop("SendUpdates",.t.,"c_temptable")
=cursorsetprop("Tables","canrun","c_temptable")
=cursorsetprop("Updatablefieldlist","f1,f2,f3,..","c_temptable")
=cursorsetprop("UpdateNameList","f1 realtable.f1,f2 realtable.f2,f3 realtable.f3","c_temptable")

then
tableupdate(.t.) works ok


Hope this helps

Dave.