> >> Can Foxpro Databases be read from Delphi?
> > I have been trying to do this for half a day now (the dBase driver
> >does not seem to like FoxPro 2.6 .CDX index files). I'm curious if
> >anyone else has gotten this to work, under either 1.0 or 2.0.
> > Jim Wright
> > OmniCell Technologies
> You need an add-on product to be able to connect to FoxPro (CDX) or
> Clipper (NTX) files. There are a few out there, some have VCLs and
> some don't. The one I am trying is Apollo and it looks very good so
> far. You can download a free fully functional demo version from the
> CompuServe Delphi forum (GO DELPHI).
Well, I've just started using the Microsoft FoxPro 16 bit ODBC driver,
and I can now open tables with FoxPro compound indexes (.CDX), but when I
try to change to a particular index (other than the default/primary
index), I get an exception/GP with "Index does not exist". The index
is on a character field "Rsc_stype", with that field being the index
expression, and the index name as well. (In the FPW 2.6 Database|Setup
box, the index is listed as "Lac_rsc:rsc_stype" where Lac_rsc is the
name of the table. If I try TJimTable.IndexName := "Rsc_stype", it
gives me the "Index does not exist" exception, and if I try
TJimTable.IndexName := "Lac_rsc:rsc_stype", it gives me a bizarre
GP/exception, something like "Cannot find (unknown)", and after that
the ODBC driver or BDE is choked, and I have to log off and back on
to the machine (NT Workstation 3.51). Any coments or advice on this?