[Vtigercrm-developers] lineitems in table vtiger_inventoryproductrel deleted and created in each edit

[Matus Sopko]

Yes, you are right. The "Update" process is done with Delete and Insert 
lineitems  again.
I'm thinking about how to check if Productblock(lineitems) was changed.
Maybe this control is more difficult like delete and insert again.

S pozdravom / Best regards / Mit freundlichen Grüßen
Ing. Matus SOPKO
IT-Solutions4You s.r.o.
Kancelária: Slovenská 69
Sídlo: Frantiskanske nam.5

080 01 Prešov
SLOVAKIA
Tel./ Fax +421/ 51/ 7732370
email:sopko at its4you.sk
http://www.its4you.sk
skype: matussopko

Dňa 11. 3. 2022 o 3:28 Rubén A. Estrada Orozco napísal(a):
> Today I noticed that every time you edit an inventory module record, 
> its corresponding line items in the vtiger_inventoryproductrel are 
> deleted and created again even if you don't change anything about line 
> items. You can see that, because the "lineitem_id" in the 
> vtiger_inventoryproductrel table changes and the previous ones get 
> deleted.
>
> For example, if you edit the subject of a quote, the line items are 
> deleted and created again. Isn't that sort of inefficient? Or can it 
> be considered a negligible waste of resources?
>
> Saludos
>
> Rubén
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220311/fa1048f3/attachment.html>