|
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. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
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,570 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.