devxlogo

Customize VI6 DTC

Customize VI6 DTC

Question:

I know how to use the new RecordSet control from VI6 to display records into a Grid; but how do I implement a query at runtime? For example:

SQL = "Select * from Customers" SQL = sql & " Where ID =" Mycriteria

How would I pass this query to the Control?

Answer:

You need to use the onbeforeopen event to handle your recordset parameters:

Sub Recordset1_onbeforeopen()strSQL = [your select statement here]  Recordset1.setSQLText(strSQL)End Sub
devxblackblue

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