Search Results

Search found 17867 results on 715 pages for 'delete row'.

Page 66/715 | < Previous Page | 62 63 64 65 66 67 68 69 70 71 72 73  | Next Page >

• SQL join different tables depending on row information

  - by Xster

  Hi, I think this question hasn't be asked yet. Suppose I have table A with a field that can be either 1 or 2 How do I select such that for each row in table A, if the field is 1, join the select with table B and if the field is 2, join the select with table C?

  Read the article

• Altering constraint delete action

  - by Hobhouse

  I did this: ALTER TABLE `db`.`my_table` ADD CONSTRAINT FOREIGN KEY (`my_second_table_id`) REFERENCES `my_second_table` (`id`); I should have done this: ALTER TABLE `db`.`my_table` ADD CONSTRAINT FOREIGN KEY (`my_second_table_id`) REFERENCES `my_second_table` (`id`) ON DELETE SET NULL; Is it possible to ALTER this, or do I have to drop the constraint and add again?

  Read the article

• Version control: delete branches after merging?

  - by Nathan Long

  When you branch some code, finish working with the branch, and merge it back to the trunk, what do you do with the branch? Delete it from the repository? Keep it for reference? It seems like you would keep it for reference, but I imagine the /branches directory could get pretty cluttered. (If this isn't something people generally agree on, please comment and I'll make it a community wiki.)

  Read the article

• Add a custom row with displaytag

  - by Davoink

  Is there a way of adding a custom row(s) to the top of a displaytag table? There is a way of adding a footer via display:footer. but why no header?

  Read the article

• process killed -- delete output file?

  - by user151841

  I have a bash script that runs on our shared web host. It does a dump of our mysql database and zips up the output file. Sometimes the mysqldump process gets killed, which leaves an incomplete sql file that still gets zipped. How do I get my script to 'notice' the killing and then delete the output file if the killing occurred?

  Read the article

• Multiple row selection in uipickerView

  - by medma

  Hi frends, I have implemented multiple row selection by making uipicker with components and rows = 0, and add uitableview as subview to picker. But now i have a problem that some of the values in the table are checked automatically which creates problem in my application. plz tell me what to do to rectify this. Thanx.

  Read the article

• How to delete an object by id with entity framework

  - by Jeff

  It seems to me that I have to retrieve an object before I delete it with entity framework like below var customer = context.Customers.First(c => c.Id = 1); context.DeleteObject(customer); context.Savechanges(); So I need to hit database twice. Is there a easier way? Thanks

  Read the article

• Django/piston + Silverlight, PUT/DELETE?

  - by Jason Miesionczek

  I am working on a Silverlight project that uses Django on the server using piston for the REST API. I understand that Silverlight doesn't support the PUT and DELETE http verbs. Is there another way i can pass these kinds of commands to piston?

  Read the article

• filter some data(row) in zend view

  - by Behrang

  I have 1.Table:user(userId,userName,userGroup) 2.Model:userModel 3.usercontroller there i a simple code: Controller: class UserController extends Zend_Controller_Action { public function getuser() { $userModel = new userModel(); $this-view-usergroup = $userModel; } } Model: class Model_UserGroupModel extends Zend_Db_Table_Abstract { public function getuser( { $select = $this-select(); return $this-fetchAll($select); } } view: please tell me what code I must insert in view to only have user with specific row like user with group teacher also i use partialoop???

  Read the article

• C# tableadapter add/update/delete

  - by ChrisMuench

  I'm using the table adapter in C# where visual studio generates the code for you. I have inserts and updates working just fine using the following code. However when trying to delete using the .update it gives me the following error. Update requires a valid DeleteCommand when passed DataRow collection with deleted rows. this.workersTableAdapter.Update(this.nursery_dbDataSet_workers.workers);

  Read the article

• How to delete a native image ?

  - by Thomas

  Hi all, I am not able to delete a native image : del c:\windows\assembly\native...\mscorlib\xxxx\mscorlib.ni.dll access refused That works on Windows XP, but not in Seven. Does someone know how can I do ? Thanks

  Read the article

• Keeping a certain row or column in an HTML table fixed

  - by WarDoGG

  I have huge amounts of data populating an HTML <table> having more than 200 rows and 200 columns. However, when i scroll the page horizontally or vertically to view the data, the header columns (like th for instance) go beyond the page. How can i scroll through the table and still keep the top row and leftmost column fixed so that i will always know what data im seeing.

  Read the article

• select, delete & update from multible tables using a single query in mysql

  - by mewis

  for example i use following command to find a record SELECT users.mail FROM users WHERE users.uid = %s if found an match, then i should like to delete this record, and update in the same query an another table. i can solve this with 'joins' ?

  Read the article

• NHibernate : delete error

  - by MadSeb

  Hi, Model: I have a model in which one Installation can contain multiple "Computer Systems". Database: The table Installations has two columns Name and Description. The table ComputerSystems has three columsn Name, Description and InstallationId. Mappings: I have the following mapping for Installation: <?xml version="1.0" encoding="utf-8"?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="myProgram.Core" namespace="myProgram"> <class name="Installation" table="Installations" lazy="true"> <id name="Id" column="Id" type="int"> <generator class="native" /> </id> <property name="Name" column="Name" type="string" not-null="true" /> <property name="Description" column="Description" type="string" /> <bag name="ComputerSystems" inverse="true" lazy="true" cascade="all-delete-orphan"> <key column="InstallationId" /> <one-to-many class="ComputerSystem" /> </bag> </class> </hibernate-mapping> I have the following mapping for ComputerSystem: <?xml version="1.0" encoding="utf-8"?> <id name="Id" column="ID" type="int"> <generator class="native" /> </id> <property name="Name" column="Name" type="string" not-null="true" /> <property name="Description" column="Description" type="string" /> <many-to-one name="Installation" column="InstallationID" cascade="save-update" not-null="true" /> Classes: The Installation class is: public class Installation { public virtual String Description { get; set; } public virtual String Name { get; set; } public virtual IList<ComputerSystem> ComputerSystems { get { if (_computerSystemItems== null) { lock (this) { if (_computerSystemItems== null) _computerSystemItems= new List<ComputerSystem>(); } } return _computerSystemItems; } set { _computerSystemItems= value; } } protected IList<ComputerSystem> _computerSystemItems; public Installation() { Description = ""; Name= ""; } } The ComputerSystem class is: public class ComputerSystem { public virtual String Name { get; set; } public virtual String Description { get; set; } public virtual Installation Installation { get; set; } } The issue is that I get an error when trying to delete an installation that contains a ComputerSystem. The error is: "deleted object would be re-saved by cascade (remove deleted object from associations)". Can anyone help ? Regards, Seb

  Read the article

• Symfony - Delete and reload all database records for each test

  - by Andree

  Hi there, From the Jobeet tutorial provided in Symfony website, I found out that I can load fixtures data each time I run unit test by using this script: Doctrine_Core::loadData(sfConfig::get('sf_test_dir').'/fixtures'); However, I want to delete and reload all records from database each time I run a unit test. Currently, I'm doing this manually (Run symfony doctrine:build --all before each test). Can someone provided me a correct way to do this?

  Read the article

• Delete generated files when original is modified with Apache Ant

  - by Joepie

  I want to delete the generated files (".tmp" and ".bak") in the build directory when the source file (".xml)" is modified with Apache Ant. All files have the same name, but different extentions. I'm not able to create the fileset to do this. Please help me...

  Read the article

• SVN delete file

  - by Josemalive

  Hi, My question is simple, if i delete a file in a trunk of an svn repository, could i get the file if i ask for a previous version or the file was deleted forever? Thanks. Best Regards. Jose

  Read the article

• Selecting one row when working with typed datasets.

  - by Wodzu

  I have a typed dataset in my project. I would like to populate a datatable with only one row instead of all rows. The selected row must be based on the primary key column. I know I could modify the designer code to achive this functionality however if I change the code in the designer I risk that this code will be deleted when I update my datased via designer in the future. So I wanted to alter the SelectCommand not in the designer but just before firing up MyTypedTableAdapter.Fill method. The strange thing is that the designer does not create a SelectCommand! It creates all other commands but not this one. If it would create SelectCommand I could alter it in this way: this.operatorzyTableAdapter.Adapter.SelectCommand.CommandText += " WHERE MyColumn = 1"; It is far from perfection but atleast I would not have to modify the designer's work. unfortunately as I said earlier the SelectCommand is not created. Instead designer creates something like this: [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitCommandCollection() { this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1]; this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "SELECT Ope_OpeID, Ope_Kod, Ope_Haslo, Ope_Imie, Ope_Nazwisko FROM dbo.Operatorzy"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } It doesn't make sense in my opinion. Why to create UpdateCommand, InsertCommand and DeleteCommand but do not create SelectCommand? I could bear with this but this._commandCollection is private so I cannot acces it outside of the class code. I don't know how to get into this collection without changing the designer's code. The idea which I have is to expose the collection via partial class definition. However I want to introduce many typed datasets and I really don't want to create partial class definition for each of them. Please note that I am using .NET 3.5. I've found this article about accessing private properties but it concerns .NET 4.0 Thanks for your time.

  Read the article

• Prevent SQL Server Table operations (INSERT and DELETE) on some tables

  - by stckvrflw

  While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked to the "editing", to be able to work safe. Thanks.

  Read the article

• JTable .. colour of selected row

  - by dimitar

  Hello pip`s, I have a JTable in Java that has a custom dataMOdel and custom renderer. Now when i select some cell it has a dark blue border around it. I want the selected row to be all highlighted in some colour. How to do that?

  Read the article

• Transaction Isolation on select, insert, delete

  - by Bradford

  What could possibly go wrong with the following transaction if executed by concurrent users in the default isolation level of READ COMMITTED? BEGIN TRANSACTION SELECT * FROM t WHERE pid = 10 and r between 40 and 60 -- ... this returns tid = 1, 3, 5 -- ... process returned data ... DELETE FROM t WHERE tid in (1, 3, 5) INSERT INTO t (tid, pid, r) VALUES (77, 10, 35) INSERT INTO t (tid, pid, r) VALUES (78, 10, 37) INSERT INTO t (tid, pid, r) VALUES (79, 11, 39) COMMIT

  Read the article

• Set border on first table row, w/o using a ID or class

  - by Blankman

  I am trying to style a web app that we don't have the source code too. So I drilled down into the DOM, but right now the bottom border is being set on ALL the rows, I need only the first row. #tableID tbody tr td table tbody tr { border-bottom: solid 1px #cccccc; } Is this possible?

  Read the article

• winforms - datagridview row height doesn't resize when defaultcellstyle is set to wrapmode

  - by BhejaFry

  Hi folks, i have a datagrid that displays long text on couple columns. I have set the cells defaultcellstyle to wrap. This works but now the row height doesn't change to compensate for the wrapped text & the text is getting cut-off. What am i missing? TIA

  Read the article

• Subrows into a row in GridView using WPF & C#

  - by toni

  hi! In my gridview I need to aggregate subrows into each row, something like in p2p emule/amule application where you can do double click to each file you are downloading and then under it you can see the parts of the file from where you are downloading. Is it possible in WPF? Thanks.

  Read the article

• SQL DROP TABLE foreign key constraint

  - by Polly Hollanger

  If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first? GO IF OBJECT_ID('dbo.[Course]','U') IS NOT NULL DROP TABLE dbo.[Course] GO IF OBJECT_ID('dbo.[Student]','U') IS NOT NULL DROP TABLE dbo.[Student]

  Read the article

< Previous Page | 62 63 64 65 66 67 68 69 70 71 72 73  | Next Page >