The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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.

asked 27 Jul '16, 09:16

Jongee's gravatar image

Jongee
17281117
accept rate: 0%

edited 28 Jul '16, 03:23

Provided that Infopath form allows connections via ODBC or ADO.NET, you should be able to execute a procedure.

(27 Jul '16, 09:21) Chris Keating

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.

(27 Jul '16, 09:22) Jongee
Replies hidden
1

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.

(27 Jul '16, 10:21) Breck Carter

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.

(28 Jul '16, 03:25) Jongee

When creating a report, the wizard prompts for a data source which will include Stored Procedure (if the database supports procedures).

(28 Jul '16, 08:05) Chris Keating
Replies hidden

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.

(28 Jul '16, 08:56) Jongee
showing 3 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×106

question asked: 27 Jul '16, 09:16

question was seen: 390 times

last updated: 28 Jul '16, 08:56