|
Hi I was just wondering if it was possible to run a Stored Procedure from an Infomaker Form using a command button? I am able to customise our CRM system by creating forms/reports in Infomaker. |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 27 Jul '16, 09:16
question was seen: 2,450 times
last updated: 28 Jul '16, 08:56
Provided that Infopath form allows connections via ODBC or ADO.NET, you should be able to execute a procedure.
There is an ODBC connection as I am able to pull in data from the database. What I can't find out is how to use a button to launch the stored procedure.
Google is your friend...
Here's one result: How to work with stored procedures by using script in an InfoPath form.
Thanks, and apologies. When I looked at your suggestion I realised I entered the wrong software. I need to run the Stored Procedure from an Infomaker form, NOT Infopath (that is when I am working on Sharepoint).
I have edited my question to reflect this.
When creating a report, the wizard prompts for a data source which will include Stored Procedure (if the database supports procedures).
Yes and I choose the fields I want, then I am taking to the form painter where I can insert a button. But there isn't an option for the button to run a stored procedure.