Hi,
Why my SELECT INTO does'nt work? Just a oversight?
SELECT (Customer.CNO,'1', 'Luxus') INTO RESERVATION FROM Customer,
RESERVATION WHERE Customer.Guid='10AOPGH'
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-5016 POS(23) Missing delimiter: ).
SELECT ((Customer.CNO),'1', 'Luxus') INTO RESERVATION FROM Customer,
RESERVATION WHERE Customer.Guid='10AOPGH'
The tables are created as followed:
CREATE TABLE "DBA"."RESERVATION"
(
"RNO" Fixed (4,0) NOT NULL DEFAULT SERIAL (1),
"CNO" Fixed (12,0),
"HNO" Fixed (4,0),
"ROOMTYPE" Char (6) ASCII,
"ARRIVAL" Date,
"DEPARTURE" Date,
PRIMARY KEY ("RNO"),
FOREIGN KEY "CUSTOMER_RESERVATION" ("CNO") REFERENCES
"DBA"."CUSTOMER" ("CNO") ON DELETE CASCADE
)
CREATE TABLE "DBA"."CUSTOMER"
(
"CNO" Fixed (12,0) NOT NULL DEFAULT SERIAL (1),
"GUID" Char (20) ASCII NOT NULL,
UNIQUE(GUID),
"TITLE" Char (5) ASCII,
"NAME" Char (10) ASCII NOT NULL,
"FIRSTNAME" Char (7) ASCII,
"ZIP" Char (5) ASCII,
"CITY" Char (12) ASCII NOT NULL,
PRIMARY KEY ("CNO"),
CONSTRAINT "ZIP" CHECK "SUBSTR(ZIP,1,1)" BETWEEN '0' AND '9'
AND
"SUBSTR(ZIP,2,1)" BETWEEN '0' AND '9' AND
"SUBSTR(ZIP,3,1)" BETWEEN '0' AND '9' AND
"SUBSTR(ZIP,4,1)" BETWEEN '0' AND '9' AND
"SUBSTR(ZIP,5,1)" BETWEEN '0' AND '9'
)
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
