[R] Re: problem in long select from RODBC

[Wolski]

Hallo!

You can protect the line break with a backslashes


sqlQuery(channel, "select dir, c \
 from firsthit3 \
 where dir LIKE \"%SCHULEN%\"")

Sincerely

Eryk

*********** 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
>Fiskirannsóknarstovan
>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