Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Problem - Error building key
Message
De
04/03/2005 23:16:54
Randy Wessels
Screentek Business Solutions, Llc.
Phoenix, Arizona, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00992936
Message ID:
00992952
Vues:
20
The exact expression is: MLINE(name,1)
The Filter is: ALLTRIM(UPPER(type))="USERINFO"
name is a memo field
foxpro is v9 - the application was originally a v7 app and was upgraded to v8 sp1 and hten later to v9. I have the SET ENGINEBEHAVIOR 80 at the top of the main program.

>Randy,
>
>What is exact index key expression for Userinfo tag? What VFP version/SP are you using?
>
>>I inherited the support of an application that is being resold. One of the tables is userdata.dbf. The structure is: type (c,10) id (c,3) name (memo) data (c,50) ckval (n5.0) updated (date). The indexes are ID and USRINFO. USERINFO is a bit complicated. It has an expression MLINE(name,1) and a Filter ALLTRIM(UPPER(type))="USERINFO".
>>
>>The problem only rises at times - I cannot pin down why, but all my attempts to recreate it have failed. I get Error loading file - record number 5. Baseform1 or one of its members. Loading form or the data environment : Error building key for index "C:\spm\data\userdata.cdx" tag "Userinfo". The error is not tied to a specific form, it gives me the executable line 426. Line 426 of the program that starts the application says Read Events. The lines leading up to this line are:
>>
>>Close Data
>>Close Data All
>>CursorSetProp("Buffering", 1,0)
>>Open Data spm2000 Shared
>>
>>I am not sure where to start fixing this. I think it is all tied to the index, but I am not sure what to fix. Can anyone point me in the right direction?
>>
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform