Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT not as maintainable?
Message
 
À
26/07/2006 16:32:32
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01140411
Message ID:
01140452
Vues:
15
>>>Buffering removes these concerns as well, no?
>>
>>O, yes :-)
>>Buffering and/or Transactions remove all concerns, buy I still prefer INSERT :-)
>>You could make it more redable with a few comments:
>>
>>INSERT INTO Test (;
>>                  Field1,;
>>                  Field2,;
>>                  Field3 ;
>>                  );
>>            VALUES;
>>                  (;
>>                  Expr1,; && Field1
>>                  Expr2,; && Field2
>>                  Expr3;  && Field3
>>                  )
>>
>
>Not funny! More typing leads to more mistakes!! :)

Agree, but with APPEND BLANK/REPLACE you type more than if you use just INSERT.
What about this:
INSERT INTO Test (Field1, Field2, Field3) VALUES;
                 ( Expr1,  Expr2,  Expr3)
Of course this format is not suitable for long field list insert.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform