Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank or Insert Into?
Message
From
15/09/1998 07:41:22
Koos Veel
Gamma Research
Aruba
 
 
To
14/09/1998 22:27:31
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00136359
Message ID:
00136632
Views:
17
Thank you very much for your answer.

Greetings,

Afier Appelman
Using the account of Koos Veel

>>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.
>>
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform