Visual Basic SQL Customization

(0) Share

Report

Posted on by joe

935

I have a stored procedure in SQL that I would like to trigger from a custom button on a Dynamics SL form. Can someone help me do this? please!? thanks!

*This post is locked for comments

All responses (5)

Answers (0)

dboicourt 5 on at

Like (0)

Report

Re: Re: Visual Basic SQL Customization

So nobody has an answer to this? I have a need to click the start button on the processmanager screen. I realize that autostart should do this, but apparently sometimes it does not.
joe 935 on at

Like (0)

Report

Re: Visual Basic SQL Customization

Thank you for the repsonses. We ended up using ADO to get it to work. However we still would like to know if its possible to write code to simulate clicking a builtin button.
Thank You!
Nagesh Boppana 295 on at

Like (0)

Report

Re: Re: Re: Visual Basic SQL Customization

Not required. what is the error you are getting?
joe 935 on at

Like (0)

Report

Re: Re: Visual Basic SQL Customization

does c1 need to be defined?
Also is it possible to click a builtin SL button via code? I've tried buttonName_Click but it doensn't work.

Thanks!
Nagesh Boppana 295 on at

Like (0)

Report

Re: Visual Basic SQL Customization

Hi,

Use the code something like follwoing in your custom button click event.

call Sql(C1,storedproc name)

call sqlfree(c1)

Regards,

Nagesh