Index foxpro table using VB.NET - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Index foxpro table using VB.NET

makdumakdu Posts: 2Member
I have a visual foxpro table. I want to index the table from and use that indexed table for the application.

I want to achieve the same result in which is obtained from foxpro.

In foxpro, the commands used are

use invent
index on item_no to itmnoThe equivalent i tried to use in 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]
Sign In or Register to comment.