UtilCodeMasterAddValue - cDbUpdateFunctionLibrary
Adds a new value to either of the CodeMast or CodeType tables.
Type: Function
Parameters: Boolean bCodeType, String sTypeValue, String sValue2, String sValue3
Parameter |
Description |
bCodeType |
If True; adds the value to the CodeType table. False; to add a value to the CodeMast table. |
sTypeValue |
Either the value to be added to the CodeType table if bCodeType = True. Else the value will be used to find the correct CodeMast record. |
sValue2 |
If bCodeType = True; the CodeType Description value. Else it is the CodeMast Type value. |
sValue3 |
If bCodeType = True; the CodeType Comment value. Else it is the CodeMast Code value. |
Syntax
Function UtilCodeMasterAddValue Boolean bCodeType String sTypeValue String sValue2 String sValue3
Call: |
Get UtilCodeMasterAddValue False "SHIPPING" "Fedex" "Federal Express" 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 UtilCodeMasterAddValue True "SHIPPING" "Shipping Methods" "Shipping Codes- used in..." to bOK
End_Procedure