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
15251117
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: 305 times

last updated: 28 Jul '16, 08:56