I have a visual foxpro table. I want to index the table from vb.net and use that indexed table for the application.
I want to achieve the same result in vb.net which is obtained from foxpro.
In foxpro, the commands used are
index on item_no to itmnoThe equivalent i tried to use in vb.net is
cn = New System.Data.OleDb.OleDbConnection("Provider=VFPOLEDB.1;Data Source=D:atitest;Persist Security Info=False")
Dim Query1 As String = "use INVENT"
Dim Query2 As String = "index on item tag itemindx"
Dim Cmd1 As OleDbCommand = New OleDbCommand(Query1, cn)
Dim Cmd2 As OleDbCommand = New OleDbCommand(Query2, cn)
Cmd2.ExecuteNonQuery()I am getting exception in Cmd2.ExecuteNonQuery()
One or more errors occurred during processing of command[/html]