MARC47MARC47
Member
I use this this sql to query data:
=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
=================================================
The QBE return this SQL:
=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
where type = 1003
=================================================
I found two bug in QBE:
1. The QBE use the "TYPE" column name in WHERE,
and the oracle return "ORA-00904 "TYPE": invalid identifier
error message.
2. I can't edit the SQL window anymore after Error.
the PL/SQL version is 6.0.2.880
=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
=================================================
The QBE return this SQL:
=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
where type = 1003
=================================================
I found two bug in QBE:
1. The QBE use the "TYPE" column name in WHERE,
and the oracle return "ORA-00904 "TYPE": invalid identifier
error message.
2. I can't edit the SQL window anymore after Error.
the PL/SQL version is 6.0.2.880