>>Hello,
>>
>>We are using Visual FoxPro 5.0 and we are making a framework. For our security form we are using textboxes. We are using optimistic table buffering. To add records to our table we can use either the 'APPEND BLANK'-command or the 'INSERT INTO'-command. Can you tell us what wich command you prefer and why? Thank you for your time.
>>
>>Greetings,
>>
>>Afier Appelman
>>Using the account of Koos Veel
>
>Afier,
>In addition to other coments, APPEND BLANK has a performance penalty; the index(es) have to be updated twice. INSERT INTO does a single index update, which means it's *about* twice as fast.
>Unfortunately there's no INSERT INTO FROM NAME objectname, which would be nice since they introduced SCATTER NAME objectname.
Agreed. They really missed INSERT clause. Sometimes, I cannot refrain from issueing INSERT for primary/foreign keys only, and then still GATHER
Edward Pikman
Independent Consultant