Hi,
I would like to know if the following SQL statement is ok.
I keep getting an erro: InstantDB.sql java.lang.NumberFormatException: null
e CREATE TABLE oes_order_status_code ( <--- runs ok
code char(1) primary key,
descp varchar );
;e CREATE TABLE oes_order_status_code ( <-- breaks
; code char(1) not null primary key,
; descp varchar not null );
TIA.
Hugo Ferreira.
////////////// Exception ////////////////
InstantDB.sql CREATE TABLE oes_order_status_code ( code char(1) primary
key
, descp char not null )
InstantDB.sql java.lang.NumberFormatException: null
InstantDB.sql java.lang.NumberFormatException: null
java.sql.SQLException: null
at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
at
org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java, Co
mpiled Code)
at
org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.ja
va:103)
at org.enhydra.instantdb.SampleThread.run(ScriptTool.java, Compiled
Code
)
at java.lang.Thread.run(Thread.java:479)
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|