Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error building key for index
Message
From
24/06/2009 10:46:36
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01407965
Message ID:
01408062
Views:
43
Tnx
>>Hi
>>
>>Help Please,
>>
>>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"
>
>Don't use ALLTRIM for INDEXES and use TTOC(sdatetime,1) instead.
>
>So, your index will be
>
>TTOC(sdateTime,1) + phone + bintoc(id1) + bintoc(id2)
>
>You would need to padr the values to their length when you construct your seek expression.
Thank you
Chaim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform