In SQL I would like to solve the following complex script by using Visual Basic 5.0 or 6.0 Versions.
First Table Name: tblClient
Fields: ClientID, ClientName
Second Table Name: tblPurchase
Fields: ClientID, Item Name, Qty, Price
Here How can I pass one SQL query for a Dos print out by opening a text file and how can I create a batch file for execute the batch file for print in dos mode.
The Dos Out put I would like to get the following format
Client ID: 101
Client Name: Mr.Abc
Item Purchased Qty Price
If ClientID 101 bought 5 Items all will show here and the next client id may be 102 it should come in a new page. The command I have to give from a Visual basic through a command button.
Expecting your solution for this complicated criteria,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: