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 (
>        ID    NUMBER,
>        DESC VARCHAR,
>        CAT   VARCHAR)
> 
> I need update only CAT field, but the code generate for p6spy is:
> UPDATE A
> SET        DESC = 'XXXXXXXXXXXX',
>              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]

Reply via email to