Hi, It is postgresql with serial (autoupdate/autoincrement key) option. For example: CREATE TABLE OS ( ID_os SERIAL NOT NULL CHECK (ID_os > 0), Major_type VARCHAR(20) NOT NULL, Sub_type VARCHAR(20) NULL, Minor_type VARCHAR(20) NULL, Maintanance_level VARCHAR(6) NULL, PRIMARY KEY(ID_os) );
Michal Dne sobota 13 květen 2006 14:36 James, Steven napsal(a): > Depend son the database but if it is an auto key just use the select key > tag. Have a look at the documentation on page 15. > > http://cvs.apache.org/dist/ibatis/ibatis.java/docs/iBATIS-SqlMaps-2.pdf > > > ________________________________ > > From: CIJOML [mailto:[EMAIL PROTECTED] > Sent: Sat 13/05/2006 13:32 > To: [email protected] > Subject: how to get ID from relation table? > > > > Hello, > > I am new to iBatis and I need fill in value into table with foreign key. > How can I get ID from relation table filled before this table? Does ibatis > return this value for me? > > For example: > Table person with personId, firstName, surName > Table Address with addressId, personId (foreign key), streetName, etc > > Now I am able to insert/udpdate/delete rows in person table, but need also > fill in relation table. > > Thanks a lot > > Michal > > > > > This e-mail and any attachment is for authorised use by the intended > recipient(s) only. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be copied, > disclosed to, retained or used by, any other party. If you are not an > intended recipient then please promptly delete this e-mail and any > attachment and all copies and inform the sender. Thank you.
