Oracle database trigger does not work with Visual Basic form

I wrote a 'BEFORE INSERT OR UPDATE' trigger against a table in Oracle7 database. It works well when I try to insert/update data in that table from SQL*Plus and from Oracle Forms 4.5/5.0. But this trigger does not work when I try to insert/update data from a similar form created using Visual Basic 4.0 and connects to the database using ODBC. Please advise about a solution to this problem that I am facing with Visual Basic.

Thanx in advance.

areohwhy

I don't know how you are doing the update/insert, but if you use the same SQL string that you used in SQL Pluse, and execute it using the connection object, it has to work...

ConnectionObj.Execute "UPDATE .....WHERE....."

My thinking was that you are using ADO in code, if your not... I don't have a clue...