Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank or Insert Into?
Message
 
To
16/09/1998 02:39:19
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00136359
Message ID:
00137175
Views:
28
>>David,
>>
>>Everything you say is correct except in a buffered form. The distance in time between issuing an APPEND BLANK in an add button and the TableUpdate() that actually saves the record is so far that the difference is imperceptable. To get a blank record for editing you must APPEND BLANK to the buffer, once you have done that it makes no sense to issue an INSERT INTO rather than a TableUpdate().
>>
>>This is an example of something that was the right way to do things before and has become no longer the right way.
>
>That's a good point Jim. Let me check that I understand you, if I go INSERT INTO (PKey) VALUES (akeyvalue).... into a buffered table it doesn't get to the underlying table until TableUpdate() anyway, so the server index is only updated after that point, so it doesn't matter whether or not I use append blank or insert??
>You seem to be implying that INSERT INTO ... can't create a blank record in a buffered table.

David,

INSERT INTO will create a blank record, but so will append blank. wITH BUFFERING THERE IS NOT DIFFERENCE:
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform