Faced Problems with RODBC package 1.2-5 and 1.2-4 for windows
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 <nikhil.bhide at tcs.com>:
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.bhide at tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
ForwardSourceID:NT00001B0E
=====-----=====-----=====
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 at 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