Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improve a table with repeated names
Message
From
04/07/2003 02:22:20
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00806453
Message ID:
00806863
Views:
19
Moises,

as Hilmar suggested:
SELECT DISTINCT;
 Cur1.Field1 AS cName;
 FROM Original_Table AS Cur1;
 INTO TABLE tabNames;
 ORDER BY 1 ASC
>Very good
>
>Suppose I want the table tabNames to be created
>index by alphabetical order.
>I don't mean to create an index for table tabNames
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform