Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error building key for index
Message
 
 
To
24/06/2009 07:33:42
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:
01407973
Views:
47
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform