R help - Mar 2004 - BETWEEN

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]]