And you must save the changed config file before using the transformations.
Timestamp(6) is not a regular sql type - so we will not support it! The equivalent type is timestamp! Cheers, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Aroushanian, Goar > Gesendet: Freitag, 10. September 2004 15:23 > An: Shawn > Cc: dbf > Betreff: RE: [dbforms] TIMESTAMP problem (Oracle9i) > > Hi Shawn, > > I have the following table definition in my > dbforms-config.xml configuration file that I generated through DEVGUI. > > <table name="TEST"> > <field name="TEST_ID" fieldType="varchar2" > size="10" isKey="true"/> > <field name="TEST_CD" fieldType="varchar2" > size="1" isKey="true"/> > <field name="ADD_ID" fieldType="varchar2" > size="30"/> > <field name="ADD_TMSTMP" fieldType="timestamp(6)" > size="11"/> > <field name="UPD_ID" fieldType="varchar2" > size="30"/> > <field name="UPD_TMSTMP" fieldType="timestamp(6)" > size="11"/> > <!-- add "granted-privileges" element for > security constraints --> > </table> > > 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] *** > > I want to mention that timestamp(6) is a new datatype > available in Oracle9i (not supported in Oracle 8i). > The format includes year, month, day, hour, minute, and seconds (ex: > 9/10/2004 12:36:07.000 PM). > > Does this information help? Let me know if you need any details. > > Thanks for your help! > > > > -----Original Message----- > From: Shawn [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 9:33 PM > To: Aroushanian, Goar > Cc: dbf > Subject: RE: [dbforms] TIMESTAMP problem > > > On Thu, 2004-09-09 at 22:29, Aroushanian, Goar wrote: > > Tried generating the dbforms-config.xml with the "Try to write > standard > > names for > > an unknown field type..." option on, but it didn't' help. > > > > Still I get: > > *** error - fieldtype timestamp(6) is currently not > supported. please > > send an e-mail to [EMAIL PROTECTED] *** > > I don' use Oracle, so um > > what if you handwrite in timestamp instead of timestamp(6)? > [or is that > what you have and the error message is appending the (6)] > > timestamp works fine for me, so I think you should be able to use it > too. > > sorry shoulda mentioned it before. > > depending on what the exact format of timestamp(6) is, you may want to > see the UsersGuide > > Chapter on Internationalization and > i18n Support > > > ______________________________________________________________ > __________ > section -- Setting the Pattern Attribute > -- > 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 > ------------------------------------------------------- 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
