problem inserting
Posted: 22.01.2007, 10:00
I have a problem,
I'm using the borland c++ 6.0, and now with a project I'm trying to put it in a class, so I have now 2 components in the class : ZConnection, ZQuery.
When I try to run a update query: "UPDATE run SET `rejected` = `rejected` +1 WHERE `ID` = 4" it does not execute the query, but if I do this trough a created form and then place the 2 objects it works fine..
I made several functions in the class: Connect(), AddQuery(AnsiString Query), StartQuery(), SqlCleanUp().
My first call:
Connect(); (I set the params correctly to mysql 5.0, since it has a connection).
Second call:
AddQuery("UPDATE run SET `rejected` = `rejected` +1 WHERE `ID` = 4");
Third call:
StartQuery(); //And nothing happens, no connectivity at all
Is there anything that I forget or don't see ?
I'm using the borland c++ 6.0, and now with a project I'm trying to put it in a class, so I have now 2 components in the class : ZConnection, ZQuery.
When I try to run a update query: "UPDATE run SET `rejected` = `rejected` +1 WHERE `ID` = 4" it does not execute the query, but if I do this trough a created form and then place the 2 objects it works fine..
I made several functions in the class: Connect(), AddQuery(AnsiString Query), StartQuery(), SqlCleanUp().
My first call:
Connect(); (I set the params correctly to mysql 5.0, since it has a connection).
Second call:
AddQuery("UPDATE run SET `rejected` = `rejected` +1 WHERE `ID` = 4");
Third call:
StartQuery(); //And nothing happens, no connectivity at all
Is there anything that I forget or don't see ?