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.
27 Jul '16, 09:16
28 Jul '16, 03:23
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...
Infopath Form command button "stored procedure"
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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
learn more about Markdown
question asked: 27 Jul '16, 09:16
question was seen: 199 times
last updated: 28 Jul '16, 08:56
Breaking a sybase stored procedure
DBISQL 22.214.171.12424 does not display the single result set of a stored procedure by default
How to left join to a stored procedure
SQL Error Cursor not open
Protecting intellectual property
Stored procedure seems like hidden in Sybase Central
communication error from aSaCommand.ExecuteScalar()
SA12 stored procedure/function bug?
Deep level calling of Stored Procedures - Expensive
Using Derived tables in views
SQL Anywhere Community Network
Terms of Service
Powered by SQL Anywhere 17
Disclaimer: Opinions expressed here are those of the poster and do not
necessarily reflect the views of the company.
First time here? Check out the FAQ!