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]>
