> I have the following table definition in my dbforms-config.xml > configuration file that I generated through DEVGUI. > <field name="ADD_TMSTMP" fieldType="timestamp(6)" > size="11"/> > <field name="UPD_TMSTMP" fieldType="timestamp(6)" > size="11"/>
> I tried to define fieldType="timestamp", did not do anything. > Still I get the message in the "ADD_TMSTMP" and "UPD_TMSTMP" fields: > > *** error - fieldtype timestamp(6) is currently not > supported. please send an e-mail to jdbforms- > [EMAIL PROTECTED] *** > OK, just make sure you defined both ADD_TMSTMP" and "UPD_TMSTMP" to be fieldType="timestamp" and that the file is saved. Obvious I know and _only_ mentioned in case you were rushed and anyway I ask because I have a field defined st datetime -- but if I change dbforms-config to show timestamp, the my pages are generated fine. In otherwords, devgui is making the pages based on the config file not what is in your database (although of course it generated the config from the db but if we change it, it should work for the xsl sheets). If it really is the case that it refused to generate your pages completely then you should just simply: 1) use the pages that you generated, replacing the error with <db:textField styleClass="clsInputStyle" size="19" fieldName="ADD_TMSTM"/> </td> and <db:textField styleClass="clsInputStyle" size="19" fieldName="UPD_TMSTMP"/> </td> 2) use fieldType="timestamp(6)" in dbforms-config.xml For example, MySQL does not support fieldType="text" so it gets automatically rewritten to be fieldType="char" size="65535" then I can generate the pages. Finally I change it back to fieldType="text" in dbforms-config.xml and it seems to run fine when I do actual insertion and updates. Actually I just tested it and have not used it that way extensively but think it should be just fine. -- Shawn <[EMAIL PROTECTED]> ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
