ADOQuery not updating the database in C++ Builder 2009
Posted: 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:
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
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
Can anyone help me??
Thnx