| Subject | Problem with update or insert into |
|---|---|
| Author | diegogandino |
| Post date | 2010-01-09T11:52:29Z |
Im using this statement to maintaing the data in a table, but when I insert a new record I dont see the new data in the table. I'm codding with VB6 and ADO 2.5.
If I execute the same statement in EMS and after that I execute a commit the new data appear in the database. This dosent occur when I execute separate INSERT OR UPDATE.
In the code I begin a transaction and after execute the Update or Insert into I commit the transaction... but the new record doesnt appear in the table.
Sorry for my english, I'm writting from Argentina.
If I execute the same statement in EMS and after that I execute a commit the new data appear in the database. This dosent occur when I execute separate INSERT OR UPDATE.
In the code I begin a transaction and after execute the Update or Insert into I commit the transaction... but the new record doesnt appear in the table.
Sorry for my english, I'm writting from Argentina.