| Rownum problem in Oracle 7 [message #372125] |
Thu, 11 January 2001 14:11  |
Jason Yeung
Messages: 1
Registered: January 2001
|
Junior Member |
|
|
I am currently developing a website using Oracle Rdb SQL V7.0-4 as the database. I am trying to use a SQL statement that queries the first 5 rows using the rownum variable. The SQL statement I used is:
SELECT
ASM_HC_READ,
ASM_CO_READ,
ASM_NOX_READ,
IDLE_HC_READ,
IDLE_CO_READ,
ASM_HC_RES,
ASM_CO_RES,
ASM_NOX_RES,
ASM_HC_REC_READ,
ASM_CO_REC_READ,
ASM_NOX_REC_READ,
IDLE_HC_REC_READ,
IDLE_CO_REC_READ,
registration, vin
FROM VTR_VIEW
WHERE vin LIKE 'qwertyui%'
AND rownum < 5
AND ASM_REQ = 'P'
AND ASM_HC_RES = 'P'
AND ASM_CO_RES = 'P'
AND ASM_NOX_RES = 'P'
AND IDLE_HC_RES = 'P'
AND IDLE_CO_RES = 'P'
AND ASM_HC_READ <= ASM_HC_REC_READ
AND ASM_CO_READ <= ASM_CO_REC_READ
AND ASM_NOX_READ <= ASM_NOX_REC_READ
AND IDLE_HC_READ <= IDLE_HC_REC_READ
AND IDLE_CO_READ <= IDLE_CO_REC_READ
AND Date_Time >= '09/15/2000'
When I ran this query, I get the following error: "OracleODBCRdb%SQL-F-ORAROWNUM,ROWNUM only available in ORACLE LEVEL1 dialect"
I was wondering what this error means? I checked the syntax of the SQL statement and it appears to be correct.
Jason
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
