Share
ReportHi,
In customization, i want to read a text box Value and call Sql Procedure.Please
send any sample "VB" codes..
Thanks,
Thillai
You’re offline. This is a read only version of the page.
555
Hi,
In customization, i want to read a text box Value and call Sql Procedure.Please
send any sample "VB" codes..
Thanks,
Thillai
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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (