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), Loose the , above > ); > 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!- > > ********************************************************************** The contents of this e-mail are confidential to the ordinary user(S) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. **********************************************************************