create table with text not null
    Erich Geiersberger 
    erichg at mcmm.com
       
    Fri Jun 13 05:16:23 CDT 2008
    
    
  
The following statement:
CREATE TABLE "TEST_T2" (
    "ID" SHORT  NOT NULL INDEXED,
    "Description" TEXT (512) NOT NULL,
    "Point" VARCHAR (12)  NOT NULL);
should create a table with field "description" being defined as not 
containing NULL values, right?.
Is there something wrong with that statement?
Dumping that table results in:
-- Dump for 'TEST_T2' table
----------------------------------------------------
CREATE TABLE "TEST_T2" (
    "ID" SHORT  NOT NULL INDEXED,
    "Description" TEXT (512) ,
    "Point" VARCHAR (12)  NOT NULL);
???
Erich Geiersberger
Media Connect
Augsburg, Germany
    
    
More information about the Valentina
mailing list