NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
munchkinbizkit
Posted via mailing list.
|
 Posted: Thu Mar 18, 2010 11:23 am Post subject: MySQL Database Desktop Application Project |
 |
|
Hi Ishwar,
I face the same problem with sergio and found this thread. I have check that
my table are already in InnoDB engine. What more cause the problem?
Thanks.
ISHWAR CHAND JINDAL wrote:
| Quote: |
Hi Sergio,
Engines other than Innodb does not support foreign key in MySql tables. I
also encountered same problem.
You make tables in INNODB engine and problem will be resolved.
You can create table in Innodb by adding engine= innodb in the script, as
shown hereunder for table CUSTOMERS:
CREATE TABLE CUSTOMERS (
ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
FIRST_NAME VARCHAR(20),
LAST_NAME VARCHAR(30),
ADDRESS VARCHAR(30),
CITY VARCHAR(30),
STATE_ VARCHAR(30),
ZIP VARCHAR(15),
COUNTRY_ID INTEGER,
PHONE VARCHAR(15),
EMAIL_ADDRESS VARCHAR(50)
)ENGINE= INNODB ;
Regards
IC Jindal
----- Original Message ----
From: JulioSergio <address-removed>
To: address-removed
Sent: Friday, 15 August, 2008 6:17:13 PM
Subject: [nbusers] MySQL Database Desktop Application Project
Following the example "Creating a Custom Java Desktop Database
Application"
given in http://www.netbeans.org/kb/61/java/gui-db-custom.html, I was
trying
to create such MySQL Database Desktop Application that requires to show
the
"Detail Area" as a Table. However, after defining the Mastertable in the
"New Desktop Application" wizard, it responds with an "Options" page that
has the required "Table" option disabled! as it is shown in the image
below
http://www.nabble.com/file/p19006879/IDE_DB.jpg
Do you know if this has to do with MySQL version or with something I
forgot
to configure in my Netbeans 6.1?
Thanks,
Sergio.
--
View this message in context:
http://www.nabble.com/MySQL-Database-Desktop-Application-Project-tp19006879p19006879.html
Sent from the Netbeans - Users mailing list archive at Nabble.com.
From Chandigarh to Chennai - find friends all over India. Go to
http://in.promos.yahoo.com/groups/citygroups/
|
--
View this message in context: http://old.nabble.com/MySQL-Database-Desktop-Application-Project-tp19006879p27941392.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
