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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.