Problem inserting a row on a table.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Problem inserting a row on a table.

Author

Topic

POLO_SPORT09@HOTMAIL.COM
Starting Member

3 Posts

Posted - 2009-03-24 : 17:41:40

My tables...

DROP TABLE bokning;
DROP TABLE kund;
DROP TABLE produkt;
DROP TABLE UTBETALNING;
DROP TABLE PERSONAL;
DROP TABLE LONEKAT;

CREATE Table lonekat(
lonekat_id int IDENTITY(1,1) NOT NULL,
beskrivning char(20) NOT NULL,
manadslon numeric(10,2) NOT NULL,
provisionsandel decimal(3,2) NOT NULL,
CONSTRAINT pk_lonekat_id primary key (lonekat_id));
-----------------------------------------------------------------
CREATE TABLE personal (
personal_id int IDENTITY(1,1) PRIMARY KEY,
chef_id int NULL REFERENCES personal(personal_id),
lonekat_id int NOT NULL REFERENCES lonekat(lonekat_id),
fornamn char(20) NOT NULL,
efternamn char(20) NOT NULL,
titel char(10) NOT NULL);
-----------------------------------------------------------------
CREATE Table utbetalning(
utbetalning_id int IDENTITY(1,1) NOT NULL,
personal_id int Constraint c_personal_id References personal(personal_id),
grundlon numeric(10,2) NOT NULL,
bonus numeric(10,2) NOT NULL,
totallon numeric(10,2) NOT NULL,
loneperiod char(6) NOT NULL,
CONSTRAINT pk_utbetalning_id primary key (utbetalning_id));
-----------------------------------------------------------------

CREATE Table produkt(
produkt_id int IDENTITY(1,1) NOT NULL,
namn char(20) NOT NULL,
provision numeric(10,2) NOT NULL,
CONSTRAINT pk_produkt_id primary key (produkt_id));

-----------------------------------------------------------------
CREATE Table kund(
kund_id int IDENTITY(1,1) NOT NULL,
kundansvarig_id int Constraint c_kund_ansvar_id References personal(personal_id),
fornamn char(20) NOT NULL,
efternamn char(20) NOT NULL,
telefonnr char(15) NOT NULL,
mobiltelefon char(15) NOT NULL,
ring_ej_flagga bit NOT NULL,
CONSTRAINT pk_kund_id primary key (kund_id));
-----------------------------------------------------------------
CREATE Table bokning(
bokning_id int IDENTITY(1,1) NOT NULL,
produkt_id int Constraint c_prod_id References produkt(produkt_id),
saljare int Constraint c_personal_id_seljar_id References personal(personal_id),
kund_id int NOT NULL Constraint c_kund_id References kund(kund_id),
tidpunkt date NOT NULL,
CONSTRAINT pk_bokning_id primary key (bokning_id));

MY INSERTS:

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Ingångslön',10000,0.10)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Junior säljare',15000,0.40)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Säljare',20000,0.60)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Senior säljare',25000,0.80)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Grupp ledare',30000,1)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('Chefslön',45000,0.00)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)
VALUES ('VD lön',100000,0.00)

I am trying to insert on personal with this values:

pers_id chef_id lonekategori fornamn efternamn Titel
1 34 1 Johan Forsberg Saljare

I dont realy know how to insert it.

POLO_SPORT09@HOTMAIL.COM
Starting Member

3 Posts

Posted - 2009-03-24 : 17:42:46

VALUES:
1 34 1 Johan Forsberg Saljare

POLO_SPORT09@HOTMAIL.COM
Starting Member

3 Posts

Posted - 2009-03-24 : 18:06:51

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)
VALUES (34,1,'Johan','Forsberg','Säljare');

Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK__personal__chef_i__2645B050". The conflict occurred in database "Gangster", table "dbo.personal", column 'personal_id'.
The statement has been terminated.

If i make this instead it works..

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)
VALUES (NULL,1,'Johan','Forsberg','Säljare');

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-25 : 13:17:55

have you linked checf_id to personal_id via foreign key? then you need to make sure the value inserted for chef_id already exists in personal_id column

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources