Topic: The clause ORDER BY doesn't work in insert/update/delete
|
|
Alexandre Paiva
Visitor
|
|
The clause ORDER BY doesn't work in insert/update/delete
|
|
Posted: 2001/03/02 12:47 |
|
|
|
|
Hi Dmitry;
When I try to use the clause ORDER BY in a query used for INSERT/UPDATE/DELETE,with UPDATESQL, the oracle 8.0.6 return a mistake: ORA-00907 = "Absent right parenthesis";
PS: Didn't you verify the email that I sent her?
Regards;
Alexandre Paiva
|
|
Alexandre Paiva
Visitor
|
|
RE: The clause ORDER BY doesn't work in insert/update/delete
|
|
Posted: 2001/03/02 13:55 |
|
|
|
|
I again;
After me to have posted the message with the mistake ORA-00907, I continued the tests, and I discovered which was the problem.
The mistake only appeared, when the property RecordCountMode of the component OCIQuery, was same the: cmExactAllways or cmExactOnOpen.
When I passed the property for cmFetched everything worked marvelously.
I accomplished these test with program demo Demosblobs2. He now is working perfectly.
I am sending one copies for your email.
Tank you;
Regards;
Alexandre Paiva.
|
|
Alexandre Paiva
Visitor
|
|
RE: The clause ORDER BY doesn't work in insert/update/delete
|
|
Posted: 2001/03/02 14:04 |
|
|
|
|
Hi Dmitry;
After me to have posted the message with the mistake ORA-00907, I continued the tests, and I discovered which was the problem.
The mistake only appeared, when the property RecordCountMode of the component OCIQuery, was same the: cmExactAllways or cmExactOnOpen.
When I passed the property for cmFetched everything worked marvelously. With clause ORDER BY.
I accomplished these test with program demo Demosblobs2. He now is working perfectly.
I am sending one copies for your email.
Tank you;
Regards;
Alexandre Paiva.
|
|
Diman
Admin
Admin
| Posts: 1509 |  |
Karma: 20
|
|
RE: The clause ORDER BY doesn't work in insert/update/delete
|
|
Posted: 2001/03/02 23:11 |
|
|
|
|
Hello !
NCOCI8 does not parse SQL. So any query, that NCOCI8 is building, using original SQL, will looks like:
SELECT ... FROM (<original SQL> ... or
INSERT INTO (<original SQL> ...
Oracle8 does not like such SQL, when original SQL contains ORDER BY ;( Only 8.1.7 accept (?) all mentioned above syntax.
|
|
Alexandre Paiva
Visitor
|
|
RE: The clause ORDER BY doesn't work in insert/update/delete
|
|
Posted: 2001/03/03 01:58 |
|
|
|
|
Hi Dmitry;
My English is very poor. Where I wrote tank you, be read thank you. Excuse.
Now... THANK YOU !!!
PS: Don't leave verify the email that I sent to you.
Alexandre Paiva.
|
|
|
