search for: valfact

Displaying 2 results from an estimated 2 matches for "valfact".

Did you mean: valat
UNION
2004 Mar 29
0
UNION
Hi, I have a problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"(select VALFACT>500 from EPISGDHS) UNION (select VALFACT<1000 from EPISGDHS)") Comes the error: [1] "S1000 923 [unixODBC][Easysoft][Oracle]ORA-00923: FROM keyword not found where expected at offset 15" [2] "[RODBC] ERROR: Could not SQLPrepare" Margarida Igreja. using WinNT [...
BETWEEN
2004 Mar 29
0
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]]