Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Problem
Message
De
17/08/2016 04:13:21
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
15/08/2016 16:52:43
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01639454
Message ID:
01639549
Vues:
59
>>>Error building key for index "c:\users\admini~1\appdata\local\temp\000074zt0g0d.cdx" tag "Xyz".
>
>It appears that your index is on a cursor: in the past I experienced issues trying to index a cursor that already has an index on it.
>
>If the purpose is to order your resultset, then do as Tore recommended and use SELECT... ORDER BY rather than indexing the cursor.
>
>Or DELETE TAG ALL before you try to index the cursor.

On readonly cursors you can have one tag, plus any number of side indexes (not the so-called structural indexes, which would go into the same .cdx file, but into a separate file that you need to specify). On readwrite cursors, including SPT, you can index at will.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform