[Vtigercrm-developers] update vtiger

[Alan Lord]

Do you mean you want to simply copy the data from the description column 
to the comment column?

This is a really simple query if that's what you need:

> UPDATE vtiger_inventoryproductrel
> SET comment = description
> WHERE id = id
> AND comment = '' OR comment IS NULL;

(Not tested but should work - Will only copy data into the comment 
column if it is empty or NULL)

HTH

Al



On 04/08/14 13:56, micker wrote:
> ok i will do this
> if you add some time could you help me about this ..
> http://vtiger-crm.2324883.n4.nabble.com/VM-develloper-description-in-invoice-td10998i20.html
> i ty to find a sql request to copy all description in comment for
> vtiger_inventoryproductrel table ...
> thanks for all
>
>
>
> --
> View this message in context: http://vtiger-crm.2324883.n4.nabble.com/update-vtiger-tp11717p11724.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/
>