Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append Blank or Insert Into?
Message
De
14/09/1998 15:10:18
 
 
À
14/09/1998 15:07:12
Koos Veel
Gamma Research
Aruba
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00136359
Message ID:
00136360
Vues:
35
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform