The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
1183416
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:

×100

question asked: 27 Jul '16, 09:16

question was seen: 176 times

last updated: 28 Jul '16, 08:56