A database has the option for up to 100 constant values – these are values used in calculated fields to affect value and date fields. For example, if you have selling prices at (say) 15% greater than cost you may wish to have your selling price field as a calculation which is ‘COST-PRICE x 115 / 100’, however, you can’t enter the values ‘115’ and ‘100’ but you can reference constants and this option allows you to set those constants. You may wish to include the option to change these constants in a ProFiler application to (say) see the affect on different margins.
After creating the call for the constants update, specifying which file to update, then no further options are required. Parameter 2 allows you to select a constant data item on the selected file – this restricts the constant items you can update at run-time to just those defined in the item.
Article ID: 1200
Created On: Thu, Jun 28, 2012 at 2:54 PM
Last Updated On: Tue, Jun 20, 2023 at 5:34 PM
Online URL: https://kb.datafile.co.uk/article/c-â€-constants-update-1200.html