Yep let me delete the indexes and check. Thankz
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" ----- Original Message ----- From: "Dave Crozier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 18, 2007 9:23 PM Subject: RE: VFP6 Data Disappearing (Corrupt) > 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.
