Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
- Subject: Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
- From: Dev WO <email@hidden>
- Date: Wed, 16 Nov 2005 17:32:22 +0100
Still doesn't work even after restart...
On 16-Nov-05, at 11:09 AM, Dev WO wrote:
I filled the column/table name.
To make sure, I tried on a previous EOModel that worked, and same
error, so bugreport tonight;)
But now I feel stupid, because I don't know how to generate my
table in MySQL:( I was able to add the first primary key, but it
seems I cannot add the second one (index)...
Could someone copy/paste something here so I have a sample of the
command line I have to enter to generate the join table?
Oops I read your post wrong, generate SQL, not generate Java. Got it.
Anyway, I tested generate SQL on a simple model and that worked too.
For generating the join table, this is what EOModeler would generate:
CREATE TABLE r_join (c_id INT NOT NULL, c_id1 INT NOT NULL);
ALTER TABLE r_join ADD PRIMARY KEY (c_id, c_id1);
Alternately you could use something like CocoaMySQL.
I'm using it, I just can't get the second primary key to be added, so
I'll use the "Custom Query" pane.
I'll try on another machine later today to see if it still not working:(
Thanks David
Xavier
--
;david
--
David LeBer
Codeferous Software
'co-defer-ous' adj. producing or containing code
site: http://www.codeferous.com
blog: http://david.codeferous.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anazys.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden