I am having trouble with both navigation systems under 2.0.
Under datalist, I am able to insert a form that does not have anything entered in it, but in the database it is set to not be allowed as null. In previous versions I believe the user would be notified to enter something in that field. I can not remember having to configure dbforms to not allow this. Is that necessary now? For instance, even though my "name" field is a key, my forms are entering data into the database with no information for "name". How is it doing that??? By using""????? In fact, none of the fields below should be allowed to be blank.
<table name="FC_Lessons"
defaultVisibleFields="name,number" >
<field name="name" fieldType="varchar" size="100" isKey="true"/>
<field name="translation" fieldType="varchar" size="100"/>
<field name="choice_1" fieldType="varchar" size="100"/>
...some removed...
<field name="choice_2" fieldType="varchar" size="100"/>
<field name="tier" fieldType="varchar" size="100"/>
<field name="course" fieldType="varchar" size="100"/>
<field name="number" fieldType="smallint" size="6" isKey="true" autoInc="true"/>
<interceptor
className = "com.koyuru.dbi.appli.addnewlesson"
/>
<!-- add "granted-privileges" element for security constraints --></table> Here is the create statment for my table:
CREATE TABLE `FC_Lessons` ( `name` varchar(100) NOT NULL default '', `translation` varchar(100) NOT NULL default '', `choice_1` varchar(100) NOT NULL default '', `choice_2` varchar(100) NOT NULL default '', ... `tier` varchar(100) NOT NULL default '', `course` varchar(100) NOT NULL default '', `number` int(6) NOT NULL auto_increment, PRIMARY KEY (`name`,`number`) ) TYPE=MyISAM;
UNDER CLASSIC:
the same form is returning a null error EVEN WHEN ALL REQUIRED FIELDS are included.
I verified that by looking at all the fields in the log like: PRE_INSERT: field=name col=3 value=23 type=2 to see there was a value there
ERROR-[27.01.2004 15:05:35]-[Thread-5]-[org.dbforms.servlets.Controller.process(Controller.java:232)]-::process - SQLException:
java.sql.SQLException
at org.dbforms.event.classic.InsertEvent.processEvent(InsertEvent.java:241)
at org.dbforms.servlets.Controller.process(Controller.java:228)
...
at java.lang.Thread.run(Thread.java:534)
2314958 [Thread-5] ERROR org.dbforms.servlets.Controller - ::process - SQLException:
java.sql.SQLException
at org.dbforms.event.classic.InsertEvent.processEvent(InsertEvent.java:241)
at org.dbforms.servlets.Controller.process(Controller.java:228)
--
Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
