"Stephen A. Fuqua" wrote: > > Here's the basic situation: I want to upload data via SQL to a database, > and then check if the insert statement executed properly. Idealy, if my > database object is called "db", I would like to have db->Query("insert > ...") return a value indicating success. Obviously, values are returned > if the query string contains a select statement. But what if its just a > command, not a question? > > In summation: how do I tell if a query command executed properly? > > Stephen A. Fuqua > Hi Stephen, try RDBC which is JDBC/ROOT SQL complient. Download the latest snapshot from http://d-000692-co.dhcp.fnal.gov/~onuchin/tmp/ RDBC-1.0.2-010218.tar.gz Use ( check also examples from macros directory ) Int_t TSQLStatement::ExecuteUpdate( const TString& sql ) { // Executes an SQL INSERT, UPDATE or DELETE statement. // In addition, SQL statements that return nothing, // such as SQL DDL statements, can be executed. // // Parameters: // sql - a SQL INSERT, UPDATE or DELETE statement or // a SQL statement that returns nothing // // Returns: // either the row count for INSERT, UPDATE or DELETE or // 0 for SQL statements that return nothing // Throws: // TSQLException - if a database access error occurs HTH. Valeriy
This archive was generated by hypermail 2b29 : Tue Jan 01 2002 - 17:50:36 MET