My code goes like this:
//database connection
statement.executeUpdate(" CREATE TABLE if not exists h041 ( h041001
integer PRIMARY KEY , h041002 varchar(10)," +
"h041003 date, h041004
integer, h041005 numeric(20,2), h041006
numeric(20,2), h041007 boolean, h041008 varchar(15), h041009
timestamp , h041010 varchar(250)," +
"h041011 date, h041012 text,
h041013 smallint DEFAULT 0,
h041014 smallint, h041015 boolean DEFAULT false, h041022
varchar(30), h041023 boolean DEFAULT true," +
"h041024 timestamp, h041025
varchar(60), h041016 integer,
h041017 integer,h041018 integer, h041019 integer, h041020 integer,
h041021 integer," +
"h041026 varchar(10), h041027
date, h041028 numeric(20,2),
h041029 integer DEFAULT -1," +
"h041030 integer DEFAULT -1 )
");
statement.executeUpdate("
insert into h041 ( h041003 , h041013 , h041004 , h041014 , h041002 ,
h041005 ,h041012 , h041010 , h041016 ,h041017 ) values
( '01/01/2008','insurance','test test test test test test test test
test ','cash','1234','100' , 'test' , 'test' , '00001' , '00ADJ' )");
it is giving me the error
java.sql.SQLException: h041.h041001 may not be NULL
at org.sqlite.DB.execute(DB.java:275)
at org.sqlite.DB.executeUpdate(DB.java:281)
at org.sqlite.Stmt.executeUpdate(Stmt.java:103)
But when i insert through command line it's not throwing me an error
For your information i am using v052 (native)
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
