[RESOLVED] INDEX a table in VB.NET

[makdu]

This is the more specific error detail

""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

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

one more thing to add .
I tried something like this

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.