Execute Stored Procedure on Axapta Example.
   
    Connection      con;
    Common          common;
    str             sql;
    Statement       stmt;
    ResultSet       set;
    ;

    super();

    con = new Connection();

    //SPAX_GetCustTable Procedure in SQL Server.
    sql = StrFmt("SPAX_GetCustTable '%1'",curExt());
    stmt    = con.createStatement();
    set     = stmt.executeQuery(sql);

    while(set.next())
    {
        //Retrive the first field (int Type)
        common.RecId = set.getInt(1);
    }

Tuorto Emiliano


> From: Axapta-Knowledge-Village@yahoogroups.com on behalf of
[EMAIL PROTECTED]
> Sent: Mon 5/8/2006 1:44 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] Is Triggers and Stored
Procedures are available in Axapta.
>
>
>
>
> Hi Friends,
>
>
> I want to add Triggers and Stored Procedures in back end.(SQL
Server).
> Please help me in this regard.
>
>
> with regards,
> M.Premkumar
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>









Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.




SPONSORED LINKS
Business finance course Business to business finance Small business finance
Business finance consultant Business finance magazine Business finance schools


YAHOO! GROUPS LINKS




Reply via email to