How to pass arguments to SQL statements when generating reports?
Am preparing a report using vb 6.0. I have created a DataEnvironment and connected that DataEnvironment to my Back end DataBase. Now I have added a Command to that DataEnvironment and written some SQL statements for the Command. I want to select all the records in my table which have the same value for the field Bill_No. However I want to supply this value as an argument to the SQL statements I have written in the Command for the DataEnvironment. That value is available in a TextBox on a Form. In other words I want to pass the value available in the TextBox on a Form as an argument to my SQL statement at run time such that it selects all the records in the table which have their fields Bill_No equals to the value. Therefore when the report is generated it has to only show the records in the tables which have their field Bill_No equal to the value.