Announcements
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)
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156