by setting buffering on with cursorsetprop like this

CURSORSETPROP(buffering,1 to 5 <- this is the type of buffering use tablebuffering , cTableAlias )

when you want to update the record you can do that with the
tableupdate() function

regards,
dave