MoneyWorks Manual
ValidateCell (windowRef, listRef, rowNum, columnNum, cellValueString)
A script handler you can implement to override standard MoneyWorks behaviour.
Automatically called: When a cell in an editable list (such as the detail line entry list) is about to be exitted. Row and column numbers are zero-based. Return 0 if the cell value is not acceptable: this will keep the focus in the cell. IMPORTANT: If you do this you should provide an explanation to the user via an alert or coachtip. Users will be very unhappy if they don't know why they can't exit a cell!
Use for: Validating the content of a cell.
Return value: Boolean
Specific Naming: You can and should implement a ValidateCell handler that is specific to the particular window ID, itemID and column name of interest. e.g. ValidateCell:<WindowId>:ListItemID:ColumnName.
See Also:
AddListLine: Add a row to an editable list
DeleteListLine: Delete a row from an editable list
EnterCell: A cell in an editable list has just gained focus
ExchangeListRows: Swap rows in an editable list
ExitedCell: A cell in an editable list has just lost focus
GetActiveListColumn: Get the column number of an edit list that has keyboard focus
GetActiveListRow: Get the row number of an edit list that has keyboard focus
GetListField: Get the text of an editable list field
GetListHandle: Get list handle from window handle and list ident
GetListLineCount: Get number of rows in a list
GetListName: Selected tab name for Transaction entry details list
MergeOrderLines: Merge order lines (opposite of SplitOrderLines)
SetListField: Set the text of an editable list field
SortListByColumn: Sort an editable list by a column
SplitOrderLine: Duplicate a line item on an order, splitting the order qty (for serial entry)