General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only