[Link]jinz01 wrote: ↑Sun Nov 06, 2022 12:22 pmNot familiar with implementing scripts can anyone kindly explain the step by step how to do this please? I have DB browser (SQLite) installed and made some small changes, Vill, item amount etc.variante wrote: ↑Fri May 01, 2020 7:26 amThis SQL script modifies all mastery amounts to 9999, across all companies. Has been working so far.Code: Select all
update companyProperty set cpValue = 9999 where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Thanks in advance!
don't forget write change after executed