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)?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05