[R] Re: problem in long select from RODBC

Wolski 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:

>Hi all
>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?
>Thank you
>Luis Ridao Cruz
>Nóatún 1
>P.O. Box 3051
>FR-110 Tórshavn
>Faroe Islands
>Phone:             +298 353900
>Phone(direct): +298 353912
>Mobile:             +298 580800
>Fax:                 +298 353901
>E-mail:              luisr at frs.fo
>Web:                www.frs.fo

More information about the R-help mailing list