I need to return values from a stored procedure using SQL Server 2000 to a VB6 program. The stored procedure will calculate the values but I can't get it to return the values to the program. Thanks in advance for any help given.
LateCharge
If None
MsgBox (“Accept a payment or charge on the customer’s account.”)
Select Case '*** Be sure Its Select Case
Case Payment
Call CashierModule
Case Charge
UserOwes + LateCharge
End...
Visual Basic has a built in function to do this.
here's an example that may help.
Public Function RemoveQuote(sString2Change As String) As String
RemoveQuote = Replace(sString2Change, "'", " ")
End Function
The Replace function is the key. the first parameter is the...
I'm trying to build an SQLString for the crystal report control. I'm new to Crystal Reports. If anyone can help me, I'm desperate. I need to assign the sqlString to the Crystal Report. I've tried this
With CrystalReport1
.SQLString = "Select * from MyTableName"
End With
But...
In response to your second question you may want to add some code to your form_load event. This code opens a recordset with no results. It allows you to retrieve field definitions from the db. You have to set the textbox.tag = to the fieldname so it will know which field it is. Hope it helps...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.