JasonYeung
Programmer
I am 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: "[Oracle][ODBC][Rdb]%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
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: "[Oracle][ODBC][Rdb]%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