Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank or Insert Into?
Message
From
14/09/1998 15:10:18
 
 
To
14/09/1998 15:07:12
Koos Veel
Gamma Research
Aruba
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00136359
Message ID:
00136360
Views:
38
Hello Afier ---

I prefer INSERT INTO for several reasons. For one, it's more consistant with SQL syntax(that's the snobby answer)....For two, APPEND BLANK may generate errors if a primary or candidate key has been defined and blanks are no-no's. For three: Because you can create the new row and populate it with one command as opposed to an APPEND and then a REPLACE.


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

Click here to load this message in the networking platform