ADOQuery not updating the database in C++ Builder 2009

olanasta · Post by **olanasta** » Thu 17 Sep 2009 14:58

Hello

I'm using C++ Builder 2009 and Oracle 11g. I have a strange error (I can't understand what is happening) and a dead line to finish my project!
When I try to update a record in a table, nothing happens!!! I tried the same query in Toad, and everything went perfectly.

My query is:

Code: Select all


UPDATE GYM_PROGRAM
SET EXERCISE1  = :EXERCISE1,
       EXERCISE2  = :EXERCISE2,
       EXERCISE3  = :EXERCISE3,
       EXERCISE4  = :EXERCISE4,
       EXERCISE5  = :EXERCISE5,
       EXERCISE6  = :EXERCISE6,
       EXERCISE7  = :EXERCISE7,
       EXERCISE8  = :EXERCISE8,
       EXERCISE9  = :EXERCISE9,
       EXERCISE10 = :EXERCISE10,
       SET1       = :SET1,
       SET2       = :SET2,
       SET3       = :SET3,
       SET4       = :SET4,
       SET5       = :SET5,
       SET6       = :SET6,
       SET7       = :SET7,
       SET8       = :SET8,
       SET9       = :SET9,
       SET10      = :SET10,
       REP1       = :REP1,
       REP2       = :REP2,
       REP3       = :REP3,
       REP4       = :REP4,
       REP5       = :REP5,
       REP6       = :REP6,
       REP7       = :REP7,
       REP8       = :REP8,
       REP9       = :REP9,
       REP10      = :REP10,
       TMBRKS1    = :TMBRKS1,
       TMBRKS2    = :TMBRKS2,
       TMBRKS3    = :TMBRKS3,
       TMBRKS4    = :TMBRKS4,
       TMBRKS5    = :TMBRKS5,
       TMBRKS6    = :TMBRKS6,
       TMBRKS7    = :TMBRKS7,
       TMBRKS8    = :TMBRKS8,
       TMBRKS9    = :TMBRKS9,
       TMBRKS10   = :TMBRKS10
WHERE  GP_CODE    = :GP_CODE

While I was searching for a solution, I found DBMonitor and I thought that it may help me realize what is going on, but I don't know how to use it. It runs but nothing happens, when I test my project.

Can anyone help me??

Thnx

Plash · Post by **Plash** » Fri 18 Sep 2009 07:00

You should drop the TOraSQLMonitor component on the form to enable monitoring of your application.