Hi,
Here is an example which selects username from the table userinfo.
static void Job25(Args _args)
{
Statement stmt;
resultSet resultSet;
OdbcConnection odbcCon = new Connection();
str username;
;
stmt = odbcCon.createStatement();
resultSet = stmt.executeQuery('SELECT NAME FROM USERINFO ORDER BY
NAME');
while (resultSet.next())
{
userName = resultSet.getString(1);
info(userName);
}
}
Regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
http://development.thydatacenter.dk/
http://groups.yahoo.com/group/development-axapta/
-----Original Message-----
From: affekatz [mailto:[EMAIL PROTECTED]
Sent: 15. november 2004 15:12
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] retrieve data via sql statement
Ive got a sql statement which looks like this:
S.executeQuery( select statement );
can anyone give me a short example that shows how to retrieve the
data into a string
Sharing the knowledge on Axapta.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> 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/
