Tips: How to execute stored procedure - InfoPath Dev
in

InfoPath Dev

Tips: How to execute stored procedure

Last post 10-23-2006 12:08 PM by Agni Jonnalagadda. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-19-2006 04:57 AM

    • hotikisu
    • Not Ranked
    • Joined on 10-20-2006
    • Japan
    • Posts 6

    Tips: How to execute stored procedure

    IntoPath form can execute stored procedure of Microsoft SQL Server.

    (1)Create new form.
    (2)Create data source.
    (2)Edit SQL.
    -------------------------------
    SET NOCOUNT ON
    SELECT 'dummy'
    EXECUTE <StoredProcedureName>
    -------------------------------
    (3)Make a button.
    (4)Set a buttun behavior "transmission of a message of a query"
    (5)Preview the form.
    (6)Click the button, then execute stored procedure.

    sorry bad english.I am Japanese.
    ---------------------------------------
    Yoshio Matsumoto (hotikisu)
    MVP for InfoPath, Japan
    ---------------------------------------
  • 10-23-2006 12:08 PM In reply to

    Re: Tips: How to execute stored procedure

    Hello Yoshio Matsumoto,
    Welcome to InfoPathDev! Good to see another MVP post here.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.