Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Dhiraj Mehrotra
  Where is Dhiraj Mehrotra?
 Lakhimpur
 India
 Dhiraj Mehrotra
 Tags
Subject: Junk Characters IN DBF
Thread ID: 249857 Message ID: 249857 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Saturday, January 09, 2010 8:13:46 PM         
   


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