<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Yes, you are right. The "Update" process is done with Delete and
Insert lineitems again.<br>
I'm thinking about how to check if Productblock(lineitems) was
changed.<br>
Maybe this control is more difficult like delete and insert again.<br>
<pre class="moz-signature" cols="72">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: <a class="moz-txt-link-abbreviated" href="mailto:sopko@its4you.sk">sopko@its4you.sk</a>
<a class="moz-txt-link-freetext" href="http://www.its4you.sk">http://www.its4you.sk</a>
skype: matussopko</pre>
<div class="moz-cite-prefix">Dňa 11. 3. 2022 o 3:28 Rubén A. Estrada
Orozco napísal(a):<br>
</div>
<blockquote type="cite"
cite="mid:CAKjsHQ_k2q+DeoDaNajPpSeMih0XH5heuyaysTZjRt3N-xq_dw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">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.
<div><br>
</div>
<div>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?
<div><br>
</div>
<div>
<div>
<div>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">Saludos
<div><br>
</div>
<div>Rubén</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>