Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Problem
Message
From
15/08/2016 05:46:51
 
 
To
15/08/2016 03:27:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01639454
Message ID:
01639465
Views:
69
>Sir I have these code, (VFP+SQLSERVER)
>
>
>Select tj02
>Index On Alltrim(acc_code)+Dtoc(Date,1) Tag xyz
>
>
>It show this error message
>
>Error building key for index "c:\users\admini~1\appdata\local\temp\000074zt0g0d.cdx" tag "Xyz".
>
>I faced this type of error message first time.
>
>How to overcome this?
>
>Please help


Tariq, a couple of things:

1) Verify the data types for the columns you're using for the index
2) Make sure the index destination folder is read/write.

And obviously you already received feedback from people about using ALLTRIM
Previous
Reply
Map
View

Click here to load this message in the networking platform