Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a unique index tag unless empty?
Message
From
28/03/2007 16:09:21
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01209419
Message ID:
01209420
Views:
19
This message has been marked as the solution to the initial question of the thread.
>Is it possible to create an index tag on a field that would enforce unique entry in the field, unless the entry is blank (no entry)?

You can have a candidate index On myfield with NOT EMPTY(myfield) in For clause.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform