SQL Selection from Visual Basic 6.0

SQL Selection from Visual Basic 6.0

I’m trying to install a search facility on a database program I have written using VB6 and an Access database. I’ve opened by inserting a data control onto my form and linking it to my database, and appropriate table. This gets all the data from the table fine. How do I execute another SQL statement to refine the records into those that come back from the SQL statement?

You can specify a SQL statement as the source for your data control. If you look up how to create a WHERE clause in SQL, that will allow you to filter your records to a smaller set.

See also  11 Effective Keyword Research Tools and Techniques

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist