RE: why doesn't this create table work?

Would the remaining five subscribers who have not yet replied to this post please do so and put me out of my misery? TIA. From: LUIS CARLOS DIAZ OTERO <luiscarlosdiazo@yahoo.com> > > > > database development; > > >create table nightpost > > > ( > > > tkamx_site char(2), > > > tkamx_project char(10), > > > tkamx_calldte char (10), > > > tkamx_startupl char(6), > > > tkamx_stopupl char(6), > > > tkamx_uplbytes char(9), > > > tkamx_origrec char(8), > > > tkamx_uplrec char(8), > > > tkamx_ftpstart char(6), > > > tkamx_ftpend char(6), > > > tkamx_poststart char(6), > > > tkamx_postend char(6), > > > tkamx_stlstart char(6), > > > tkamx_stlend char(6), > > > tkamx_postallst char(6), > > > tkamx_postallst char(6), > > > tkamx_comment char(50), <---->Remove this comma, and the SQL statement will work > > > ); > > >grant all on nightpost to "public"; > > >create unique index tkamx_date on nightpost > > >(tkamx_calldte,tkamx_site,tkamx_project) with> > disallow NULL; > > > > > >___________________________________________ > > > > > >home/tony > isql < nightpost.sql > > > > > >Database selected. > > > > > > > > > 201: A syntax error has occurred. > > >Error in line 20> > >Near character position 2 > > > > > > 206: The specified table (nightpost) is not in> > the database. > > > > > > 111: ISAM error: no record found. > > >Error in line 1> > >Near character position 24 > > > > > > 201: A syntax error has occurred. > > >Error in line 2> > >Near character position 42 > > > > > >/home/tony > > > > > > >________________________________________ > > > > > >-Tony!- > > > > > > > >________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com > > >===== >______________________________________ >Luis Carlos D'az Otero >ALCANOS DE COLOMBIA S.A. E.S.P >Carrera 9 # 7-25 >Neiva (Huila (Colombia)) > >__________________________________________________ >Do You Yahoo!? >Kick off your party with Yahoo! Invites. >http://invites.yahoo.com/ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Obnoxio The Clown wrote: > > Would the remaining five subscribers who have not yet replied to this post > please do so and put me out of my misery? > > TIA. You are a very naughty man sometimes Mr. Clown. But since you ask here's a nice "me 2" post for you: > From: LUIS CARLOS DIAZ OTERO <luiscarlosdiazo@yahoo.com> > > > > > > database development; > > > >create table nightpost > > > > ( > > > > tkamx_site char(2), > > > > tkamx_project char(10), > > > > tkamx_calldte char (10), > > > > tkamx_startupl char(6), > > > > tkamx_stopupl char(6), > > > > tkamx_uplbytes char(9), > > > > tkamx_origrec char(8), > > > > tkamx_uplrec char(8), > > > > tkamx_ftpstart char(6), > > > > tkamx_ftpend char(6), > > > > tkamx_poststart char(6), > > > > tkamx_postend char(6), > > > > tkamx_stlstart char(6), > > > > tkamx_stlend char(6), > > > > tkamx_postallst char(6), > > > > tkamx_postallst char(6), > > > > tkamx_comment char(50), <----> >Remove this comma, and the SQL statement will work > > > > ); > > > >grant all on nightpost to "public"; > > > >create unique index tkamx_date on nightpost > > > >(tkamx_calldte,tkamx_site,tkamx_project) with> > > disallow NULL; > > > > Like Obnoxio said, lose the extra comma from the end. Like you said, lose the cut-n-paste error. You can make individual columns disallow nulls with the keywords NOT NULL (e.g. tkamx_site char(2) NOT NULL,). You might think about adding a SERIAL column to the table if you think you might want to absolutely, positively identify a single row some day. GRANT ALL ON nightpost TO PUBLIC is OK if this is just a playtable. But if it's a real table then tell the public to keep its paws off your data and go into more detail with the GRANT statements. -- In article <3978CFF0.CB1B2BB2@my-deja.com.guacamole>, stacia123@my-deja.com.guacamole said: > Goldfish don't fit through the air nozzle of most erotic dolls.