Search update

40404 results
5

votes
1

answer

UPDATE vs UPDATE WHERE

I have a table with many rows, where I periodically want to set one column to 0 using a cron. What is faster / less memory consuming, doing an UPDATE on all rows (ie. no WHERE clause) or doing an UPDATE only WHERE mycolumn != 0?
Eduard Luca
4

votes
1

answer

Update tsvector update trigger

I have the following tsvector update trigger for a tsvector column 'user_tsv' on a table that allows me to perform full text searches, CREATE TRIGGER tsvector_user_update BEFORE INSERT OR UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(user_tsv, 'pg_catalog.english', firstnam...
DaveB
3

votes
2

answer

Using .update to update values

If we have a hash and we want to update one of the values or keys we can easily use the .update method like the following def foo(params) params+=1 end hsh = {:a=>1,:b=>2,:c=>3} hsh.update(hsh) do |key,oldVal| foo(oldVal) end p hsh However suppose a new hash, and I want to copy its properties into a...
bill
2

votes
1

answer

Core Data Update/AppStore update

I have an app in the AppStore which includes its own database. This database can be updated by the user. My question is, if I update with a new version y app, via AppStore, how can I mix old data with new data? I don't need to change the model, only mix data. Do I need to do a "Lightweight Migrati...
jcpp7
3

votes
0

answer

Tree conflict on update Update

I'm getting this while taking update in xcode. "The operation could not be performed because of one or more tree conflicts. The file XYZ.xcscmblueprint had a tree conflict." How could I get the path of ".xcscmblueprint" file in xcode. What to do to solve this problem. Thankyou in advance.
Roshanboy4u
3

votes
2

answer

execSQL() with UPDATE doesn't update

I am trying to use rawQuery and execSQL methods for manipulating my database, instead of the .update, .insert, etc. I am trying to perform an UPDATE with the following code: db.execSQL("UPDATE configuration " + "SET number_fields = " + number_fields + ", " + "frequency = " + frequency + ", " + "ag =...
TronicZomB
1

votes
2

answer

update-alternatives : update java path

I want to update the java path.After running the command sudo update-alternatives --config java I get following : Selection Path Priority Status ------------------------------------------------------------ 0 /usr/lib/jvm/java-6-openjdk/jre/bin/ja...
rachana
2

votes
8

answer

Update query update not work

I am doing Add, Update and Delete in Php. Everything is working fine but My Update query is not working. Can I know, where i am going wrong in Update query? Here is my update.php file code..
Rahul Barge
1

votes
2

answer

Update progress inside update panel

i have two buttons inside a update panel.i need to trigger update progress and show a .gif image for each button click.when i press a button1 only the associated update progress should be displayed and the other one should be invisible
chamara
4

votes
2

answer

update div asynchronously ---update comments

i have a textarea as below @Html.TextArea("txtComments", new {@style = "width: 450px;",@placeholder = "Enter Comments here" }) and when user hits add am saving(user entered comments and time) to DB using JQUERY AJAX. After this i need to show the data in div above the textarea whatever user entere...
user2067567
7

votes
2

answer

update on duplicate key update

I have a table that contains a shop id and a player's id, and a player's points. What I want to do is transfer points from a shop to the other, the thing is that shop id and players id form a unique index. What I want to do is on duplicate key update, instead of let it fail, to add the points of one...
Deus Deceit
1

votes
2

answer

Update SubmitChanges() - does not update

With this code there is no change in my database. when the above code is run there is no longer a new entry created neither is an entry updated. public void UpdateCallback(callback cb_) { callback call = context.callbacks.Single(c => c.callbackID == cb_.callbackID); //call.callbackID = cb_.callback...
Sreedhar
0

votes
2

answer

Update Dropdownlist on listview update using update panel asp.net c#

I want to re-populate data of a dropdownlist using sql data source when i insert or update data using the Listview control. Is there a way that i can do this without having to refresh my page manually? pid: type: description: Priceday: Priceweek: Pricemonth: Pricesem: Priceyear: pid: type: descripti...
Mr.Turtle125
3

votes
1

answer

Update embedded data on referenced data update

I am building a Meteor application and am currently creating the publications and coming up against what seems like a common design quandary around related vs embedded documents. My data model (simplified) has Bookings, each of which have a related Client and a related Service. In order to optimis...
Macros
1

votes
2

answer

Update field with jquery don't update observable

I want to say hello to the stackoverflow community. I've just started using knockout a few days ago. Right know I'm using it to make a dynamic menu builder for a CMS I'm working on. Here is the code: http://jsfiddle.net/dnlgmzddr/HcRqn/ The problem is that when I choose an element from the select bo...
dnlgmzddr
6

votes
2

answer

QWidget update events but no visual update

Using Qt4.8 on a Mint Linux 12, I implemented a simple window containing a QTableView to show contents of a model. The model data is continually updated (log messages) and the dataChanged() signal is emitted on a regular basis (i.e. every 100ms). The problem I see is stuttering visual updates on the...
arne
3

votes
2

answer

Update listview after update database sqlite

How to update items in listview after update the row on database sqlite. I have put notifyDataSetChanged() but not success, there is not error, but not refresh data in row. The data will change if I click menu back and open list again. So I want update the data in row after I update data. Below stru...
Dave Jackson
5

votes
2

answer

Update Firebase Instance ID on app update

Back in the GCM days it was recommended that every time you put out an update to your app you should check to see if a new registration id was given (since it is was not guaranteed to be the same after an update) when the app starts. Is that still the case with FCM? I couldn't find any documentation...
tyczj
2

votes
1

answer

Cannot update Dataflow job via Update Flag

I am trying to update DataFlow job by setting setUpdate flag in DataflowPipelineOptions to true. I have a function which checks for existing job with a name, and if the job is not there, I set setUpdate flag to false, otherwise true. This means for deploying the job for the first time, setUpdate fla...
duser
1

votes
2

answer

Apex update trigger - update lookup field

I'm trying to write my first Apex update trigger and struggling slightly as I'm trying to set the value of a custom lookup field. I have an object called Deployment__c which is the master in a master-detail relationship with an object called Service__c (names simplified!) The Service__c field has n...
JimmE
1

votes
1

answer

Trigger to update a column on update

I have written this function and this trigger: CREATE OR REPLACE FUNCTION test4() RETURNS TRIGGER AS $BODY$ BEGIN UPDATE "cf" SET vol=(area*alt); RETURN null; END; $BODY$ LANGUAGE plpgsql trigger CREATE TRIGGER trig_upd AFTER OR UPDATE ON "cf" FOR EACH ROW EXECUTE PROCEDURE test4(); I have tested my...
Giocor
2

votes
2

answer

Update Android Listview after Asynchronous update

I am converting my HTTP calls to asynchronous calls from synchronous ones. Because the connection is running in the background the data isn't there when I originally set my list adaptor. How can I get the list adaptor to update after my HTTP call? I've tried a few things like not setting the adaptor...
centreee
35

votes
1

answer

d3 update data and update graph

I have the following simple line in d3 but haven't an issue trying to figure out how to pass it data2 and update the line to reflect the change. D3 Line Chart Demo Update var data = [3, 7, 9, 1, 4, 6, 8, 2, 5]; var data2 = [3, 7, 9, 1, 4, 6, 8, 2, 15]; var width = 600; var height = 400; var max = d3...
Mike
2

votes
1

answer

Grails Foreign Key Update - Performance Update Object

I am creating a lot of objects and I am trying to get a bit of a performance boost. Currently I have an assignment for a gorm object attribute that I could get better performance out of if I could set the foreign key manually. For Example def oldBook = Book.findByTitle("Of Mice and Men") def newBoo...
davelt
12

votes
2

answer

package.config update does not update the references

I have multiple projects referencing the same NuGet Package. When I got latest code, I realized that one of the projects had an updated package.config and also updated reference to the Dll that is provided by that package. Now, I also updated package.config on other prjects hoping the as soon as I d...
Lost
2

votes
7

answer

Auto update your applications through Windows Update

Here is a scenario: User installs .NET application that you have made. After some time, you find a security issue in it and create a patch for it. When patch is ready, you post it "somewhere", and when next Windows update is run on user's machine (automatically or manually), that application is upda...
1

votes
3

answer

Pre-update and post-update in Hibernate

I want to use preupdate and postupdate concepts in my application. The purpose is i want to get all values of a particulra record which is being updated and insert these values as a record along with new values in a table named audit. Can any one give some suggestions or pointers on this. Thanks,...
Narendra
2

votes
1

answer

Update scope value after dynamically update textbox

in AngularJS I have scenario that the user selects a value from a grid in a popup and selected value is displayed in textbox in container page. After the user select a value, popup raises an event which is captured in container page. Now I can set the value of textbox using .val() but how do I updat...
Haris
2

votes
2

answer

Hibernate Update does Not Update Anything

In theory, this code should set the new lock status to the users and get that written to the database: transaction = sess.beginTransaction(); String hql = "update User set locked=:newLockStatus where principalId in (:userIds)"; Query query = sess.createQuery(hql); query.setBoolean("newLockStatus", l...
malaverdiere
1

votes
2

answer

UPDATE foreign key using UPDATE query

I'm trying to update a column, which is a foreign key, I'm trying to set it to a "NULL" value but the error says "ERROR 1452: Cannot add or update a child row: a foreign key constraint fails. " try { con.Open(); MySqlCommand cmd = new MySqlCommand( "UPDATE tblcdsummary set PersonalInfoID = '" +...
Ekko
1

votes
1

answer

Update JavaScript after C# UpdatePanel update

I have a dynamically created block of JavaScript which executes on page load. The JS is inside a UpdatePanel. When the UpdatePanel is updated, I need to update my dynamically created JavaScript. This all works fine as when I view the generated source of the page, I can see the updated JS. My problem...
Dan Ellis
1

votes
1

answer

MySQL update automatically a column after update

As the title says, I have a table with a column named last_update of type DATE. I want to make a trigger that set it to CURDATE() every time I update a row(set it for this particular row). I tried this: delimiter $$ CREATE TRIGGER before_customer_update before update on customer for each row begin u...
Grec Mihai
1

votes
2

answer

Update statement doesn't update my data

I would like to update/edit my user data in Employee table in access database. When i complete the fields that i want to change (name , last name, etc.), it gives me data updated but when i refresh the table, the data hasn't changed - been updated. Changes i want to perform for example - Change name...
fkr
3

votes
1

answer

javascript update lost on first async update

I have an update panel that has a button with a handler: protected void btn_Click(object sender, EventArgs e) { ScriptManager.RegisterStartupScript(Updater, this.GetType(), "Hash Update", "UpdateServerData('" + avalue + "');", true); } and a javascript function: function UpdateServerData(val) { pare...
Charles
2

votes
1

answer

sql trigger perform update on update

I am trying to write an sql trigger that will update another table whenever an update is executed. This is actually used to replace replication (replication exists on our production environment but not on dev environment because it causes problems on dev). I've written following trigger to achieve t...
laureysruben
4

votes
2

answer

Sql server after update vs for update?

Im trying to understand whats the difference between after update and for update triggers? I know that istead of triggers can just override my current action. But I dont see any difference between after update and for update
Royi Namir
3

votes
0

answer

Nuget update did not update csproj file

When I update a Nuget package, it seems that my csproj file did not update properly. In this case, I'm updating NLog from 2.1.0.0 to 3.2.0.0, but after updating the package and building the solution, I'm still getting this in my csproj file: False ..\packages\NLog.3.2.0.0\lib\net40\NLog.dll The Refe...
Dhinnesh Jeevan
8

votes
4

answer

Update Panel PostBackTrigger, Update Progress not displaying

I have an update panel and update progress with a PostBackTrigger Event. But update progress is not showing when i am clicking on the button. please find the below sample code My code behind HttpResponse Response = System.Web.HttpContext.Current.Response; Response.ClearHeaders(); Response.AppendHe...
Bhuvan
3

votes
1

answer

Update join vs Update with sub query

I have 2 tables : Table A ID int, Name varchar, Address varchar Table B ID int, Name varchar, Address varchar, Col1... ... Col100 I want to update A.Name with B.Name based on both table's ID. UPDATE A SET A.NAME = B.NAME FROM A JOIN (SELECT ID, Name from B) AS B ON A.ID = B.ID UPDATE A SET A...
EagerToLearn
1

votes
1

answer

Update SqlCommand- Does not update in Database

this doesn't update in my database table. Have I over-looked something? The values are in the textboxes fine. No errors show, weird. using (SqlConnection connection = new SqlConnection(@"Data Source = UKMAN1NB10038\SQLEXPRESS; Initial Catalog = TheVets; Integrated Security = True")) { SqlCommand...
elszeus