Re: [sqlite] FW: SQL error: no such column: State

2004-12-03 Thread Kurt Welgehausen
> Executing > sqlite> .schema BillingNumbers shows the column to be there > > CREATE TABLE BillingNumbers(id int default 0 not null, clecID int default 0 > not null, ilecID int default 0 not null, BillingNumber > varchar(20) default " not null, State varchar(20) default " not null, > Resale int def

Re: [sqlite] FW: SQL error: no such column: State

2004-12-03 Thread Guy Hachlili
At 12:51 03/12/2004 -0600, you wrote: When The Table is created in code with the following statements cmd.CommandText = "CREATE TABLE BillingNumbers(id int default 0 not null, " & _ "clecID int default 0 not null, " & _ "ilecID int default 0 not null, " & _ "BillingNumber varchar(20) default "" no

Re: [sqlite] FW: SQL error: no such column: State

2004-12-03 Thread Clay Dowling
Mike Willhite said: > cmd.CommandText = "CREATE TABLE BillingNumbers(id int default not null," > "clecID int default not null, " & _ > "ilecID int default not null, " & _ > "BillingNumber varchar(20) default "" not null, " & _ > "State varchar(20) default "" not null, " & _ > "Resale int defau