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
