SELECT INTO

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