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

[Rufus]

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....."

[Rufus]

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