could any body help me - SQL Server Forums

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

could any body help me

Author

Topic

ayoood
Starting Member

3 Posts

Posted - 2009-01-07 : 09:08:42

i made this programe when i compile it ii get this massage(Illegal GET command)(object FlightDetails does not exis) so could any body plz fig out what the wrong in my pograme ????

CREATE TABLE FlightDetails(

FirstName Varchar2(20) NOT NULL,
LastName Varchar2(20) NOT NULL,
Date Number(20) NOT NULL,
Gate Number(20),
Seat varchar2(20),
From-to varchar2(20),
FlightNumber varchar2(20),
class Varchar2(20),
DepartureTime Number(20),
ArriveTime Number(20),
PRIMARY KEY (FirstName,LastName,Date));

CREATE TABLE CustomerDescription(

FirstName varchar2(20) NOT NULL,
LastName varchar2(20) NOT NULL,
Email varchar2(20) NOT NULL,
Age Number(5),
PhoneNumber Number(20),
AdditionalMeal varchar2(20),
City varchar2(20),
Address varchar2(50),
PRIMARY KEY (FirstName,LastName,Email));

CREATE TABLE Payment(

FirstName varchar2(20) NOT NULL,
LastName varchar2(20) NOT NULL,
Time Number(20) NOT NULL,
Email varchar2(20) NOT NULL,
PaymentId Number(20),
PaymentAmount Number(20),
ExpiredDate Number(20),
PRIMARY KEY(FirstName,LastName,Time,Email));

CREATE TABLE Booking (

FirstName varchar2(20) NOT NULL,
LastName varchar2(20) NOT NULL,
Date DATE NOT NULL,
Time Number(20) NOT NULL,
Code varchar2(50),
Status Number(20),
PRIMARY KEY(FirstName,LastName,Date,time));

CREATE TABLE Ticket (

FirstName varchar2(20) NOT NULL,
LastName varchar2(20) NOT NULL,
Date DATE NOT NULL,
TicketCode varchar2(20),
TicketDescription varchar2(20),
PRIMARY KEY (FirstName,LastName,Date));

INSERT INTO FlightDetails VALUES ('Isa','Ahmed','01-01-2009',3,'2A','Bahrain-to-London','2A03','First Class','14:30','23:30');
INSERT INTO FlightDetails VALUES ('Nor','Ali','07-07-2009',10,'13C','New york-to-Birmingham','3A33','Business Class','11:00','14:45');
INSERT INTO FlightDetails VALUES ('Salman','Isa','20-12-2009',21,'20E','UAE-to-Paris','1A27','Economy Class','00:00','17:25');
INSERT INTO FlightDetails VALUES ('Nasser','Hassan','03-03-2009',13,'7D','Oman-to-Doha','2B13','Business Class','10:00','12:00');

INSERT INTO CustomerDescription VALUES ('Isa','Ahmed','Isa@hotmail.com',20,+97336469391,'Yes','HamadTOwn','Home 1266');
INSERT INTO CustomerDescription VALUES ('Nor','Ali','Nor@gmail.com',30,+97339220164,'No','IsaTOwn','Home 9231');
INSERT INTO CustomerDescription VALUES ('Salman','Isa','Smd@yahoo.com',45,+9731776268,'Yes','Manama','Home 3214');
INSERT INTO CustomerDescription VALUES ('Nasser','Hassan','Na32@hotmail.com',34,+97339856412,'Yes','Sitrah','Home 4321');

INSERT INTO Payment VALUES('Isa','Ahmed','13:00','Isa@hotmail.com',0013,'$620','31-12-2008');
INSERT INTO Payment VALUES('Nor','Ali','17:00','Nor@gmail.com',0241,'$200','06-07-2009');
INSERT INTO Payment VALUES('Salman','Isa','23:45','Smd@yahoo.com',0233,'$634','19-12-2009');
INSERT INTO Payment VALUES('Nasser','Hassan','19:50','Na32@hotmail.com',0121,'$150','02-03-2009');

INSERT INTO Booking VALUES ('Isa','Ahmed','01-01-2009','13:00','J73215A','Confirm');
INSERT INTO Booking VALUES ('Nor','Ali','07-07-2009','17:00','AB74321','Confirm');
INSERT INTO Booking VALUES ('Salman','Isa','20-12-2009','23:45','ZW8453J','NotConfirm');
INSERT INTO Booking VALUES ('Nasser','Hassan','03-03-2009','19:50','4213608','NotConfirm');

INSERT INTO Ticket VALUES ('Isa','Ahmed','01-01-2009','76A21','Confirm');
INSERT INTO Ticket VALUES ('Nor','Ali','07-07-2009','23B21','Confirm');
INSERT INTO Ticket VALUES ('Salman','Isa','20-12-2009','AZ217','NotConfirm');
INSERT INTO Ticket VALUES ('Nasser','Hassan','03-03-2009','427B8','NotConfirm');

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-07 : 09:10:11

Nothing here issues the "illegal GET command".

E 12°55'05.63"
N 56°04'39.26"

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2009-01-07 : 09:11:37

i think perhaps you should post your query in an oracle forum, rather than sql server

Em

ayoood
Starting Member

3 Posts

Posted - 2009-01-07 : 09:22:55

i did it in notepad than i save it abs.sql than i open the oracle and open the notepad file than i i wrote this code to display the table is right (desc FlightDetails or select * from FlightDetails)

so could any one plz try my programe if is it work or not

thank you for your help

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2009-01-07 : 09:23:38

again.... this is not an oracle forum

Em

ayoood
Starting Member

3 Posts

Posted - 2009-01-07 : 09:34:54

so what should i do????

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2009-01-07 : 09:36:42

try an oracle forum maybe??

http://www.dbforums.com/

Em