What OS is the data on?? I Have seen this happen when the vfp tables were being stored on a Novell file server. nothing against Novell. what we had to do was copy the data out zap the table then copy the data back into the table. Data was restored. weired.
Ajoy Khaund wrote: > Hi > > I happened to be nearby when data disappeared again. It was around 5:00 PM. > About 141 patients had been entered. From Patient No. 122 the child records > were not there. The moment they found out they asked me to come. I made a > copy of the database. Then the operator showed me wherby he entered a new > dummy patient with one dummy child record and saved it. The record saved plus > the child data of all the other records which was not there sometime ago came > back. > > I tried the same with the copied database. It accepted a new record but the > old records did not come back. > > Any Idea. RAM ??? CACHE ??? HDD ??? > > > 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: Ajoy Khaund > To: Profox > Sent: Tuesday, September 18, 2007 8:48 PM > 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 hig hly 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.
