Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command to avoid data appearing twice or more?
Message
From
01/02/1999 13:12:47
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/02/1999 12:59:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00182584
Message ID:
00182592
Views:
12
>Hi,
>
>I use SET FILTER TO mclass=class and then open a browse window to browse the data for "class" only. But some of the data like Student Class, may appear twice or more depends on the numbers of record.
>
>So, is there any way to keep the same "class" to appear twice or more?
>I want each of them to be listed only once.
>
>Gan
Gan,
Since listing w/o duplicates reminds "just view" I would suggest SQL :
select distinct ....
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform