Hello,
I am doing the administration application with the oracle database. I am using PHPLib's classes to connect and query the database. All the queries work (INSERT, UPDATE, etc), except DELETE.
When I select in the application to delete a row in the database, the DELETE statement just deletes the contents of the fields, except the ID field.
The delete statement is very simple - "DELETE from table where some_id = <something>"..
This deletes every value in that row except some_id (which still has the same value)..
When I try the same statement in SQLPLUS, it works without problems.
The PHPLib's oracle class is doing a COMMIT after each query.
Any help would be appreciated!
Regards, alex.
I am doing the administration application with the oracle database. I am using PHPLib's classes to connect and query the database. All the queries work (INSERT, UPDATE, etc), except DELETE.
When I select in the application to delete a row in the database, the DELETE statement just deletes the contents of the fields, except the ID field.
The delete statement is very simple - "DELETE from table where some_id = <something>"..
This deletes every value in that row except some_id (which still has the same value)..
When I try the same statement in SQLPLUS, it works without problems.
The PHPLib's oracle class is doing a COMMIT after each query.
Any help would be appreciated!
Regards, alex.