Search Results

Search found 1110 results on 45 pages for 'constraint'.

Page 5/45 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• INSERT statement conflicted with the FOREIGN KEY constraint

  - by SmartestVEGA

  I am getting the following error. Could you please help me in ? Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sup_Item_Sup_Item_Cat". The conflict occurred in database "dev_bo", table "dbo.Sup_Item_Cat". The statement has been terminated. insert into sup_item…

  Read the article

• I'm looking for a constraint to prevent the insert of an empty string in MySQL

  - by Marga Keuvelaar

  Ok, in this question I learned how to prevent the insert of a NULL value. But, unfortunately, an empty string is being inserted anyway. Apart from preventing this on the PHP side, I'd like to use something like a database constraint to prevent this. Of course a check on the application side is necessary, but I'd like…

  Read the article

• "SQLSTATE[23000]: Integrity constraint violation" in Doctrine

  - by rags

  Hi, i do get an Integrity constraint violation for Doctrine though i really can't see why. Schema.yml User: columns: id: type: integer primary: true autoincrement: true username: type: varchar(64) notnull: true email: type: varchar(128) notnull: true …

  Read the article

• Unique constraint with nullable column

  - by Álvaro G. Vicario

  I have a table that holds nested categories. I want to avoid duplicate names on same-level items (i.e., categories with same parent). I've come with this: CREATE TABLE `category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(100) NOT NULL, `parent_id` int(10) unsigned…

  Read the article

• Grails Unique Constraint for Groups

  - by WaZ

  Hi there, I have the following requirement I have 3 domains namely: class Product { String productName static constraints = { productName(unique:true,blank:false) } class SubType { String subTypeName static…

  Read the article

• LINQ To SQL ignore unique constraint exception and continue

  - by Martin

  I have a single table in a database called Users Users ------ ID (PK, Identity) Username (Unique Index) I have setup a unique index on the Username table to prevent duplicates. I am then enumerating through a collection and creating a new user in the database for each item. What I want to do…

  Read the article

• ASP MVC C#: LINQ Foreign Key Constraint conflicts

  - by wh0emPah

  I'm having a problem with LINQ. I have 2 tables (Parent-child relation) Table1: Events (EventID, Description) Table2: Groups (GroupID, EventID(FK), Description) Now i want to create an Event an and a child. Event e = new Event(); e.Description = "test";…

  Read the article

• Hibernate triggering constraint violations using orphanRemoval

  - by ptomli

  I'm having trouble with a JPA/Hibernate (3.5.3) setup, where I have an entity, an "Account" class, which has a list of child entities, "Contact" instances. I'm trying to be able to add/remove instances of Contact into a List<Contact> property of…

  Read the article

• Rails: Oracle constraint violation

  - by justinbach

  I'm doing maintenance work on a Rails site that I inherited; it's driven by an Oracle database, and I've got access to both development and production installations of the site (each with its own Oracle DB). I'm running into an Oracle error when…

  Read the article

• Namespace constraint with generic class decleration

  - by SomeGuy

  Good afternoon people, I would like to know if (and if so how) it is possible to define a namespace as a constraint parameter in a generic class declaration. What I have is this: namespace MyProject.Models.Entities <-- Contains my classes…

  Read the article

• Temporarily disabling foreign key constraints in SQL Server

  - by Renso

  Originally posted on: http://geekswithblogs.net/renso/archive/2013/06/24/temporarily-disabling-foreign-key-constraints-in-sql-server.aspxGoal: Is to temporarily disable all foreign key constraint and later enable the…

  Read the article

• Generic Type constraint in .net

  - by Jose

  Okay I'm looking for some input, I'm pretty sure this is not currently supported in .NET 3.5 but here goes. I want to require a generic type passed into my class to have a constructor like this: …

  Read the article

• Foreign Key constraint violation when persisting a many-to-one class

  - by tieTYT

  I'm getting an error when trying to persist a many to one entity: Internal Exception: org.postgresql.util.PSQLException: ERROR: insert or update on table "concept" violates foreign key…

  Read the article

• Foreign Key constraint when persisting a many-to-one class

  - by tieTYT

  I'm getting an error when trying to persist a many to one entity: Internal Exception: org.postgresql.util.PSQLException: ERROR: insert or update on table "concept" violates foreign key…

  Read the article

• NHibernate Mapping and Querying Where Tables are Related But No Foreign Key Constraint

  - by IanT8

  I'm fairly new to NHibernate, and I need to ask a couple of questions relating to a very frequent scenario. The following simplified example illustrates the problem. I have two tables…

  Read the article

• Jboss 5.1.0: java.lang.LinkageError: loader constraint violation for class javax.sql.DataSource

  - by lawrencexu

  have read quite a lot about this error, the reason is 1) more than one jar containing this class have been include into the classpath, 2)include the jar twice or more, but in my case,…

  Read the article

• Android SQLiteConstraintException: error code 19: constraint failed

  - by Tom D

  I've seen other questions about this exception, but all of them seem to be resolved with the solution that a row with the primary key specified already exists. This doesn't seem to be…

  Read the article

• Entity Framework Adding new record with foreign key constraint

  - by Brono The Vibrator

  In an effort to learn the entity framework I have created two tables in a one to many relationship. The one table (Author) has the following fields - AuthorID, FirstName, LastName. …

  Read the article

• Can't submit new object to WCF DataService because of Primary Key constraint

  - by Rob

  I've got a SQL database that uses Guid's for PK's and upon insert, it generates a NewId(). I have an EF data context setup pointing to that database with the primary keys setup with…

  Read the article

• mysql unique-constraint

  - by Cypher

  I have two tables -- Variables (id, name) and Variable_Entries (id, var_id, value). I want each variable to have a unique set of entries. If I make the value entry unique then a…

  Read the article

• Embedded Prolog Interpreter/Compiler for Java

  - by Sami

  I'm working on an application in Java, that needs to do some complex logic rule deductions as part of its functionality. I'd like to code my logic deductions in Prolog or some…

  Read the article

• Unique Constraint Nhibernate.

  - by Will

  I have a object with a Nhibernate mapping that has a surrogate ID and a natual ID. Since of cource the natural ID is uniquely constrained a insert query will fail if the…

  Read the article

• Rails uniqueness constraint and matching db unique index for null column

  - by Dave

  I have the following in my migration file def self.up create_table :payment_agreements do |t| t.boolean :automatic, :default => true, :null => false…

  Read the article

• Elegantly handling constraint violations in EJB/JPA environment?

  - by hallidave

  I'm working with EJB and JPA on a Glassfish v3 app server. I have an Entity class where I'm forcing one of the fields to be unique with a @Column annotation. @Entity…

  Read the article

• Constraint Satisfaction Problem

  - by Carl Smotricz

  I'm struggling my way through Artificial Intelligence: A Modern Approach in order to alleviate my natural stupidity. In trying to solve some of the exercises, I've…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >