Receiving a DOS output with a Visual Basic script in SQL
I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0.
My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query and receive a DOS output along the lines of:
Client ID: _____
Client Name: _____
Item Purchased Qty Price
-----
-----
-----
Is there a simple way to go about this?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 9, 2008 7:48 PM
UPDATED:
September 9, 2008 8:01 PM
Answer Wiki:
This site: <a href="http://msdn.microsoft.com/en-us/library/s4yys16a(VS.71).aspx">http://msdn.microsoft.com/en-us/library/s4yys16a(VS.71).aspx</a> describes how to access a SQL database through Visual Basic.
This site:
<a href="http://visualbasic.about.com/od/learnvb6/l/bldykvb6dosa.htm">http://visualbasic.about.com/od/learnvb6/l/bldykvb6dosa.htm</a> discuses using VB in DOS, which might make accessing your printer a bit easier.
Good Luck!
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
