I used this mysql example below to test AppWizard. I had my own files and had
a problem getting the links  to files working, so I thought I would create
these files in my mysql db. I use SQlYog software to create the mysql db.
I run AppWizard on these two files and I get only the species file form
displayed but no way to display the zoo .
Is there something in mysql that I am missing?


===============================================================================
mysql> CREATE TABLE species (id TINYINT NOT NULL AUTO_INCREMENT, name
VARCHAR(50) NOT NULL, PRIMARY KEY(id)) ENGINE=INNODB;
Query OK, 0 rows affected (0.11 sec)

mysql> INSERT INTO species VALUES (1, 'orangutan'), (2, 'elephant'), (3,
'hippopotamus'), (4, 'yak');
Query OK, 4 rows affected (0.06 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> CREATE TABLE zoo (id INT(4) NOT NULL, name VARCHAR(50) NOT NULL,
FK_species TINYINT(4) NOT NULL, INDEX (FK_species), FOREIGN KEY (FK_species)
REFERENCES species (id), PRIMARY KEY(id)) ENGINE=INNODB;


mysql> ALTER TABLE zoo ADD FOREIGN KEY (FK_species) REFERENCES species (id);

-- 
View this message in context: 
http://old.nabble.com/AppWizard-creates-2-file-from-mysql-but-display-only-one-form----tp26621354p26621354.html
Sent from the dabo-users mailing list archive at Nabble.com.

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]

Reply via email to