|
FUNCTION BindVariable(src$, col$, var$) |
|
FUNCTION BindVariable(src$, col$, var$, tmpCtl) |
|
FUNCTION CheckMainTable() |
Basic check that OpenMainTable did not fail and cFH is not zero.
This is a workaround for an issue where the EXIT errOBJECT is ignored in pvxcom.
|
| Returns |
[bool] True if the open channel can be validated, otherwise false. |
|
|
FUNCTION Clear() |
|
FUNCTION Find() |
|
FUNCTION Find(key$) |
|
FUNCTION FindById(hexKey$) |
Accepts a hex encoded key, converts it to ASCII and calls _OBJ'Find(key$) with the converted ASCII value.
|
| Parameter | Description |
|---|
| hexKey$ |
[input,string] Hex encoded key value. |
|
| Returns |
[bool] Success if the key was found, otherwise failure. |
|
|
FUNCTION GetChildHandle(src$) |
|
FUNCTION GetChildKeyReference$(src$) |
|
FUNCTION GetColumns$(src$) |
|
FUNCTION GetDataSources$() |
|
FUNCTION GetDataSourcesAddl$() |
|
FUNCTION GetJson$(columns$) |
|
FUNCTION GetJson$() |
Returns a JSON representation of the current record (requires the key/record to be set).
|
| Parameter | Description |
|---|
| columns$ |
[input, string] Optional comma separated list of column names for the current object. Default is all columns for the current object. |
|
| Returns |
[string] JSON formatted string containing the data if successfull or an error if not. |
|
|
FUNCTION GetKey$() |
|
FUNCTION GetKey$(fromIndex$) |
|
FUNCTION GetKeyColumns$() |
|
FUNCTION GetKeyPadded$() |
|
FUNCTION GetPartialRecord(record$, iol$) |
|
FUNCTION GetRecord(record$, iol$) |
|
FUNCTION GetRecordCount(src$) |
|
FUNCTION GetRecordEx(record$, iol$) |
Extended version of GetRecord that prepends the returned record and iolist with:
Id$ - The hex value of the current key.
FormattedCode$ - The result of EVS("cCodeFormat$", ERR=*NEXT)
FormattedName$ - The result of EVS("cNameFormat$", ERR=*NEXT)
|
|
FUNCTION GetResultSets(descColumn$, keyColumn$, dropBoxLoad$, dropBoxTranslate$, filter$, begin$, end$) |
|
FUNCTION GetResultSets(descColumn$, keyColumn$, dropBoxLoad$, dropBoxTranslate$, filter$, begin$, end$, alternateIndex$) |
|
FUNCTION GetResultSets(descColumn$, keyColumn$, dropBoxLoad$, dropBoxTranslate$, filter$, begin$, end$, alternateIndex$, distinctOnly) |
|
FUNCTION GetTable$(src$) |
|
FUNCTION GetTablePath$(src$) |
|
FUNCTION GetValue(col$, val$) |
|
FUNCTION GetValue(col$, val) |
|
FUNCTION GetValues(columns$, data$) |
Alternate method to GetPartialRecord(), but can pass in a comma-separated list of column names, instead of a compiled Providex IOList.
|
| Parameter | Description |
|---|
| columns$ |
[input/output, string] comma separated list of field names for the current object, these will be compiled into an IOList and the data returned. If thie list sent in does not have $ on the string variables these will be converted and sent back in this argument. |
| data$ |
[output, string] SEP (hex 8A), separated list of data that was requested. |
|
| Returns |
[boolean] Success - if data was returned from the list of fields given. Failure - if IOList could not be compiled due to a bad list of fields. |
|
|
FUNCTION IsValid() |
|
FUNCTION IsValid(key$) |
|
FUNCTION IsValid(key$, fromCols$, toCols$) |
|
FUNCTION MoveFirst() |
|
FUNCTION MoveLast() |
|
FUNCTION MoveNext() |
|
FUNCTION MovePrevious() |
|
FUNCTION ReadAdditional() |
|
FUNCTION ReadAdditional(src$) |
|
FUNCTION SetBrowseFilter(browseFilter$) |
|
FUNCTION SetBrowseIndex(newBrowseIndex$, newIndex$) |
|
FUNCTION SetCacheMode(cacheMode$) |
|
FUNCTION SetIndex(newIndex$) |
|
FUNCTION SetKeyValue(col$, val$) |
|
FUNCTION SetParentColumns() |
|
FUNCTION SetParentColumns(fromCols$, toCols$) |
|
FUNCTION SetParentHandle(parentTable$, parentHandle, src$, srcMap$, dstMap$) |
|
FUNCTION SetUIHandle(uIHandle) |
|
FUNCTION LOCAL PERFORM ClearEditRcd() |
|
FUNCTION LOCAL FormatJson$(columns$) |
Local function to format the column values, dates, strings, numbers, for the current record into JSON format.
|
| Parameter | Description |
|---|
| columns$ |
[input, string] Comma separated list of column names for the current object to return data for. |
|
| Returns |
[string] JSON formatted string containing the data if successfull or an error if not. |
|
|
FUNCTION LOCAL GetAddlDataSources() |
|
FUNCTION LOCAL GetDateColumns$(columns$) |
|
FUNCTION LOCAL InitChildCollection(childId$, className$, keyReference$, index$, fil$) |
|
FUNCTION LOCAL InitChildCollection(childId$, className$, keyReference$, index$, fil$, srcMap$, dstMap$) |
|
FUNCTION LOCAL MoveFirstLast(direction) |
|
FUNCTION LOCAL MoveNextPrevious(direction) |
|
FUNCTION LOCAL OpenMainTable() |
Open main table for service / business object
|
| Returns |
[boolean] Success - if open is successful. Failure - if open fails |
|
|
FUNCTION LOCAL ParseKeyDef(newIndex$) |
|
FUNCTION LOCAL ParseKeyDef(newIndex$, mainTblFH) |
|
FUNCTION LOCAL PrepareKeyDef(tblFH) |
|
FUNCTION LOCAL ReadRec(key$) |
|
FUNCTION LOCAL ResolveColumnList$(columns$) |
Resolves whether individual columns, in a list if they do not include a $ for the string name (ie CustomerName vs CustomerName$), thus can put string names without the $ in a list of fields and they can be verified here and changed if the field is in the iolist of cFH, otherwise it will remain unchanged.
|
| Parameter | Description |
|---|
| columns$ |
[input, string] Comma separated list of variable names, the string names, that are columns in the main table do not have to include the '$' |
|
| Returns |
On Success: returns a comma separated list of uppercase variable names, converting the string names that came in to include the $ |
|
|
FUNCTION LOCAL SetControls() |
|
FUNCTION LOCAL SetCurrentKey(key$) |
|
FUNCTION LOCAL UseKeyColl(method$) |
