Ajoy, The vertical bars in a field signify only one thing -> Data corruption.
First of all create the indexes on all the files from scratch. Do not try to do a reindex as this will only create the indexes based upon what VFP thinks is the index expression. Secondly, open the tables without an index set and browse through the data until you discover the offending records. Normally the characters entered in the offending fields simulate end of file and the browse will simply disappear, in which case you need to do a goto bottom and browse backwards. Another way to get good data is to use a SQL select statement and then copy it back into the original table. The problems can normally be isolated down to 1 or two records and they are invariable caused by power off's on machines whilst modifying an index. If there is memo field corruption this is more difficult to fix and you may well need to look at something like Foxfix or ABri. If you aren't using a server than I suggest you make one available with a fitted UPS and also try NOT to use a Win98 machine to hold the data aon as there are known caching problems which can also cause these errors when not using a server. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajoy Khaund Sent: 18 September 2007 16:18 To: Profox Subject: VFP6 Data Disappearing (Corrupt) Hi I have an app in a pathology lab. Its a multiuser app with generally new patients been entered from two pc's in the reception and another one or two pc's are used for reporting. The patient details are kept in PatHead while the tests to be done are kept in PatLine. Another table for Payments received. >From the reception these three table are mainly used. >From the inside PC reports are stored in different tables but the "Patline" table is also updated whenever a test is reported and saved as done. The app has been running smoothly since 2002. The pc's are the same, network wires, hub are all same with win98. Of late the data in Table "Patline" has started disappearing now and then. The reporting guy says that when he enters a valid patientid the app shows no record by that number. Then they check in the reception PC. The header record in table "Pathead" is there but the records in table "Patline" are not there. They gave me a copy of the affected database and there are few records in table "Patline" without any data but the cells appear to have barcodes which disappear when you click on the cell. Interesting they have discovered a cure which accoring to them whenever this happens they add a dummy record in the reception PC and the records which had disappeared comes back. I tried that with the data they gave me but I did not see that happening. The tabled do not have much data. The app is more or less what it was five years back with minor upgrades. The problems have started from this year. I wonder why this is happening. Any help to put me in the right direction will be highly appreciated. TIA Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
