Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT not as maintainable?
Message
De
26/07/2006 15:56:08
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
INSERT not as maintainable?
Divers
Thread ID:
01140411
Message ID:
01140411
Vues:
72
Is it just me or is

REPLACE ;
field1 with expression1, ;
field2 with expression2 ;
field3 with expression3 ;
IN alias

You can't get the fields out of synch with the values.

Easier to read/maintain/modify than:

INSERT INTO alias ;
(field1, ;
field2, ;
field3) ;
VALUES ;
(expression1, ;
expression2, ;
expression3)

If the field list gets out of synch with the values, that's going to be messy. Not only that, but with a longer list of fields, the chances of error goes up.

Besides the advantages of doing the equivalent of an append blank and a replace all at the same time AND SQL compatibility, what other benefits are there to INSERT in VFP?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform