Active Server Pages and FoxPro 2.x

[William F]

Hi all,

I am trying to write an asp page to add/update/delete records in Foxpro 2.x
tables. However, the index files never get updated. Does anyone know how
to update the .idx indexes or what steps or drivers are needed to do this?

William

[Garrett Fitzgerald]

In article <3921bac5$1@news.devx.com>, wfan888@hotmail.com (William F)
quoth...
> I am trying to write an asp page to add/update/delete records in Foxpro 2.x
> tables. However, the index files never get updated. Does anyone know how
> to update the .idx indexes or what steps or drivers are needed to do this?

The old Microsoft FoxPro drivers allowed you to select IDXs, but the
Visual FoxPro driver does not. I would suggest re-writing the app, if
possible, to use CDXs instead of IDXs -- then you'll be better-off
long-term. The versions of MDAC (Microsoft Data Access Components)
after 2.0 replace the old driver with a stub that says to use the new
driver.

If this isn't an option, maybe you could write a COM component in VFP
to access the tables with the IDX files?
--
Garrett Fitzgerald
#INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
(Anyone who thinks I do anything vaguely resembling speaking for
Microsoft is sorely deluded...)