G
Guest
I have a odbc connection I am making to a xbase .dbf file and want to
determine the number of records in the file. THe following code keeps
returning -1 to me???
Any Ideas?
CODE:
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = "Driver={Microsoft dBase Driver
(*.dbf)};DBQ=f:\105\dsd\dbfs\"
Dim mystring As String = "Select * FROM Product"
Dim cmd As OdbcCommand = New OdbcCommand(mystring)
oODBCConnection = New OdbcConnection(sConnString)
oODBCConnection.Open()
Dim recordcount As New OdbcCommand("Select * from Product.dbf",
oODBCConnection)
determine the number of records in the file. THe following code keeps
returning -1 to me???
Any Ideas?
CODE:
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = "Driver={Microsoft dBase Driver
(*.dbf)};DBQ=f:\105\dsd\dbfs\"
Dim mystring As String = "Select * FROM Product"
Dim cmd As OdbcCommand = New OdbcCommand(mystring)
oODBCConnection = New OdbcConnection(sConnString)
oODBCConnection.Open()
Dim recordcount As New OdbcCommand("Select * from Product.dbf",
oODBCConnection)