Re: Fwd: newbie create new table

[Michael C. Starkie]

Last try, sorry I am having a problem posting XML


tdk 2.1 on linux:
   
I managed to get the newapp working.��I even changed the name of the table to PROJECT 
and primary key to PROJECT_ID and got that working.

I've added the following table, called TASK, to my sql schema:

  database

  table name="PROJECT"
    column name="PROJECT_ID" required="true" autoIncrement="true" primaryKey="true" 
type="INTEGER"
    column name="TITLE" size="255" type="VARCHAR"
    column name="DESCRIPTION" size="255" type="VARCHAR"
  table


  table name="TASK"
    column name="TASK_ID" required="true" autoIncrement="true" primaryKey="true" 
type="INTEGER"
    column name="PROJECT_ID" required="true" type="INTEGER"
    column name="DESCRIPTION" size="255" type="VARCHAR"
    column name="START_DATE" type="TIMESTAMP"
    column name="END_DATE" required="false" type="TIMESTAMP"
    column name="STATUS_ID" type="INTEGER"
    column name="IMPLEMENTER" size="50" type="VARCHAR"


    foreign-key foreignTable="PROJECT"
        reference local="PROJECT_ID" foreign="PROJECT_ID"
    foreign-key
  table
database


What are the basic things I need to know to build a working front-end for this using 
the tdk?

thanks
Mike