Hi SapDB Users,
I've created a table with the following script:
CREATE TABLE customer
(
cno FIXED(12,0) DEFAULT SERIAL PRIMARY KEY,
title CHAR(5),
name CHAR(10) NOT NULL,
firstname CHAR(7),
zip CHAR(5) CONSTRAINT zip like '(0-9)(0-9)(0-9)(0-9)(0-9)',
city CHAR(12) NOT NULL
)
Now I want to add a few datas into the table:
insert into customer (title, name, firstname, zip, city) values
('Prof.','Mayer', 'Sepp', '12345', 'Erbsenstadt')
By executing this statement I just get the following error message:
General error;300 POS(1) Integrity violation:ZIP,CUSTOMER,DBA.
insert into customer (title, name, firstname, zip, city) values
('Prof.','Mayer', 'Sepp', '12345', 'Erbsenstadt')
My question: which is the right format for ZIP?
Thanx, Chris
------------------------------------
www.schlechte-doku-hasser.de
--
+++ GMX - die erste Adresse f�r Mail, Message, More! +++
Getestet von Stiftung Warentest: GMX FreeMail (GUT), GMX ProMail (GUT)
(Heft 9/03 - 23 e-mail-Tarife: 6 gut, 12 befriedigend, 5 ausreichend)
Jetzt selbst kostenlos testen: http://www.gmx.net
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
