I remember seeing this question a few times and I also had some problems with this. I think the documentation is lacking a bit here and I will add to it myself once the wiki is in place....
I solved this by using TIMESTAMP, and CLOB types...... Matt ----- Original Message ----- From: "michael shek sia lim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 11:50 PM Subject: Sql entry > Hi, > > I am trying to create a database via the TDK schema. Below is my .xml file > content: > > <table name="INVOICE"> > <column name="ID" required="true" autoIncrement="true" > primaryKey="true" type="INTEGER"/> > <column name="INVOICENO" size="10" type="INTEGER"/> > <column name="CUSTOMERREF" size="50" type="INTEGER"/> > <column name="DATE" type="DATETIME"/> > <column name="CONTACT" size="20" type="VARCHAR"/> > <column name="PAYMENTTERM" size="20" type="VARCHAR"/> > <column name="SUBTOTAL" type="FLOAT"/> > <column name="GST" type="FLOAT"/> > <column name="TOTAL" type="FLOAT"/> > <column name="COMMENT" type="TEXT"/> > </table> > > I realize that TDK does not like "TEXT" and "DATETIME" as input for type. > These are standard SQL entries and I believe they are quite common in > usage, I would appreciate if anyone could show me how to write an > acceptable .xml file. > > cheers > michael > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
