Run a Stored Procedure from a Command Button in Infomaker

[former_SQLA_member1694895]

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.

[chris_keating]

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

[former_SQLA_member1694895]

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.

[Breck_Carter]

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.

[former_SQLA_member1694895]

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.

[chris_keating]

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

[former_SQLA_member1694895]

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.