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?
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