c# - MySQL - UPDATE query not effecting row -

-

i have update query not working doesn't show errors, no rows effected/ matched:

update `budget` set `amount` = 500, `rest` = 500 `company_number` = 1 , `section_number` = 1 , `chapter_number` = 1 , `article_number` = 3 , `subarticle_number` = 0 , `ssubarticle_number` = 0

but when "select" database got row returned:

select * budget `company_number` = 1 , `section_number` = 1 , `chapter_number` = 1 , `article_number` = 3 , `subarticle_number` = 0 , `ssubarticle_number` = 0

this "budget" table:

create table `budget` (   `budget_id` int(11) not null auto_increment,   `company_number` int(11) not null default '0',   `section_number` int(11) not null default '0',   `chapter_number` int(11) not null default '0',   `article_number` int(11) not null default '0',   `subarticle_number` int(11) not null default '0',   `ssubarticle_number` int(11) not null default '0',   `name` varchar(90) default null,   `amount` double default null,   `rest` double default null,   `insert_date` date default null,   `transfer_date` date default null,   `has_children` bit(1) default null,   primary key (`budget_id`) ) engine=innodb auto_increment=16 default charset=utf8;

the method use run queries.

public bool updatetransfer(string companynumber, string sectionnumber, string transfernumber, string transferdate,                                     string[] budgetrow, string oldamount, string newamount)         {             mysqltransaction tr = connection.begintransaction();             cmdquery = connection.createcommand();             cmdquery.connection = connection;             cmdquery.transaction = tr;             try             {                 cmdquery.commandtext = @"set sql_safe_updates = 0;";                 cmdquery.executenonquery();                   // first, return old amount source row budget                 cmdquery.commandtext = @"update budget set `rest` = `rest` + " + oldamount +                                         " `company_number` = " + companynumber + " , `section_number` = " + sectionnumber +                                         " , `chapter_number` = " + budgetrow[0] + " , `article_number` = " + budgetrow[1] +                                         " , `subarticle_number` = " + budgetrow[2] + " , `ssubarticle_number` = " + budgetrow[3];                 cmdquery.executenonquery();                 messagebox.show(cmdquery.commandtext);                  // second, make transfer , substract new amount source row budget                 cmdquery.commandtext = @"update `budget` set `rest` = `rest` - " + newamount +                                         " `company_number` = " + companynumber + " , `section_number` = " + sectionnumber +                                         " , `chapter_number` = " + budgetrow[0] + " , `article_number` = " + budgetrow[1] +                                         " , `subarticle_number` = " + budgetrow[2] + " , `ssubarticle_number` = " + budgetrow[3];                 cmdquery.executenonquery();                 messagebox.show(cmdquery.commandtext);                  // third, update rest , new amount of destination row budget                 cmdquery.commandtext = @"update `budget` set `amount` = " + newamount + ", `rest` = " + newamount +                                         " `company_number` = " + companynumber + " , `section_number` = " + sectionnumber +                                         " , `chapter_number` = " + budgetrow[4] + " , `article_number` = " + budgetrow[5] +                                         " , `subarticle_number` = " + budgetrow[6] + " , `ssubarticle_number` = " + budgetrow[7];                 cmdquery.executenonquery();                 messagebox.show(cmdquery.commandtext);                  // last step, update transfer table.                 cmdquery.commandtext = @"update `transfer` set `amount` = " + newamount + ", `transfer_date` ='" + transferdate + "'" +                                         " `transfer_number` = " + transfernumber +                                         " , `company_number` = " + companynumber + " , `section_number` = " + sectionnumber +                 cmdquery.executenonquery();                 messagebox.show(cmdquery.commandtext);                  cmdquery.commandtext = @"set sql_safe_updates = 1;";                 cmdquery.executenonquery();                 tr.commit();                 return true;             }             catch (mysqlexception ex)             {                 messagebox.show("error " + ex.errorcode.tostring());                 tr.rollback();                 return false;             }         }     }

here example on how can verify if there row changes after executing sql on c#

public static boolean performdatabaseaction(string sqlquery)  {     using (sqlconnection con = dbconnect()) // sqlconnection     {         sqlcommand cmd = new sqlcommand(sqlquery);          cmd = new sqlcommand(sqlquery);          commandtype = system.data.commandtype.text;          connection = con;          int rows = cmd.executenonquery(); // gets count of affected rows         if(rows > 0)             return true;         else              return false;     } }

and query works try on one.


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more