You should be able to swap out APPEND BLANK with INSERT INTO with no trouble. It should not affect bound controls. Do what Sylvain suggested, move to Opt. Table buffering. Do your INSERT INTO, have the user enter stuff, validate it, and if it passes validation do a TABLEUPDATE().

BTW, any Oracle sequence field cannot be written to. So when you INSERT INTO do not specify an Oracle sequence (or any other Oracle generated field) in the fields list.


>The primary index key is an Oracle sequence, however there is a required unique field that must be entered (Social service number) as well as Oracle internal processing that is dependant upon values in some of the other fields. i.e is record for civilian or militray employee.
>It is finding an easy way to move to INSERT INTO that I am looking for, the only way I can think of to do it now is to go back to FP 2.6 style, where data controls are m.field_name and not cursor_name.field_name