DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Connect to .dbf table

•

Join Date: Sep 2006

Posts: 54

Reputation: royaloba is an unknown quantity at this point

Solved Threads: 1

royaloba

Offline

Junior Poster in Training

Connect to .dbf table

Jan 17th, 2007

Hello guys,
im trying to connect to .dbf table every time i try to query from the table it gives a error
[Microsoft][ODBC Visual FoxPro]Operator/operand type ,mismatch

heres my sample code...

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
        Dim conn As ADODB.Connection
        Dim squery As String
        Dim rs As ADODB.Recordset
        Set conn = New ADODB.Connection
        conn.Open "Driver={Microsoft Visual FoxPRO Driver};SourceDB=" & App.path & ";SourceType=DBF"
 
        squery = "Select * from employee where Card_no=" & Format(Enrollnumber, "00000") & ""
        Set rs = New ADODB.Recordset
        rs.Open squery, conn
 
        Text1.Text = rs!Fname
        Dim conn As ADODB.Connection
        Dim squery As String
        Dim rs As ADODB.Recordset
        Set conn = New ADODB.Connection
        conn.Open "Driver={Microsoft Visual FoxPRO Driver};SourceDB=" & App.path & ";SourceType=DBF"
       
        squery = "Select * from employee where Card_no=" & Format(Enrollnumber, "00000") & ""
        Set rs = New ADODB.Recordset
        rs.Open squery, conn
        
        Text1.Text = rs!Fname

thanks..