[prev in list] [next in list] [prev in thread] [next in thread] 

List:       r-help
Subject:    [R] BETWEEN
From:       Margarida =?iso-8859-1?Q?J=FAlia?= Rodrigues Igreja <migreja () med ! up ! pt>
Date:       1997-01-01 0:55:38
Message-ID: 4.3.2.7.1.19970101005426.00ad7c10 () mail ! med ! up ! pt
[Download RAW message or body]

Hi,

I have another problem, can you help?

When i type:
 > library(RODBC)
 > a<-odbcConnect("oracle")
 > sqlQuery(a,"select DISTINCT(DOENT_ID) from EPISGDHS where (VALFACT 
BETWEEN 100 AND 50)")


Comes the error:
[1] "S1000 904 [unixODBC][Easysoft][Oracle]ORA-00904: \"DOENT_ID\": invalid 
identifier at offset 16"
[2] "[RODBC] ERROR: Could not SQLPrepare"

Margarida Igreja.

using WinNT




	[[alternative HTML version deleted]]

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[prev in list] [next in list] [prev in thread] [next in thread]