***DO NOT USE WITHOUT HELP DESK ASSISTANCE***
There are 2 ways to mass-update a DeMaSy Option:
1st Method through the execution of a Query (via DeMaSy Utilities – Sql Query):
Access: Update [Options] Set [Value] = 'NewValue' where [Variable] = 'Variable'
Sql Server: Update [Options] Set [Value] = 'NewValue' where [Variable] = 'Variable' and [DBId] = @DBId@
2nd Method through a special function (via DeMaSy Utilities – Sql Query):
INI:VariableName=Value
How to verify the value of an Option in Multiple Databases (via DeMaSy Utilities – Sql Query):
Access (Select the Databases): Select [DBId], [Variable], [Value] from [Options] where [Variable] = 'VariableName'
Sql Query (Select the Databases): Select [DBId], [Variable], [Value] from [Options] where [Variable] = 'VariableName' and [DBId] = @DBId@
Remark: This will only update existing Options. If the Option does not exist (if it was never specified), You must go through DeMaSy to set it once.