UtilCodeMasterChangeValue - cDbUpdateFunctionLibrary
To change a value in either of the CodeMast or CodeType tables.
Type: Function
Parameters: Boolean bCodeType, String sTypeValue, String sValue2, String sValue3
Parameter |
Description |
sFromValue |
Changes values in CodeType and CodeMast. It first changes the type value in CodeType and then spins through all CodeMast records to change all related records. |
sToValue |
The new value to change to |
Syntax
Function UtilCodeMasterChangeValue String sFromValue String sToValue
Call: |
Get UtilCodeMasterChangeValue "SHIPPING" "FREIGHT" to bOK |
Description
Use it to create or add a new value to the validation tables; CodeType and CodeMast.
Example
Procedure OnUpdate
Boolean bOK
Get UtilCodeMasterChangeValue "SHIPPING" "FREIGHT" to bOK
End_Procedure