>Hi nadya,
>
>>>Three possibilities come up in mind:
>>>1. Use SQL - INSERT
>>>2. Use Record or tablebuffering and commit the insert with tableupdate.
>
>>Could you please expand the option 2 here?
>
>See Message #503704
>
>When using record and tablebuffering the record is not validated (Uniqueness viloation or triggers) until the record is commited with tableupdate(). So in this case you can always add a new record with APPEND BLANK, even if a blank PK alread exists.

Walter,

I thing you're wrong. We use TableBuffering, yet we can't issue APPEND BLANK, if one blank record is already in a table. The error message appears immediatelly, before TableUpdate.

>
>In my personal framework, the changes people make in a form are (record or table) buffered. The users can commit or rollback the changes anytime.
>
>Walter,