[RESOLVED] INDEX a table in VB.NET

This is the more specific error detail

Code:

---

""Errors reported by ADO
(1) Error#: -2147217900
        Desc. : Command is missing required clause.
        Source: Microsoft OLE DB Provider for Visual FoxPro
        Native Error: 221
        SQL State:
        Help Context: 0
        Help File:
"

---

what is wrong with

Code:

---

          fcn.Execute("INDEX  on sale.dbf (Brand)")

---

one more thing to add .
I tried something like this

Code:

---

fcn.Execute("use sale.dbf; index on (price,brand) to prc")

---

This didnt throw any error or exception. But i am expecting a .cdx file named prc.cdx to be generated. But that is not happening. So i am not able to verify whether the indexing has happened or not.

I have made some progress

Code:

---

fcn = New ADODB.Connection
fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source=" &tablefolderpath
fcn.Open()       
fcn.Execute("Execscript('Use sale exclusive'+CHR(13)+'Index on BRAND tag idx1')")

---

This genearate a sale.cdx file. but I am expecting a idx1. file generation as we gave idx1 as the tag name

As I've said before, you'd have to USE FoxPro to create the index files. It can probably be scripted, though. The problem is that it's probably not like any other language.

Paradox 3.5 had PAL, one of the greatest languages available at the time. The Windows version lost it