Re: [R] Faced Problems with RODBC package 1.2-5 and 1.2-4 for windows

2009-01-28 Thread Mark Wardle
You need to include much more information.

Try creating a reproducible example - you may find the answer in the
process of doing this.

You may find the posting guide for the mailing list to be helpful -
you've had no replies because you haven't explained your problem well
enough.

Mark

2009/1/28 Nikhil Bhide :
> Hi,
>
>I am facing problems with RODBC package 1.2-5 and 1.2-4  built for
> windows. I am using R  2.8.1 version.
>I faced some problems when I was trying to execute sql procedure
> from R  with exec/execute statement .
>
>Stored procedure contains code/statements :
>1) Call to another procedure (R calls one procedure which itself
> calls another procedure)
>2) Iteration (while loop)
>   I created stored procedure in which I used while loop
> and while loop contains two insert statements.I executed procedure from R.
> I found that expected results are not matching with the   results I got.
> Also results are not consistent.
>3) SET QUOTED_IDENTIFIER OFF statement
>
> Please give me a solution
>
> regards,
> Nikhil Ashok Bhide
> Cell:- +919604848030
> Mailto: nikhil.bh...@tcs.com
> Website: http://www.tcs.com
> 
> Experience certainty.   IT Services
>Business Solutions
>Outsourcing
> 
> ForwardSourceID:NT1B0E
> =-=-=
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>
>[[alternative HTML version deleted]]
>
> __
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>
> __
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> __
>



-- 
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


[R] Faced Problems with RODBC package 1.2-5 and 1.2-4 for windows

2009-01-28 Thread Nikhil Bhide
Hi,

I am facing problems with RODBC package 1.2-5 and 1.2-4  built for 
windows. I am using R  2.8.1 version.
I faced some problems when I was trying to execute sql procedure 
from R  with exec/execute statement . 

Stored procedure contains code/statements : 
1) Call to another procedure (R calls one procedure which itself 
calls another procedure)
2) Iteration (while loop) 
   I created stored procedure in which I used while loop 
and while loop contains two insert statements.I executed procedure from R. 
I found that expected results are not matching with the   results I got. 
Also results are not consistent.
3) SET QUOTED_IDENTIFIER OFF statement 

Please give me a solution 

regards,
Nikhil Ashok Bhide
Cell:- +919604848030
Mailto: nikhil.bh...@tcs.com
Website: http://www.tcs.com

Experience certainty.   IT Services
Business Solutions
Outsourcing

ForwardSourceID:NT1B0E 
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.