Wiki Home

Adding CDXvia VFP OLEDBprovider


Namespace: SoftwareEng
I am attempting to add an index (.cdx) file to a FoxPro table via VB.Net. Here is the code I am attempting to use:

cnFoxPro = New OleDbConnection(ConnectionStringHere)
cnFoxPro.Open()
cmdFoxPro = New Ole Db Command("USE psch2.dbf; INDEX ON DTOS(date)+oven+shift TO psch2i.cdx",cnFoxPro)
cmdFoxPro.ExecuteNonQuery()
cnFoxPro.Close()

The code executes without raising an error, but does not create the desired index file. Does anyone have any suggestions on how I might be able to accomplish this using VB.Net? Thanks in advance for any assistance you might be able to provide.

The INDEX ON command is not supported by VFP OLE DB provider.
( Topic last updated: 2005.04.13 05:28:04 PM )