Hi Karsten,
Thanks for the info it solved my problem. Regards Jako -----Original Message----- From: Karsten Wollesen [mailto:[EMAIL PROTECTED] Sent: 02 February 2005 17:16 To: [email protected] Subject: RE: [development-axapta] Calling Stored Procedures from axapta Hi Jako, 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 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.4 - Release Date: 2005/02/01 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2005/02/03 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2005/02/03 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: http://docs.yahoo.com/info/terms/
