Hi,
In customization, i want to read a text box Value and call Sql Procedure.Please
send any sample "VB" codes..
Thanks,
Thillai
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.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148