You’re offline. This is a read only version of the page.
Announcements
555
Hi,
In customization, i want to read a text box Value and call Sql Procedure.Please
send any sample "VB" codes..
Thanks,
Thillai
*This post is locked for comments
Mr .JustinHat it's working Very thanks !!!!!!
For the example below, you'll need to have create or use a DH file that is the same structure as what the stored proc is returning.
Global csr_SampleSP as Integer
Dim xString As String
Dim xSQL As String
xString = Trim(GetObjectValue("cCustId"))
xSQL = "xsp_SampleSP " & SParm(xString)
Call sql(csr_SampleSP, xSQL)
serr1 = SFetch1(csr_SampleSP,bSampleSP,LenB(bSampleSP))
if serr1 <> NOTFOUND then
Call MessBox("CustomerId: " & Trim(bSampleSP.CustID))
end if
Call SqlFree(csr_SampleSP)
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
