Ajoy, Black barcodes in data is always a sign of Index/data corruption. Effectively VFP will start to think that the file terminates after the "barcode records" and you probably won't be able to browse down the table sequentially and see all the records. However, you can nearly always use a Goto to go the record immediately after the corrupted one(s) and continue the browse until the next set of bad data.
My suggestion would be to copy out the good data to a temporary table in sections, omitting the corrupted records as detailed above, delete the old table completely and then rename or copy the temporary table back to the live table and recreate the index from scratch. Trying to simply delete these corrupted records will not work as they do not physically exist in the table and you will mess up the index(es) even more. Windows 98 P2P systems are/were notorious in the "loosing" of records especially if there is someone working on the PC where the physical table is stored. At least try and dedicate the PC where the tables are as a "File Server" and don't allow any other processes to run on it. Also, check out the virus scanning and disable real time Virus checking of .DBF, .CDX and .FPT. Other than that, I have seen the same type of file corruption when a network card is about to die and when one just screws up with attendant random bursts of activity onto the network which seems to mess up the machine receiving data updates, usually with the early RTL Realtek chipset based network cards which prompted me to always use 3Com for an easy life. If you have access to a network scanner then it may be an interesting exercise to monitor the network traffic. Also, try swapping out the hub as this is obviously a component that affects the whole network. Best of luck. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Erickson Sent: 11 October 2007 15:51 To: [email protected] Subject: Re: VFP6 Data Disappearing (Corrupt) 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.
