Here's the code to make updatable on the fly...

cd c:\temp
create database tester
create table testertable (iid i(4), cfirstname c(25), clastname c(25))
create sql view lv_testertable as select * from testertable

use lv_testertable nodata

cursorsetprop("SendUpdates", .T.) && This makes it updatable

insert into lv_testertable (iid, cfirstname, clastname);
values(2, "My First Name", "My Last Name")

=tableupdate()