Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Problem - Error building key
Message
From
04/03/2005 22:29:32
 
 
To
04/03/2005 21:21:36
Randy Wessels
Screentek Business Solutions, Llc.
Phoenix, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00992936
Message ID:
00992942
Views:
18
I would **guess** that MLINE is returning a null string (i.e. zero length). Maybe a stray CR or LF or CR/LF as the first character?

You don't mention which version of VFP. Might be helpful to someone. Also, the setting for MEMOWIDTH.

good luck

>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?
>
>Thanks,
>
>Randy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform