Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error building key for index
Message
 
 
À
24/06/2009 07:33:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01407965
Message ID:
01407973
Vues:
46
No reason to use ALLTRIM() in this case

>I retrieve data from IVR txt and I have to void Reexport, So I populate new line only if I seek thisIndex=.f.

>>See Considerations for Creating Index Expressions in the help
>>
>>TTOC(sdatetime,1)+phone+STR(id1)+STR(id2)
>>
>>Why do you need such index in the first place?
>>
>>
>>>
>>>I have the following index:
>>>
>>>
ALLTRIM(TTOC(sdatetime)+ALLTRIM(phone)+ALLTRIM(STR(id1))+ALLTRIM(STR(id2)))
>>>
>>>When I try to populate the table (alias), I get error message:"Error building key for index"
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform