[R] Re: problem in long select from RODBC
wolski at molgen.mpg.de
Wed Jun 16 14:42:42 CEST 2004
You can protect the line break with a backslashes
sqlQuery(channel, "select dir, c \
from firsthit3 \
where dir LIKE \"%SCHULEN%\"")
*********** REPLY SEPARATOR ***********
On 16.06.2004 at 14:37 Luis Rideau Cruz wrote:
>I have a very long sql select.
>The problem is that (as selects have to be in one line) is so long that
>when I copy-paste from the text file there is a "sintax error" .I have
>checked the select and it is working in SQL Plus but I believe the problem
>lies in the length of it.
>Can you help me?
>Luis Ridao Cruz
>P.O. Box 3051
>Phone: +298 353900
>Phone(direct): +298 353912
>Mobile: +298 580800
>Fax: +298 353901
>E-mail: luisr at frs.fo
More information about the R-help