Re: Howto update specifc field
Ok, tanks. [], Francisco Bruno Analista de Sistemas OFM Tecnologia & Informação - "Faça as coisas o mais simples que você puder, porém não as mais simples." Albert Einstein - Original Message - From: "Armin Waibel" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 2:04 PM Subject: Re: Howto update specifc field yep, Charles is right. Will be supported in OJB 1.1. Should we backport this feature to OJB 1.0.x? But this will change the PB interface (new method PB#update(Object obj, String[] fields)) and some other internal pluggable interfaces (new methods). regards, Armin Charles Anthony wrote: Hi Francisco, Sorry no-one replied last time. The simple answer is that this currently not possible in OJB. Cheers, Charles. -Original Message- From: Francisco Bruno [mailto:[EMAIL PROTECTED] Sent: 07 October 2004 13:03 To: OJB User List Subject: Howto update specifc field All, How can I do "update statement" updates changed columns only? Ex: TABLE A ( IDNUMBER, DESC VARCHAR, CAT VARCHAR) I need update only CAT field, but the code generate for p6spy is: UPDATE A SETDESC = '', CAT= 'P' WHERE ID = 1 [], Francisco Bruno Analista de Sistemas OFM Tecnologia & Informação -- --- "Faça as coisas o mais simples que você puder, porém não as mais simples." Albert Einstein - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ___ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Howto update specifc field
yep, Charles is right. Will be supported in OJB 1.1. Should we backport this feature to OJB 1.0.x? But this will change the PB interface (new method PB#update(Object obj, String[] fields)) and some other internal pluggable interfaces (new methods). regards, Armin Charles Anthony wrote: Hi Francisco, Sorry no-one replied last time. The simple answer is that this currently not possible in OJB. Cheers, Charles. -Original Message- From: Francisco Bruno [mailto:[EMAIL PROTECTED] Sent: 07 October 2004 13:03 To: OJB User List Subject: Howto update specifc field All, How can I do "update statement" updates changed columns only? Ex: TABLE A ( IDNUMBER, DESC VARCHAR, CAT VARCHAR) I need update only CAT field, but the code generate for p6spy is: UPDATE A SETDESC = '', CAT= 'P' WHERE ID = 1 [], Francisco Bruno Analista de Sistemas OFM Tecnologia & Informação -- --- "Faça as coisas o mais simples que você puder, porém não as mais simples." Albert Einstein - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ___ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer - 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]
RE: Howto update specifc field
Hi Francisco, Sorry no-one replied last time. The simple answer is that this currently not possible in OJB. Cheers, Charles. > -Original Message- > From: Francisco Bruno [mailto:[EMAIL PROTECTED] > Sent: 07 October 2004 13:03 > To: OJB User List > Subject: Howto update specifc field > > > All, > How can I do "update statement" updates changed columns only? > Ex: TABLE A ( >IDNUMBER, >DESC VARCHAR, >CAT VARCHAR) > > I need update only CAT field, but the code generate for p6spy is: > UPDATE A > SETDESC = '', > CAT= 'P' > WHERE ID = 1 > > [], > Francisco Bruno > Analista de Sistemas > OFM Tecnologia & Informação > -- > --- > "Faça as coisas o mais simples que você puder, porém não as > mais simples." > Albert Einstein > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ___ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Howto update specifc field
All, How can I do "update statement" updates changed columns only? Ex: TABLE A ( IDNUMBER, DESC VARCHAR, CAT VARCHAR) I need update only CAT field, but the code generate for p6spy is: UPDATE A SETDESC = '', CAT= 'P' WHERE ID = 1 [], Francisco Bruno Analista de Sistemas OFM Tecnologia & Informação - "Faça as coisas o mais simples que você puder, porém não as mais simples." Albert Einstein - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Howto update specifc field
All, How can I do "update statement" updates changed columns only? Ex: TABLE A ( IDNUMBER, DESC VARCHAR, CAT VARCHAR) I need update only CAT field, but the code generate for p6spy is: UPDATE A SETDESC = '', CAT= 'P' WHERE ID = 1 [], Francisco Bruno Analista de Sistemas OFM Tecnologia & Informação - "Faça as coisas o mais simples que você puder, porém não as mais simples." Albert Einstein - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]