Hi,
USE C:\YOURPROJECT\FORMS\YOURFORM.SCX
BROWSE

>This is happening in the main program before any forms/data environments have been called. The app WAS a v7 app that was upgraed to 8 and then recently to 9. I guess I don't know how to open that as a dbf to view the memos...
>
>>Hi,
>>I assume you are upgrading versions, my guess is that you have an invalid filter/expression in the DE of the form. I encountered a similar problem upgrading from 7 to 9.
>>Open the form as a dbf and view the memo's, you will see the expression broken up accross two lines, placing a "=" in front of the expression usually fixes it.
>>
>>
>>>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