a small code sample:
cnt = new Connection();
stmt = cnt.createStatement();
res = stmt.executeQuery(strfmt("EXEC sp_test \'%1\'",itemId));
while (res.next())
{
counter++;
temp.Pos = counter;
temp.ItemId = res.getString(1);
temp.ItemName = res.getString(2);
temp.Qty = res.getInt(3);
temp.SalesPrice = res.getReal(4);
temp.insert();
}
return temp;
Markus
--- In Axapta-Knowledge-Village@yahoogroups.com, [EMAIL PROTECTED]
wrote:
>
>
> Hi Steeve,
>
> Thanks.
>
> regards,
> M.Premkumar
>
>
>
>
> "Steeve
Gilbert"
> <[EMAIL PROTECTED]> To: <Axapta-
[EMAIL PROTECTED]>
> Sent by:
cc:
> [EMAIL PROTECTED]
Subject: RE : [Axapta-Knowledge-Village] Is Triggers and
Stored
> groups.com
Procedures are available in
Axapta.
>
>
> 11/05/2006 02:32
AM
> Please respond
to
> Axapta-Knowledge-
Village
>
>
>
>
>
>
> Hi Prem,
>
> You just can't handle triggers in Axapta. Axapta won't know
there's
> triggers and the same goes for Stored Procedures. But you can
call stored
> procedures using UserConnection to execute SQL the "pure" SQL way.
>
> Regards,
>
> Steeve...
>
>
> -----Message d'origine-----
> De : Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] De la part de
> [EMAIL PROTECTED]
> Envoyé : 9 mai 2006 00:32
> À : Axapta-Knowledge-Village@yahoogroups.com
> Objet : RE: [Axapta-Knowledge-Village] Is Triggers and Stored
Procedures
> are available in Axapta.
>
>
> Hi,
>
> I know how to create Triggers and Procedures in SQL Server,
> but my doubt is how to handle this in Axapta.(back end SQL Server)
>
> with regards,
> Prem
>
>
>
>
>
>
>
> "Harry Deshpande"
>
> <[EMAIL PROTECTED]> To:
> <Axapta-Knowledge-Village@yahoogroups.com>
> Sent by: cc:
>
> [EMAIL PROTECTED]
Subject: RE:
> [Axapta-Knowledge-Village] Is Triggers and Stored
> groups.com
Procedures are
> available in Axapta.
>
>
> 08/05/2006 08:50 PM
>
> Please respond to
>
> Axapta-Knowledge-Village
>
>
>
>
>
>
>
> hi
>
> I guess you will have to post in SQL server forum
>
> regards
>
> harry
>
> ________________________________
>
> 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.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
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
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
