If you use the class, Statement
<http://dev-wss/Technical/Forms/DispForm.aspx?ID=107&RootFolder=%2fTechn
ical%2fMicrosoft%20Business%20Solutions%2fTechnical%20Information%20%2d%
20versions%2f2%2e5&Source=http%3a%2f%2fdev%2dwss%2fTechnical%2fMicrosoft
%20Business%20Solutions%2fTechnical%20Information%20%2d%20versions%2f2%2
e5> , then you can do everything which you normally would do from eg.
Query Analyzer.
Example from Appl.doc:
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
ResultSet R = Stmt.executeQuery('SELECT VALUE FROM
SQLSYSTEMVARIABLES');
while ( R.next() )
{
print R.getString(1);
}
Regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
________________________________
From: Jako Boon [mailto:[EMAIL PROTECTED]
Sent: 2. februar 2005 16:09
To: Yahoo Axapta
Subject: [development-axapta] Calling Stored Procedures from axapta
Hi,
Is it at all possible to call a MSQL Stored procedure with parameters in
Axapta through X++ code? If so is there some preferred syntax that I can
use.
Thanks
Jako Boon
iSoft Technologies (Pty) Ltd
(You can contact iSoft @ +27 12 3454720)
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.5 - Release Date: 2005/01/26
[Non-text portions of this message have been removed]
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
