Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a Regular Index
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00089305
Message ID:
00089503
Vues:
27
>>>I'm developing in VFP 3.0.
>>>
>>>When I issue the command:
>>>
>>>INDEX ON abc TAG xyz
>>>
>>>the resulting index is of type UNIQUE. I want this to be a REGULAR index, as the help text states it should be. Has anyone else run across this? Is there a way to create a regular index using the INDEX command? I have to build the index on the fly and not thru the table designer.
>>>
>>>Thanks in advance for any and all help.
>>>
>>>Regards,
>>>
>>>Rob
>>
>>It looks that you inadvertently SET UNIQUE ON before launching INDEX. SET UNIQUE OFF and delete this tag and then INDEX again.
>
>Thanks. You were right

Rob, check in Tools/Options/Data. One of the check-boxes sets Unique Records in Indexes. If this is set ON, your problem will re-occur whenever you load VFP. Set it off, then click the "Set as Default" button.

HTH
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform