[RESOLVED] [2005] Simple: Querying/opening a DBF (db3 fox pro) file

[joshjoneswas]

Thanks for the response, jmcilhinney!

I am semi-OK at using SQL in enterprise manager, etc when I am pulling up data on a per-case basis. However, doing so in vb.net is proving a little different than I thought.

I understand your example above except for one part I think.
Once I "fill" the data into "myTable", how do I use it in the program? Is myTable an array? Your SQL command is just the one I imagine... just a one shot simple query that gets it all (I will change that part to just get my three tables later when it works) so that seems pretty straight-forward.

I am just not sure what to do with this last line or two of the code you have. Is everything that is pulled with that SQL command there in that myTable variable/array now? And if it is, how do I reference to that and use that data? Would it be something as simple as:

tmp$ = myAdapter(3)(1)

or something since it may be a 2-d array?

Thank you!