RowValidationErrorDescription
This property sets or returns an ErrorDescription for a row validation.
Syntax
RowValidationErrorDescription (RowIndex as Long) as String
Parameter | Description |
---|---|
RowIndex | Zero-based index of row |
Sample Code
Private Sub MyTableField_ValidateRow(pTable as SCBCdrPROJLib.SCBCdrTable, pWorkdoc as SCBCdrPROJLib.SCBCdrWorkdoc, ByVal Row as Long, pValid as Boolean)
'check if quantity * single price = total price
Dim quantity as long
Dim s_price as double, t_price as double
'all cells must already have a valid format
quantity = CLng(pTable.CellText("Quantity", Row))
s_price = CLng(pTable.CellText("Single Price", Row))
t_price = CLng(pTable.CellText("Total Price", Row))
if quantity*s_price = t_price then
pValid = TRUE
else
pValid = FALSE
pTable.RowValidationErrorDescription(Row) = "Invalid quantity or amounts"
end if
End Sub