RSS

Re: reading records from a .dbf file

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums

reading records from a .dbf file

•

Join Date: Jul 2007

Location: Philippines

Posts: 255

Reputation: jireh is an unknown quantity at this point

Rep Power: 0

Solved Threads: 28

jireh

Offline

Posting Whiz in Training

Re: reading records from a .dbf file

#20

Jul 23rd, 2007

Hi Vee,

you know I'm confused, why we dont need to mention the dbf file but only their path?

the connection is now ok but there's still a problem on me here why I can't use it in a query? here's my code for that dbf.

Help with Code Tags

(Toggle Plain Text)

Set db = OpenDatabase(App.Path & "\", False, False, "dBase IV;")
Set Data1.Recordset = db.OpenRecordset("select * from color where clrcode='" & Text1.Text & "'")

Is there something I should add in my query?
The error is in here

Help with Code Tags

(Toggle Plain Text)

      Set Data1.Recordset = db.OpenRecordset("select * from color where clrcode='" & Text1.Text & "'")

Last edited by jireh : Jul 23rd, 2007 at 10:00 pm.

A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4

DaniWeb Home > Forums > Software Development > Visual Basic 4 / 5 / 6 > reading records from a...

Re: reading records from a .dbf file

reading records from a .dbf file

Re: reading records from a .dbf file