Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No Duplicates
Message
From
24/09/2003 19:18:15
 
 
To
24/09/2003 19:04:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00832032
Message ID:
00832036
Views:
25
>Hi,
>
>I am using VFP6 and I want to use a combo box on a form that accesses a table to use as a rowsource. This is easy to do. The problem I have, is that I do not want any duplicate records in my combo box. I have set an index and tried to SET UNIQUE ON but that doesn't show the records that are duplicated. Any ideas? I know this is probably an easy problem, but for some reason I am having a hard time with this. Thank you.
>
>Tim

Change it to use a cursor that's created with a SQL SELECT DISTINCT statement as the rowsource.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform