Re: Corrupted DBP File

Kind of strange.
You don't actually mention anything that would specifically indicate a
corrupt database file.
The DDFs only contain the SQL schema (file field and index
information) for the existing Btrieve files. Rebuilding those doesn't
change their content so the data will be represented the same way
through the SQL engine. Also, the DDFs only contain SQL schema
information and no "user" data.

You don't mention specifically which Pervasive Control Center you are
using. The 9.x one has quite different behavior then previous
versions. It does in fact have a problem with displaying the correct
number of records that are in a file as well as a grid that is much
more limitted than previous versions for showing data.

I would probably start by doing a butil -stat on the data file and
seeing how many records it is supposed to actually have.

Might want to use a different tool to look at the data than PCC due to
the above mentioned limitations. MS Access springs to mind but again
the grid is an "in memory" construct so it is limitted, well, by the
amount of memory available to it. Notepad and Wordpad are also "in
memory" types of applications, although the behavior described is not
what I have seen before using them... ODBCtest springs to mind as
well as there are a couple of freeware command line SQL executors
available from the Component Zone utilities listing, 2nd page shows a
couple:
http://www.pervasive.com/ComponentZone/Component/Lookup.asp?Function=ShowComponents&ID=6&Category=Tools+%2F+Utilities
No "memory" limitations with them as they dump to screen or log file.

Leonard

On Wed, 4 Jan 2006 10:35:36 -0500, "Bernie Hunt" <bhunt@xxxxxxxxxxxxx>
wrote:

>I'm working with a clients database and one of the tables is corrupted. I
>was able to rebuild the DDF Files using the utility out of Control Center,
>but I'm still unable to access all of this table file.Control Center says
>there are around 65K records, but when I try to query for the last record in
>Control Center it hangs around 19K records.
>
>I tried to open the file with Wordpad just to see if it was there and
>Wordpad got stuck in a loop. Wordpad said it had 12% of the file loaded and
>then would got back to loading 1% of the file. Trying to open it with
>Notepad produced similar results.
>
>I am able to copy and move the file and NTFS doesn't have a problem with it.
>
>Any suggestions on a tool or method that will let me find what's wrong with
>this file?
>
>Environment:
> XP Pro
> Pervasive V9 SP1 Workgroup Edition
> Data crated by Lytec XE application
>
>Bernie
>

.