Displaying 2 results from an estimated 2 matches for "episgdhs".
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
[[alternative HTML ver...
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...