Actually, the case I specified is the most suitable to the "header / detail rows" structure, for example, of orders.
I have an order number, and the rows need to have a progressive number... (like, row 1 of order 192203, and so on...) If I want to have such handling of rows, I'll have to redefine the save() method of rows, unless there is a way of getting Torque handling the multiple key / autoincrement issue! Anyway, your answer is absolutely right: for all other tables only one ID is necessary to identify the row. Giulio Vezzelli Infolog S.r.l. Via Alfieri, 28 Modena - 41100 Telefono : +39-059-822446 Sito web : http://www.infolog.it E-mail : [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Scott Eade [mailto:[EMAIL PROTECTED] > Inviato: luned� 19 gennaio 2004 1.47 > A: Apache Torque Users List > Oggetto: Re: Problems with 2 columns primary key and autoincrement > > Glossing over the potential problem in torque (I think this > has been covered before - check the mailing list archives) > why do you need ID to be part of the primary key since > ID_ATTIVITA fits the definition of a primary key - i.e. it > uniquely identifies the rows. Your ID column is a simple foreign key. > > Scott > __ > > Scott Eade > Backstage Technologies Pty. Ltd. > http://www.backstagetech.com.au > > > Giulio Vezzelli wrote: > > >Greetings, > > > > I think I found some kind of odd behaviour in Torque, regarding > >this particular case: > > > >My table ATTIVITA is structured this way : > > > > ID primary key (refers to a foreign table), > >required > > ID_ATTIVITA primary key, autoincrement, required > > other columns > > > > > >With both "native" and "IDBroker" id methods, Torque fails to save() > >this object, because the autoincrement field is "null". > > > >If the primary key is one column only (the autoincrement > one), the save > >goes fine. > > > > > >I think Torque has some problem handling multicolumn primary keys w/ > >autoincrement fields... > > > >Anyone had some experience in similar cases ? > > > > > >Giulio Vezzelli > >Infolog S.r.l. > >Via Alfieri, 28 > >Modena - 41100 > >Telefono : +39-059-822446 > >Sito web : http://www.infolog.it <http://www.infolog.it/> E-mail : > >[EMAIL PROTECTED] > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
