Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select - SQL technique
Message
From
09/07/1998 11:37:51
Ernie Veniegas
Micro System Solutions, Inc.
Calistoga, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Select - SQL technique
Miscellaneous
Thread ID:
00115754
Message ID:
00115754
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform