Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Error
Message
 
 
To
22/09/2016 06:14:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01641204
Message ID:
01641206
Views:
48
>Sir, I have this line of code
>
>
>index on substr(alltrim(code2),1,7) tag xydg
>
>
>it displays this error message
>
>Error building for key index "c:\windows\temp\0001qlnd0098.cdx" tag "xydg"
>
>how to overcome this

Is it possible that code2 starts with spaces?

Try removing alltrim function, e.g.

index on left(code2, 7) tag first7chrs
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform