Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Martin Krivka
  Where is Martin Krivka?
 
 Czech Republic
 Martin Krivka
 To: Dhiraj Mehrotra
  Where is Dhiraj Mehrotra?
 Lakhimpur
 India
 Dhiraj Mehrotra
 Tags
Subject: RE: Junk Characters IN DBF
Thread ID: 249857 Message ID: 249886 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, January 10, 2010 12:23:33 PM         
   


Hi,

as you say, your table are corrupted. There is no answers about values. It can be anything. You need repair table.

I'm also interested how to detect broken rows in table. I do it manually today.

Martin




> Hi,
> Here is a snapshot of browse window for HISO.dbf
> Fields starting with 'N_' are numeric and 'C_' are character fields. The table has got corrupted due to power failure. My question is
>
> 1- How 000SN, 000P, 100P values are stored in numeric field N_srno in red circle?
> 2- In Numeric field N_purqty where were the decimal values gone in red circle?
> 3- In blue circles the values displayed are the values which were never stored and original values were gone.
>
> Is there any way by which I can check the tables used for these type of absurd values before using the dbf.
>
>
>
> Thanking you all !
>
> Regards,
> DHIRAJ



COMPLETE THREAD
Junk Characters IN DBF Posted by Dhiraj Mehrotra @ 1/9/2010 8:13:46 PM
RE: Junk Characters IN DBF Posted by Martina Jindrová @ 1/10/2010 11:55:26 AM
RE: Junk Characters IN DBF Posted by Martin Krivka @ 1/10/2010 12:23:33 PM