update test set FieldOne = '1'; --- Luís Santos <[EMAIL PROTECTED]> wrote: > sqlite> CREATE TABLE test ( > ...> id INT NOT NULL, > ...> FieldOne TEXT NOT NULL, > ...> FieldTwo TEXT, > ...> "1" TEXT > ...> ); > sqlite> insert into test (id, FieldOne ) values (1, "4"); > > sqlite> update test set FieldOne ="1"; > SQL error: test.FieldOne may not be NULL
____________________________________________________________________________________ Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. http://tv.yahoo.com/collections/222 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------