Hi Is there a way to reduce unnecessary/empty fields in SQL inserts and SQL updates? For example, I have a single hibernate entity class mapped to a table that has 10 columns. The populating of data is actually done in two phases. When the user submit a request, I will insert the request information into the table with the hibernate ent...
I click update in eclipse and i get error, its because i updated eclipse more than once. Is there any way to fix eclipse and have ability to use update? An error occurred while collecting items to be installed No repository found containing: org.eclipse.jem/osgi.bundle/2.0.202.v200810282000 No repository found containing: org.eclip...
We have 2 tables called TableToUpdate and Dates. We need to update TableToUpdate's EndTimeKey column by looking from other table Dates. We run sql below to do this, but it takes to long to finish. Table TableToUpdate has 6M records. Table Dates has 5000 records. How can we optimize it ? Thanks for replies ! update TableToUpdate set E...
For my Android application there is a timer that measures how much time has passed. Ever 100 milliseconds I update my TextView with some text like "Score: 10 Time: 100.10 seconds". But, I find the TextView only updates the first few times. The application is still very responsive, but the label will not update. I tried to call .invalidat...
I have a select query which does some text manipulation to essentially reformat a field so that I can look it up in another table: If my first table if I have a field like "J1/2" it looks up the ID of a record in a different table with J1 and J2 in the appropriate fields. This all works well. Now I want to update the original table so...
Hi All I have a Java GUI that has a number of text fields, the values of which are populated from static variable in another class. I am interested to know what the best way is to make it so that when the variable is changed in another class, the update is instantly reflected on the GUI. If any one could make a suggestion on an effici...
Hey, Recently I've set up the ClearCase Remote Client (an eclipse plugin) to work through SSL, so instead of an http URL, it follows an https URL. However, this breaks the access to the Update Site, returning an error that the site has a "Premature End of File" error. My question(s) are this... Is there a problem with Eclipse accessi...
I'm experiencing this problem today on many different servers. System.UnauthorizedAccessException: Access to the temp directory is denied. The servers were not touched recently. The only thing that comes in my mind is a windows update breaking something.. Any idea? This happens when trying to access a webservice from an asp.net page...
Hi, I have the following issue. We have a user table, every user has an unique email and username. We try to do this within our code but we want to be sure users are never inserted (or updated) in the database with the same username of email. I've added a BEFORE INSERT Trigger which prevents the insertion of duplicate users. CREATE TRI...
Is there a way to update multiple rows with different values for each row using a single SQL query? I have to update one colum in many rows with different data. Using individual update queries for each row seems excessive so if it's possible I would like to consolidate this process into a single SQL statement or at least reduce the numbe...
I want to make a installation which can be both new installation and update installation. When it was used as an update installation, I want some files to be updated regardless the version and modified datetime. And some files would never be updated. What I tried: Set the "REINSTALLMODE" to "amus". And set the "Never overwrite" property...
i hv to update a field in a table. i m using following querries. help me which one is right? update table1 set col1=<value>,col2=<value>.... from table1 t,table2 s where t.id=s.num and s.code='abc'; or update table1 set col1=<value>,col2=<value>.... where table1.id=table2.num and table2.code='abc'; which one is right?or both ar...
I have a (mysql) database table with the following columns: NAME | String (Unique) STATUS | int UPDATE_COUNT | int (Unique) I want the value of Max(UPDATE_COUNT) to reflect the cumulative number of updates performed on rows in the table. For example, starting with an empty table: Insert - (Name=John, Status=0) - // update count on...
Imagine the following sql query: UPDATE MYTABLE SET COL2 = (SELECT COL2 + 1 FROM (SELECT MAX(COL2) FROM MYTABLE) AS X) WHERE ID IN (1,2,3,4,5) Assume that before the update is executed MAX(COL2) is 1. My intention is that for the update where ID=1 COL2 is updated to 'max(COL2) + 1' (i.e. 2), and that for subsequent updates 'MAX(COL...
Hi! I'm writing a subroutine for DBI updates, and are having some trouble figuring out how to add placeholder and stuff... I have this: sub row_update { my $table = shift; my %updates = @_; my $placeholders = ... $dbh->do("UPDATE $table SET (foo) WHERE (bar)") etc... } Any ideas? I just want a simple update function where...
I have a table I'm using as a work queue. Essentially, it consists of a primary key, a piece of data, and a status flag (processed/unprocessed). I have multiple processes trying to grab the next unprocessed row, so I need to make sure that they observe proper lock and update semantics to avoid race condition nastiness. To that end, I'...
Hello , I want to know the best way about when we want to bind a dataTable generated based on a searchResult to a gridview ( Just for now we want to show one record ) , now how can we add edit-delete capability for this record shown in the gridview ? How many ways do we have for this , I know some but I want to reshape my knowledge , ...
In the past I have had problems upgrading from release to release of Eclipse. I was wondering how the Eclipse users on StackOverflow dealt with upgrading from release to release of Eclipse. Is using a Distro the solution? Staying on a past release point until you are forced forward, a good idea? Lately I have just reloaded from scrat...
I just moved my svn repository to a new server. Previously I was accessing my repository via svn://oldserver/yyy/zzz Now I want to access it via https://newserver:8443/svn/yyy/zzz I used switch --relocate to repoint my source tree and this seemed to work well. When I try to update the source I use: svn.exe update zzz --username myuser...
Is it possible to update an entry in Lotus Notes via email just like posterous? If it is possible, how can i do that? Thanks. ...