AnsweredAssumed Answered

SQL - Update License Maintenance Cost

Question asked by Morgado on Jul 12, 2019
Latest reply on Jul 12, 2019 by Morgado

Hello Snowers,

 

Could you point me to the correct SQL table where the License Maintenance costs are stored? Also the maintenance dates.

Can't find it in "tblLicense".

 

This other table that I am possible missing follows the same rules? I mean, we can update the column based on LicenseID?

 

To update some fields in bulk I am using the following code:

 

update tblLicense Set MaintenanceAccordingToAgreement = 1 where LicenseID = 32347

 

Thanks a lot,

Morgado.

Outcomes