Hi,
first thx for this help.
I have the same problem to call a stored procedere from Axapta.
The code works and is close to my own.
But if i try to catch the resultSet
There is a error message : No rows selected.
How can i handle a resultset of a stored procere?
Any suggestions?
Regards
Hi Abhijit,
You can try using the following job.
Here i had a stored procedure to get the expenses in a given period of time
for that i created this job.
static void storedProcedure(Args _args)
{
LogInProperty Lp = new LogInProperty();
OdbcConnection myConnection;
Statement myStatement;
ResultSet myResult;
;
LP.setServer("SON15075");
LP.setDatabase("DynamicsDevils");
try
{
myConnection = new OdbcConnection(LP);
}
catch
{
info("Check username/password.");
return;
}
myStatement = myConnection.createStatement();
myResult = myStatement.executeQuery("exec USP_retrieveExpenses
'09/15/2006', '09/15/2006'");
while (myResult.next())
{
print myResult.getString(3);
}
pause;
}
Hope this helps you in your job.
Regards,
Sumit Loya
On 6/13/07, abhijit raje <[EMAIL PROTECTED]
<mailto:abhi_hereus%40yahoo.com> > wrote:
>
> Hi Friends
> Can anyone help me in passing parameters to procedure
> through Axapta
[Non-text portions of this message have been removed]
