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