RE: why doesn't this create table work?

> > 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/