Hiya Sylvain.

I'm confused and AFVFP right now to not be able to test but I don't seem to recall a problem with INSERT INTO creating a blank view record. In fact, I never use APPEND BLANK anymore.


>APPEND BLANK has the advantage of clearing all the controls when the controls are bound to the view, which is I suppose Lorne is using. INSERT INTO is great when you allready have all the info you want to append in the table.
>
>>Yes, and also move from APPEND BLANK to INSERT INTO (fields) with whatever keys generated at the UI level placed into the new record.
>>
>>A definitive solution though begs the question, where are primary keys generated? By Oracle Sequences or by the UI (VFP)?