Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange CDX corruption
Message
From
17/03/2011 16:25:22
 
 
To
17/03/2011 16:20:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01504018
Message ID:
01504020
Views:
75
Rule no. 1: Never use alltrim() in an index expression
Rule no. 2: Never, NEVER, NEVER use alltrim() in an index expression
Rule no. 3: If you need to use alltrim() in an index expression, see rule no. 1 and 2.

NB! In case I forgot to mention it: Never use alltrim() in an index expression!!!

>Hi All
>I have an app with VFP database running on o server2003 with 20 clientes in a stable network.
>In my databse I have a table XXX with an index like this: cClientType+ALLTRIM(cClientId)+ALLTRIM(cDocType)+STR(nDocNum)+STR(nAnotherField)
>
>Everythig runs weel except with 2 clients (of 1500) when I make an INSERT INTO XXX (...) ... I get the error Index file "z:\data\xxx.cdx" tag "Misto" is corrupted. Please rebuild it.
>
>Another strange thisg is that if I use vfp command window and make that inser it runs good!!!
>
>Any ideas would be great. By the way, is there any way new to rebuild without EXCLUSIVE?
>
>Thank's in advance,
>NPedro
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform