Filer v5.41 Index Question

[BTree]

I got great info (From Rob) when I first got started on this project, I was
able to write the new program in a couple of weeks, that worked out so well
that I got more assignments....

The system contains several sub-systems, most are complete with utilities
that can rebuild and fix any problems with the specific database that is
affected. A couple of the databases don't have these utilities, and I've
been assigned the task of coming up with a way to fix them. (I don't have
the source code for any of these utilities....)

Once again, I don't have all the source code, but I do have record layouts,
I know the indexes, but not how they were originally built. I can't tell if
they are unique or allow duplicates. It almost appears that all six indexes
allow duplicates. When I do a rebuild, it looks ok, but I get a 10220 error
trying to do deletes. (BTW, the production database is corrupt, but I've
been able to re-build it on my pc, and it looks like I'm very close to being
recovered.)

Is there a BT utility that will allow me to decode the index structure? I
know the count, 6, I know the fields, but I'm not sure about
unique/duplicates.

Thanks,
Andy

[Rob Roberts [TPX]]

Andy,

> Is there a BT utility that will allow me to decode the index structure?
> I know the count, 6, I know the fields, but I'm not sure about
> unique/duplicates.

There is a bonus program that came with B-Tree Filer v5.5x called CheckFB
that displays lots of information about Filer data and index files,
including whether each index allows duplicates or not. I believe that
Julian added this as a bonus file sometime after v5.5 was released, so I
don't think it was ever included with any 5.4x versions. I also don't know
whether there were significant changes to the Filer index files between
versions 5.4 and 5.5, so I don't know whether CheckFB will work on v5.4x
index files. But you can get a copy of the original DOS version here:
ftp://ftp.turbopower.com/pub/btree/bonus/chkfb.lzh. Or a Delphi console
version here: ftp://ftp.turbopower.com/pub/btree/updates/checkfb32.lzh.

--Rob [TPX]