Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Ahsan Rana
  Where is Ahsan Rana?
 Lahore
 Pakistan
 Ahsan Rana
 Tags
Subject: RE: Table Corruption
Thread ID: 188536 Message ID: 188947 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Tuesday, August 12, 2008 6:56:41 PM         
   


> >
> >
> > Are vertical lines all you see in HexEdit when you look at the data after the header section of the DBF?
> > Did you set the record count value in the header correctly? What do you see from ? RECCOUNT() before browsing?
> > -Anders
>
>
> When I use table from Command Window with USE Command, its shows abount 569 recored which I think the correct record counts and if I browse it from command window it shows vertical lines in all fields.
>
> Rgds:
> Ahsan Rana

Hi Ahsan,
And then my first q again:
Are vertical lines all you see in HexEdit (with the copy of your original, corrupt file) when you look at the data after the header section of the DBF?
If that's true the I wouldn't know what to propose because there's no real data left in the table.
If that's not true, then you made some mistake when fixing the header section.
And I didn't ask how many rows you see. I asked about the number of rows that RECCOUNT('mytable') returns.
-Anders

ENTIRE THREAD

Table Corruption Posted by Ahsan Rana @ 8/10/2008 2:15:30 PM
RE: Table Corruption Posted by Vincent Byrne @ 8/10/2008 2:17:13 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/10/2008 3:13:56 PM
RE: Table Corruption Posted by Anders Altberg @ 8/10/2008 2:18:33 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/10/2008 3:14:46 PM
RE: Table Corruption Posted by Anders Altberg @ 8/10/2008 5:01:59 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/10/2008 6:26:02 PM
RE: Table Corruption Posted by Anders Altberg @ 8/10/2008 6:58:01 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/11/2008 5:34:03 AM
RE: Table Corruption Posted by Anders Altberg @ 8/11/2008 11:01:00 AM
RE: Table Corruption Posted by Ahsan Rana @ 8/11/2008 2:02:47 PM
RE: Table Corruption Posted by Stefan Wuebbe @ 8/11/2008 2:09:14 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/12/2008 2:11:18 PM
RE: Table Corruption Posted by Anders Altberg @ 8/12/2008 2:44:00 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/12/2008 4:31:18 PM
RE: Table Corruption Posted by Anders Altberg @ 8/12/2008 6:56:41 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/13/2008 12:45:50 PM
RE: Table Corruption Posted by Anders Altberg @ 8/11/2008 4:36:47 PM
RE: Table Corruption Posted by Tariq mehmood @ 8/10/2008 4:42:21 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/10/2008 6:23:02 PM
RE: Table Corruption Posted by Tariq mehmood @ 8/10/2008 6:54:24 PM
RE: Table Corruption Posted by Ahsan Rana @ 8/11/2008 5:34:43 AM
RE: Table Corruption Posted by tanvir ahmad @ 8/11/2008 7:52:20 AM
RE: Table Corruption Posted by Ahsan Rana @ 8/11/2008 2:00:09 PM
RE: Table Corruption Posted by naveed shahid @ 8/12/2008 3:05:32 PM