-
Aug 11th, 2012, 07:24 AM
#1
Thread Starter
New Member
How to pass arguments to SQL statements when generating reports?
Hello,
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.
Thank you for helping...
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|