Class SY_Selection

Inherits

GL_AccountFormatter, SY_CommonUI, SY_GridHandler, SY_OpenObject

Properties

LOCAL cDefaultOperand$="A"  
LOCAL cMaintenanceOption=1  
LOCAL cSkipPromote  
PROPERTY Category1Desc$   * Read Only *
PROPERTY Category2Desc$   * Read Only *
PROPERTY Category3Desc$   * Read Only *
PROPERTY Category4Desc$   * Read Only *

Methods

FUNCTION BuildSelectDefaults(whereIN$, selectOUT$)  
FUNCTION ChangeOperand(gridctl)  
FUNCTION ChangeValue1(gridctl)  
FUNCTION ChangeValue2(gridctl)  
FUNCTION ClassOnFocusGrid(gridctl)  
FUNCTION ClassOnFocusGridSetKey(gridctl)  
FUNCTION CreateSelectWhere(token$, column$, operand$, value1$, value2$, keyref$, whereclause$, tag$)  
FUNCTION GetWhereClause(table$, whereClause$)  
FUNCTION GetWhereClause(table$, whereClause$, recPrefix$)  
FUNCTION GetWhereClause(table$, whereClause$, recPrefix$, columnName$)  
FUNCTION LoadGrid(gridCtl)  
FUNCTION LoadRow(gridCtl, gridRow)  
FUNCTION OnExitGrid(gridCtl)  
FUNCTION PostLoadGrid(gridCtl)  
FUNCTION ReadSelectDefault()  
FUNCTION ResetALL(gridCtl)  
FUNCTION ReturnReportSelection(selectionField$, returnValue$)  
FUNCTION ReturnReportSelection(selectionField$, returnValue$, index)  
FUNCTION ReturnSetupGrid(gridCtl, whereClause$)  
FUNCTION ReturnSetupTable(tableFH, whereClause$)  
FUNCTION RowMods(gridCtl, RowNo)  
FUNCTION SaveRow(gridCtl, Row)  
FUNCTION SetOperand(gridCtl)  
FUNCTION SetRowState(in.Option, in.Row)  
FUNCTION SetRowState(in.Option, in.Row$)  
FUNCTION LOCAL AddRecPrefix$(whereClause$, recPrefix$)  

Function will replace ~ in where clause specified with record prefix, will not change values in literals

ParameterDescription
[input/output, string] The where clause.
[input, string] record prefix to add to where clause.
Returns [boolean] returns retSUCCESS
FUNCTION LOCAL PERFORM BuildClause()  
FUNCTION LOCAL FindMultiSepChar(testString$, multSepChar$)  

Function will determine if last character of string is a separator character.

ParameterDescription
[input/output, string] Input-string to check for separator, Output-String without the last separator
[input/output, string] Input-default sep character, Output-Default input or separator character found.
Returns [boolean] returns retSUCCESS if separator found, retFAILURE if no ending separator
FUNCTION LOCAL FixDepartment(selecTag$, keyRef$, lineTag$)  
FUNCTION LOCAL FixDivision(selecTag$, keyRef$, lineTag$)  
FUNCTION LOCAL PERFORM FormatValue(tmpValue$)  
FUNCTION LOCAL GetBeginEnd(where$, begin$, end$, whereInd$, chan)  
FUNCTION LOCAL GetBeginEndCol(where$, colBegin$, colEnd$, col$, lengthToPad, whereStripped)  
FUNCTION LOCAL PERFORM GetSelection()  
FUNCTION LOCAL IsUDFReportSelection(udfName$, colInfo)  

Function will return whether or not the UDF is to be included as part of the report selection criteria.

ParameterDescription
udfName$ [input, string] Name of the UDF field to test to see if it should be part of the report selection
colInfo [input, objHandle] Handle to the dictionary object, will test the Notes section of the field definition to see the udf passed in should be part of the report selection
Returns [boolean]
ValueDescription
TRUE if field is to be included in the report selection
FALSE if field is to be exculded in the report selection
FUNCTION LOCAL PERFORM JoinClause()  
FUNCTION LOCAL PfxWhereClause(where$, whrChan, newPfx$, newWhere$)  
FUNCTION LOCAL PostLoad()  
FUNCTION LOCAL PromoteCacheMode()  
FUNCTION LOCAL RefreshSelectionGrid()  

Refresh selection grid to default selections

Returns [numeric] returns retSUCCESS, retWARNING, or retFAILURE
FUNCTION LOCAL PERFORM ResetValue1()  
FUNCTION LOCAL PERFORM ResetValue2()  
FUNCTION LOCAL SaveRowWrite(values$, selectIolist$, tRowKey$)  
FUNCTION LOCAL SearchOutsideQuotes(search$, Source$)  
FUNCTION LOCAL SearchOutsideQuotes(search$, Source$, found$)  
FUNCTION LOCAL SelectionResetRow(gridCtl, Row)  

Reset the selection information for the specified row; the operand will be set to 'All' and the two values will be cleared and updated to the associated memory file

ParameterDescription
[input, controlID] The control ID for the selection grid
[input, number] The row to be reset
Returns [boolean]. retSUCCESS
FUNCTION LOCAL SetAutoComplete(gridCtl)  

Function will set CellAutoCtl property in cells with auto-complete

ParameterDescription
gridCtl [input, numeric] ctl value of grid control
Returns [boolean] returns retSUCCESS
FUNCTION LOCAL SetupForDateSelections()  
FUNCTION LOCAL SubstituteOutsideQuotes(subSource$, old$, new$)  
FUNCTION LOCAL PERFORM SYSResolveSelectToken()  

Properties inherited from: SY_CommonUI

ViewOnly, ScriptsDefined, DocDateWarnDisplayed, DocDateWarnForceOff

Methods inherited from: SY_CommonUI

CallScript(), ClassFormatterDate$(), ClassFormatterTime$(), ClassFormatterUdfYesNo$(), ClassOnfocusDate(), ClassPushCreditRptPush(), ClassPushDeliveryOptionsPush(), ClassPushEmailPush(), ClassPushExecute(), ClassPushExplorerView(), ClassPushHyperlinkPush(), ClassPushMapPush(), ClassPushPkgTrackingPush(), ClassPushURLPush(), ClassValidateDate$(), ClassValidateDocumentDate(), ClassValidateUdfYesNo$(), DropBoxLoad(), FormatNumericTime(), GetControlProperty(), GetDateMasked(), GetDateRaw(), GetFolderName$(), GetPanelName$(), GetScreenName$(), GetValue(), HandleScriptUI(), InvokeChange(), InvokeLookup(), ListBoxLoad(), Process(), SetControlProperty(), SetDocDateWarnOff(), AppendTitleBar(), BT_ListBoxExportToExcel(), BT_SageU(), CheckForScripts(), ClassChangeTelephoneNoUI(), ClassPushDirectoryButton(), DrillDown(), GetListboxIol$(), GetScriptUIGroup$(), InitScriptEngine(), NomadsProcess(), ParseTagField(), SetControlState(), SetKeyState(), ShowDocumentDateWarning(), ShowSageUniversity(), Status()