Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select - SQL technique
Message
De
09/07/1998 11:37:51
Ernie Veniegas
Micro System Solutions, Inc.
Calistoga, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Select - SQL technique
Divers
Thread ID:
00115754
Message ID:
00115754
Vues:
60
Is one of these techniques better than the other? Is there a disadvantage to using the asterisk wildcard? Both seem to work okay but want to be sure I'm not setting a disadvantageous precedent.

Example #1:

select MyTable
for i = 1 to fCount()
lcFieldList = lcFieldList + ’MyTable.’ + Field(i) + ’,’
endfor

select &lcFieldList from MyTable into cursor MyCursor


Example #2:

select MyTable.* from MyTable into cursor MyCursor



Thank for any opinions.
Ernie Veniegas
Micro System Solutions
... sensible software by design
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform