Class SY_TableConversionCommon

Properties

LOCAL cHistoryIol$="IOLIST VERSION$, CONVERSIONTYPE$, TABLENAME$, CONVERSIONID$, DEVELOPERCODE$, CONVERSIONNOTES$, IGNORERECORD$, DATECREATED$, TIMECREATED$, USERCREATEDKEY$"  
PROPERTY LogObj   * Read Only *

Methods

options {optional} [input, numeric] options to use when opening the file/table; see SY_OpenObject for details

FUNCTION ClearHistoryRecordsToUpdate()  

Clears the list of conversion history records to update.

Returns [numeric]
ValueDescription
retSUCCESS (1)
FUNCTION CloseTableCopy(copyComplete)  

Closes the source and destination channels of an open conversion copy operation.

ParameterDescription
copyComplete [input/output, boolean] Indicates that the conversion completed successfully.
Returns [boolean]
ValueDescription
retSUCCESS (1) - If copyComplete is indicated and the destination table was closed and renamed successfully.
retFAILURE (0) - If an error was encountered.
FUNCTION ConvertRecord(tableName$, key$, srcIOL$, srcRec$, dstIOL$, dstRec$)  

Convert a single record from a given table. The routine will execute the column records for the table on the given record.

ParameterDescription
tableName$ [input, string] table containing the record to be converted
key$ [input, string] key of current record
srcIOL$ [input, string] source I/O List IOL(fhSource)
srcRec$$ [input, string] current record REC(srcIOL$)
dstIOL$ [input, string] destination I/O List IOL(fhDest)
dstRec$ [output, string] converted record REC(dstIOL$)
Returns [numeric]
ValueDescription
retFAILURE (0) - record conversion was not successful
retSUCCESS (1) - record conversion was successful
FUNCTION ConvertTable(version$, developerCode$, tableName$, conversionLogic$)  
FUNCTION ConvertTable(version$, developerCode$, tableName$, conversionLogic$, selectWhereClause$)  

Generic conversion routine used to convert data in a table. The routine will execute column records from the driver table for each record in the given table. The arguments for this method should all be in the conversion driver record for the table. This method will be called by the SY_ConversionDriver object if the conversion logic is a directive token.

ParameterDescription
version$ [input, string] version number, such as 05.00.00.00
developerCode$ [input, string] developer code
tableName$ [input, string] table name
conversionLogic$ [input, string] directive token, such as
selectWhereClause$ {optional} [input, string] where clause used to filter records read from the table
Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - conversion logic was processed without error
FUNCTION CreateTable(tableName$)  
FUNCTION CreateTable(tableName$, path$)  
FUNCTION CreateTable(tableName$, path$, localFile)  
FUNCTION CreateTable(tableName$, path$, localFile, ddfTableName$)  
FUNCTION CreateTable(tableName$, path$, localFile, ddfTableName$, createPVX)  
FUNCTION CreateTable(tableName$, path$, localFile, ddfTableName$, createPVX, applyConstraints)  

Creates or updates the structure of a file or table. Wraps the session method of the same name.

ParameterDescription
tableName$ [input, string] name of file/table to create or update
path$ {optional} [input, string] full path or path constant to indicate location of file/table; if null then the Physical File path in the dictionary is used to indicate if the file/table is created in MAS_SYSTEM or with the company data
localFile {optional} [input, boolean] true indicates the file will be on the client
ddfTableName$ {optional} [input, string] name of the table definition to use, if different than tableName$
createPVX {optional} [input, boolean] true indicates the file will be created in ProvideX even if running in a SQL environment
applyConstraints {optional} [input, boolean] true indicates indexes will be applied to this SQL table
Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - table created normally
FUNCTION CreateTableNewCopy(tableName$, path$)  

Creates a new copy of a file or table and copies the original data then deletes the original.

ParameterDescription
tableName$ [input, string] name of file/table to copy.
path$ [input, string] path constant to indicate location of file/table.
Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - table created normally
FUNCTION DropTable(tableName$)  
FUNCTION DropTable(tableName$, path$)  
FUNCTION DropTable(tableName$, path$, localFile)  
FUNCTION DropTable(tableName$, path$, localFile, ddfTableName$)  
FUNCTION DropTable(tableName$, path$, localFile, ddfTableName$, dropPVX)  

Erases physical Providex file or drops SQL tables from the database. Wraps the session method of the same name.

ParameterDescription
tableName$ [input, string] name of file to erase or table to drop
path$ {optional} [input, string] full path or path constant to indicate location of file/table; if null then the Physical File path in the dictionary is used to indicate if the file/table is located in MAS_SYSTEM or with the company data
localFile {optional} [input, boolean] true indicates the file will be on the client
ddfTableName$ {optional} [input, string] name of the table definition to use to verify file is in the dictionary, if different than tableName$
dropPvx {optional} [input, boolean] true indicates that this is a Providex file; typically used in a SQL environment
Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - table was dropped or did not exist
FUNCTION GetHistoryRecordsToUpdate$()  

Returns a list of conversion history records that will be performed when multiple conversion records are processed.

Returns [string]
ValueDescription
List of $03$-separated history records
FUNCTION OpenTable(tableName$)  
FUNCTION OpenTable(tableName$, path$)  
FUNCTION OpenTable(tableName$, path$, options)  
FUNCTION OpenTable(tableName$, path$, options, localfile)  
FUNCTION OpenTable(tableName$, path$, options, localfile, opt$)  
FUNCTION OpenTable(tableName$, path$, options, localfile, opt$, ddfTableName$)  
FUNCTION OpenTable(tableName$, path$, options, localfile, opt$, ddfTableName$, noLog)  

Opens a file or table for use. Wraps the session method of the same name.

ParameterDescription
tableName$ [input, string] name of file/table to open
path$ {optional} [input, string] full path or path constant to indicate location of file/table; if null then the Physical File path in the dictionary is used to indicate if the file/table is located in MAS_SYSTEM or with the company data
ParameterDescription
localFile {optional} [input, boolean] true indicates the file will be on the client
opt$ {optional} [input, string] SQL environment only; use to provide additional OPT= parameters which will be appended to the "keystruct" string plus any optimizations returned by GetConnectString
ddfTableName$ {optional} [input, string] name of the table definition to use to verify file is in the dictionary, if different than tableName$
noLog {optional} [input, bool] Set this flag to surpress the logging of any failures.
Returns [numeric]
ValueDescription
0 - an error was encountered
non-zero - file channel to table
FUNCTION OpenTableCopy(srcTable$, path$, srcCH, dstCH)  

Opens the source and destination channels in preparation of a conversion copy operation.

ParameterDescription
srcTable$ [input, string] The name of the source table to copy.
path$ [input, string] The path of the source table.
srcCH [output, numeric] The channel for the source table.
dstCH [output, numeric] The channel for the destination table.
Returns [boolean]
ValueDescription
retSUCCESS (1) - If the source and destination channels were opened successfully.
retFAILURE (0) - If an error was encountered.
FUNCTION RemoveData(version$, tableName$, conversionLogic$)  

Common method for removing data from files. This method determines which local method to call to process the driver records. Failures are recorded in the conversion log.

ParameterDescription
version$ [input, string] version number, such as 05.00.00.00
tableName$ [input, string] table name
conversionLogic$ [input, string] directive token, such as
Returns [numeric]
ValueDescription
retFAILURE (0) - an error occurred
retSUCCESS (1) - data was removed
retWARNING (-1) - some or all of the data was not removed
FUNCTION RemoveDctDefinitions(fileList$)  

Removes file definitions from the old SY0DCT.SOA Dictionary

ParameterDescription
fileList$ [input, string] Comma separated list of legacy file names. Ex: "PR.941,PR.BENEFIT,PR.BEN_II,PR.EMPL"
Returns [boolean]
ValueDescription
retFAILURE (0) - an error occurred
retSUCCESS (1) - SY0DCT.SOA Definitions removed or not found
FUNCTION RemoveLegacyFileDefinitions(fileList$, ddFiles$)  
FUNCTION RemoveLegacyFileDefinitions(fileList$)  

Removes file definitions from the Legacy (Roswell) Data Dictionary (SY0DD2.SOA,SY0DD4.SOA,SY0DD5.SOA)

ParameterDescription
fileList$ [input, string] Comma separated list of legacy file names. Ex: "PR0,PR1,PR_01,PR_WC"
ddFiles$ [input, string] {optional} list of DD2 files to process, defaults to all SY0DD2.SOA,SY0DD4.SOA,SY0DD5.SOA
Returns [boolean]
ValueDescription
retFAILURE (0) - an error occurred
retSUCCESS (1) - Legacy File Definitions removed or not found
FUNCTION RemoveRecord(version$, tableName$)  

Removes a record from the given file based on the primary key in the conversion driver record.

ParameterDescription
version$ [input, string] version number, such as 05.00.00.00
tableName$ [input, string] table name
Returns [numeric]
ValueDescription
retFAILURE (0) - an error occurred
retSUCCESS (1) - record(s) removed
retWARNING (-1) - some record(s) not removed
FUNCTION RemoveRecordTask(version$)  

Calls the DeleteTask() method for all the task deletes for a given version.

ParameterDescription
version$ [input, string] version number, such as 05.00.00.00
Returns [numeric]
ValueDescription
retFAILURE (0) - an error occurred
retSUCCESS (1) - record(s) removed
retWARNING (-1) - some record(s) not removed
FUNCTION Rename(tableName$, newTableName$)  
FUNCTION Rename(tableName$, newTableName$, path$)  
FUNCTION Rename(tableName$, newTableName$, path$, option)  

Renames a file or table. This method wraps the SY_File Rename() method for ease of use by conversion developers.

ParameterDescription
tableName$ [input, string] current name of file/table to rename
newTableName$ [input, string] new name of file/table
path$ {optional} [input, string] full path or path constant to indicate location of file/table
option {optional} [input, numeric] database the file/table is in
Returns [boolean]
ValueDescription
0 - rename the SQL table if in SQL else rename the ProvideX file
1 - rename the ProvideX file
2 - rename the SQL table
retFAILURE (0) - an error was encountered
retSUCCESS (1) - table was renamed
FUNCTION RenameColumn(table$, path$, oldColumn$, newColumn$)  
FUNCTION RenameColumn(table$, path$, oldColumn$, newColumn$, addMethod$)  

Rename an existing column in a table.

ParameterDescription
table$ [input, string] table containing the column to be renamed.
path$ [input, string] full path or path constant to indicate location of file/table
oldColumn$ [input, string] current column name to be changed.
newColumn$ [input, string] new column name to apply.
addMethod$ {optional} [input, string] string containing method to run that contains additional logic to process, rec$ / iol$ containing all column values / names after the rename will be available as arguments.
Returns [numeric]
ValueDescription
retFAILURE (0) - rename column was not successful
retSUCCESS (1) - rename column was successful
retWARNING (-1) - rename was successful but cleanup failure occurred
FUNCTION SetDefaults(ch, record$)  

Temporary proxy function for the SY_Session'SetDefaults() method. See notes in implementation. Returns a record of default values defined in the DDE for the table opened on the channel

ParameterDescription
ch [input, numeric] channel the table is open on.
record$ [output, string] The record of default values that is returned.
ValueDescription
retSUCCESS (1) - method completed
FUNCTION TableConversionEncryptTable(tableName$, path$)  

Encrypts records in the table by opening, reading, encrypting and writing all records

ParameterDescription
tableName$ [input, string] name of file to encrypt
path$ [input, string] full path or path constant to indicate location of file/table; if null then the Physical File path in the dictionary is used to indicate if the file/table is located in MAS_SYSTEM or with the company data
Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - table was encrypted
FUNCTION TableConvertRenameColumns(tableName$, path$, oldFieldList$, newFieldList$)  
FUNCTION TableConvertRenameColumns(tableName$, path$, oldFieldList$, newFieldList$, setCreatedUpdated)  

Table conversion where fields names have been changed

ParameterDescription
tableName$ [input, string] name of file or table
path$ {optional} [input, string] full path or path constant to indicate location of file/table.
oldFieldList$ [input, string] comma-separated list of ProvideX field names
oldFieldList$ [input, string] comma-separated list of ProvideX field names
setCreatedUpdated {optional} [input, bool] flag used to update created/updated fields in the new table.
Returns [boolean]
ValueDescription
isTRUE (1) - if file or table was found.
isFALSE (0) - if file or table was not found.
FUNCTION TableExists(tableName$)  
FUNCTION TableExists(tableName$, path$)  
FUNCTION TableExists(tableName$, path$, pvxFile)  

Checks if physical Providex file or SQL table exists in the database.

ParameterDescription
tableName$ [input, string] name of file or table
path$ {optional} [input, string] full path or path constant to indicate location of file/table.
pvxFile { optional } [input, bool] optional flag to override SQL and force a file system find.
Returns [boolean]
ValueDescription
isTRUE (1) - if file or table was found.
isFALSE (0) - if file or table was not found.
FUNCTION UpdateCopyProgress(recCount)  

Updates the conversion progress meter.

ParameterDescription
recCount [input, numeric] Record count.
Returns [nothing]
FUNCTION LOCAL PERFORM AddUDFToDictionary()  

Adds UDF information to the dictionary

FUNCTION LOCAL ClearGridARecords(formId$, gridName$)  

Function used to clear user/"A" grid record sets when a breaking change (such as removing a grid column) has been made to the factory/"Z" grid record set.

ParameterDescription
formId$ [input, string] Name of NOMADS form/lib.
gridName$ [input, string] Grid name.
Returns retSUCCESS (1) - method completed
FUNCTION LOCAL CopyTableName$(tableName$)  

Returns a unique temporary name for copying a file or table.

ParameterDescription
tableName$ [input, string] Table or file name
Returns [string] unique temporary table name.
FUNCTION LOCAL CopyUDFsToMirrorTable(sourceTable$, mirrorTable$)  

Copy UDFs that exist in one table into its mirror table. Used when adding a new mirror table.

ParameterDescription
sourceTable$ [input, string] table name to copy UDFs from
mirrorTable$ [input, string] table name that is defined as the mirror table of sourceTable$ to copy the UDFs to
Returns [boolean]
ValueDescription
retSUCCESS (1) - method completed
FUNCTION LOCAL DeleteTask(taskKey$)  
FUNCTION LOCAL DeleteTask(taskKey$, fhTask, fhMenu, fhSecurity)  

Function that deletes a task record and cleans up menus and role security records for that task.

FUNCTION LOCAL DictionaryValidation(value$, description$, dataType$, validation$)  

Validates the given value against the contents of the validation argument. The validation is typically from the dictionary.

ParameterDescription
value$ [input, string] value to be validated; numeric value must be passed as string
description$ [input, string] table description; used for error messaging
dataType$ [input, string] "S" = string, "N" = numeric
validation$ [input, string] validation list and/or range, in the format used in the dictionary
Returns [boolean]
ValueDescription
retFAILURE (0) - value did not meet validation criteria
retSUCCESS (1) - value met validation criteria
FUNCTION LOCAL EncryptRec(table$, encryptCols$, iol$, rec$)  

Encrypt the part of a record that is defined in the dictionary as PII.

ParameterDescription
[input, string] Table name
[input, string] List of PII columns
[input, string] I/O List
[input/output, string] Original data record in, PII encrypted out.
Returns [bool] True if record was changed, otherwise false (zero).
FUNCTION LOCAL GetColumnRecords(convType$, version$, developerCode$, tableName$, originalIOL$)  

Builds memory file of conversion driver records for columns associated with the given table. These memory records also include column properties from the dictionary.

ParameterDescription
convType$ [input, string] type of conversion, such as DATA or DICT
version$ [input, string] version number, such as 05.00.00.00
developerCode$ [input, string] developer code
tableName$ [input, string] table name
originalIOL$ [input, string] IO List of the table before being updated (if available)
Returns [numeric]
ValueDescription
0 - no column conversion for the given table
-1 - an error was encountered, conversion will be halted
non-zero - file handle to the memory file
FUNCTION LOCAL InitCustomizer()  

Instantiates customizer objects and opens tables

Returns [boolean] success
FUNCTION LOCAL ResolveColumnTag(conversionTag$, ioList$, record$)  

Resolves a directive token for a column to an expression that can be evaluated during conversion processing.

ParameterDescription
conversionTag$ [input, string] directive conversion tag, such as
ioList$ [input, string] compiled IOList for conversion driver record
record$ [input and output, string] conversion driver record for column as a single string
Returns [boolen]
ValueDescription
retFAILURE (0) - token did not resolve to an expression
retSUCCESS (1) - token was resolved to an expression
FUNCTION LOCAL ResolveValueToken$(token$)  

Resolves a token to an actual value. For example, "" will return the system date as a string.

FUNCTION LOCAL SetCreatedUpdatedColumns(DateCreated$, TimeCreated$, UserCreatedKey$, DateUpdated$, TimeUpdated$, UserUpdatedKey$)  

Sets current system values for the standard time stamp columns in a record. After the first call to this method the date, time and user are stored in the local variables cDateStamp$, cTimeStamp$ and cUserStamp$.

ParameterDescription
DateCreated$ [input and output, string] system date to be used in time stamps; value is changed only if input is null
TimeCreated$ [input and output, string] system time to be used in time stamps; value is changed only if input is null
UserCreatedKey$ [input and output, string] user key to be used in time stamps; default user key (all zeros) if no user is logged in; value is changed only if input is null
DateUpdated$ [output, string] system date to be used in time stamps
TimeUpdated$ [output, string] system time to be used in time stamps
UserUpdatedKey$ [output, string] user key to be used in time stamps; default user key (all zeros) if no user is logged in
Returns [numeric] always retSUCCESS (1)
FUNCTION LOCAL UpdateProgressBar()  
FUNCTION LOCAL UpdateProgressBar(text$)  
FUNCTION LOCAL UpdateProgressBar(text$, percent)  

Function exposed to provide a progress bar to the conversion class

ParameterDescription
text$ {optional} [input, string] text to be displayed on the progress bar
percent {optional} [input, integer] percentage to force the progress bar to show
Returns [numeric]
ValueDescription
retSUCCESS (1)
FUNCTION LOCAL WriteToLog(logText$)  
FUNCTION LOCAL WriteToLog(logText$, logLevel)  
FUNCTION LOCAL WriteToLog(logText$, logLevel, logRaw)  

Writes text to the conversion log.

ParameterDescription
logText$ [input, string] text to be written to the conversion log
logLevel {optional} [input, integer] use to specify level of detail to be logged
logRaw {optional} [input, integer] text will be written without formatting
Returns [nothing]

Properties inherited from: SY_Constant

retFAILURE, retSUCCESS, retNEW, retWARNING, retCANCEL, retYES, retNO, msgYES$, msgNO$, msgCANCEL$, msgOK$, msgRETRY$, msgABORT$, msgIGNORE$, msgNOTONFILE$, msgTIMEOUT$, msgDISABLE, msgACTIVE, msgLinkHELP$, msgLinkMSG$, isFALSE, isTRUE, isYES$, isNO$, isBUSY$, edtNONE, edtEXISTS, edtNEW, ctlDISABLE, ctlENABLE, ctlSHOW, ctlHIDE, ctlLOCK, ctlUNLOCK, ctlLOCKORDISABLE, ctlUNLOCKORENABLE, popHIDE, popDISABLE, popSHOW, popSHOWCHECKED, grdMODEVIEW, grdMODEMAINT, grdMODEADD, filCREATE, filLOCK, filCREATELOCK, filGLOBAL, filCREATEGLOBAL, filLOCKGLOBAL, filCREATELOCKGLOBAL, filCHANNEL, filRAW, filPURGE, filLOAD, filINPUT, filNOOBJECT, filPVX, filREFRESH, filPVX4$, filPVX5$, pthCOMPANY$, pthOTHERCOMPANY$, pthPRCOMPANY$, pthOTHERPRCOMPANY$, pthSYSTEM$, pthUSER$, pthSOA$, pthHOME$, pthROOT$, pthDICTIONARY$, pthTEXTOUT$, pthLOCK$, pthLOCKSYS$, pthPREFIX$, pthARCHIVE$, pthLOGFILES$, folderCOMMONPROGRAMFILES, folderCOMMONAPPLICATIONDATA, errOBJECT, errSYSTEMLOCK, errCONTINUE, errEMBEDDEDIO, errSYSLOCK, extSQLCREATETABLE$, extSQLALLOWNULLDATES$, dbALL$, dbNONE$, dateTOSTRINGFORMAT$, dateLONGMASK$, dateSHORTFMT, dateLONGFMT, dateYEARFIRST, dateMONTHFIRST, dateDAYFIRST, timeMINUTESMASK$, timeMINUTES24MASK$, timeSECONDSMASK$, timeSECONDS24MASK$, idxPRIMARY$, idxBATCH$, idxDISPLAY$, dirFIRST, dirLAST, dirNEXT, dirPREVIOUS, typALPHANUM, typZEROFILL, typCHARNUM, typMASTERNUM, typALPHANUMNF, typMASTERNUMC, typALPHA$, typNUMBERS$, typALPHANUM$, typALPHANUMNF$, typCHARNUM$, typMASTERNUM$, typMASTERNUMCLEN, modTASKOTFDISALLOW$, logALLACTIVITY$, logACTIVITY$, logERROR$, logACTNEWCUSTOMER$, logACTDATASYNC$, logACTDATAIMPORT$, logACTOPTIONCHANGED$, logACTPROGRAMLAUNCH$, logDFDM$, logSECURITY$, logTASKSCHEDULER$, logWEBERROR$, logVISUALINTEGRATOR$, logEntryIDLength, chkOFF$, chkON$, chkGRAYED$, secVIEWONLY, secCREATEONLY, secMODIFYONLY, secCREATEMODIFY, secDELETEONLY, secCREATEDELETE, secMODIFYDELETE, secFULLACCESS, secDEFAULTUSER$, secDEFAULTROLE$, regHKEY_CLASSES_ROOT, regHKEY_CURRENT_USER, regHKEY_LOCAL_MACHINE, regHKEY_USERS, regHKEY_CURRENT_CONFIG, regODBC_PATH$, regMAS_PATH$, E3_MYHANDLE, E3_TASK, E3_QUIT, E3_COCHANGE, E3_DATECHANGE, E3_USERCHANGE, E3_SRVRPATH, E3_HELPFILE, E3_TECHSUPPORT, E3_QUERYTOQUIT, E3_SUPERVISOR, E3_CUSTOMIZE, E3_SWITCHMODULE, E3_DISABLEWIN, E3_CURSOR, E3_USERID, E3_PRIVATETASK, E3_CHAT, E3_BROADCAST, E3_RELOAD, E3_PASSTHROUGH, E3_EXECUTE, E3_EXPCOCHANGE, E3_EXPTASK, E3_EXPLAUNCH, E3_SILENT, E3_DIRECT, E3_NODELIST, E3_OCXITEM, E3_MODULEID, E3_CUSTFAV, E3_HOMEPAGE, E3_MINIMIZE, E3_UNDOCKED, E3_DOCKED, E3_PUBLICTASK, E3_LAUNCHURL, E3_BTNCHANGE, E3_STDBTNRELOAD, E3_MYBUSINESS, E3_REGLOADED, E3_LOADED, E3_V4TASK, E3_PUBMODIFY, E3_TASKRELOAD, E3_SETAUTOHIDE, E3_COCHANGE2, E3_TASK_NC, E3_V4TASK_NC, E3_TASK_ALTC, E3_V4TASK_ALTC, E3_PASSWORD, E3_LAUNCHVIEW, E3_LAUNCHBIETASK, E3_CLEANUPBIE, E3_STARTVIEW, E3_BIE_ADMIN, E3_HELPPATH, E3_CUSTOMERID, E3_MASVERSION, E3_LAUNCHEMBEDDED, E3_LAUNCHERMENU, E3_APP_POINTSIZE, E3_LAUNCHERVERSION, E3_DISABLE, E3_ENABLE, E3_SHOW, E3_HIDE, E3_REFRESH, E3_LIBMASTER, WM_COPY, wtsINITIALPROGRAM, wtsAPPLICATIONNAME, wtsWORKINGDIRECTORY, wtsOEMID, wtsSESSIONID, wtsUSERNAME, wtsWINSTATIONNAME, wtsDOMAINNAME, wtsCONNECTSTATE, wtsCLIENTBUILDNUMBER, wtsCLIENTNAME, wtsCLIENTDIRECTORY, wtsCLIENTPRODUCTID, wtsCLIENTHARDWAREID, wtsCLIENTADDRESS, wtsCLIENTDISPLAY, wtsCLIENTPROTOCOLTYPE, thmNORMAL, thmMETAL, thmOLIVE, rptREPORTTYPESTD, rptREPORTTYPELABEL, rptREPORTTYPEMULTCOL, rptISTRUE, rptISFALSE, rptISDEFAULT, rptPORTRAIT, rptLANDSCAPE, rptASCENDING, rptDESCENDING, rptRIGHTALIGN, rptLEFTALIGN, rptHORCENTERALIGN, rptLSSINGLELINE, rptSTSUM, rptSTAVERAGE, rptSTCOUNT, rptDFLTHSPACING, rptDFLTVSPACING, rptDFLTFONTSIZE, rptDFLTLEFT, rptDFLTTOP, rptTWIPSPERCHARW, rptTWIPSPERCHARH, rptSVTREPORTTITLE, rptEDTDISKFILE, rptGCANYVALUE, rptGCDAILY, rptCRDATEFIELD, rptCRDATETIMEFIELD, crEFTCrystalReport, crEFTRichText, crEFTWordForWindows, crEFTExcel, crEFTPortableDocFormat, crEFTHTML32, crEFTHTML40, crEFTExcelRecord, crEFTText, crEFTCharacterSeparatedValues, crEFTTabSeparatedText, crEFTEditableRTF, crEFTXml, crEFTRPTR, crEFTExcelWorkbook, cContextKeyLen1, cContextKeyLen2, cContextKeyLen3, adCmdText, adCmdStoredProc, adClipString, adExecuteNoRecords, adVarChar, adInteger, adParamInput, adParamOutput, adParamInputOutput, adParamReturnValue, adTextNoRecords, adOpenForwardOnly, adOpenStatic, adLockReadOnly, adUseServer, adUseClient, dbTMP$, dbTEMPDB$, dbSYSDB$, dbPVXDDF, dbPVXDB, dbMYSQL, dbADO, dbSQL, LastErrorMsg$, LastErrorNum$, SageCloudAppDesc$, IolNomads$

Properties inherited from: SY_ConversionConstant

cnvtagCOLDROP$, cnvtagIDXDROP$, cnvtagSETDEFAULT$, cnvtagSETINVALID$, cnvtagSETVALUE$, cnvtagTBLCOPY$, cnvtagTBLUPDATE$, cnvtagTBLDROP$, cnvtagRECDROP$, cnvtypDATA$, cnvtypDICTIONARY$, cnvtypREMOVEDATA$, cnvtypINFORMATION$, vertokenSYSTEM$, vertokenPAYROLL$, devcodeSAGE$, versionSELECTLENGTH

Methods inherited from: SY_Constant

GetNOMADSIolist$(), MaskString(), RawString(), ClassValidateEMailAddress(), dateTODAY$(), Element$(), fmtMODCODE$(), fmtMODPREFIX$(), PERFORM FunctionBreak(), GetExceptionMsg$(), GetFileName(), GetJobTitles(), GetPrinterProps(), GetRecordCount(), isALPHA(), isDATE(), isNUMERIC(), MsgPath$(), ParseString(), ParseTagField(), Position(), QUO$(), ValidateFormatType()

Methods inherited from: SY_ConversionCommon

GetOriginalTableIOL$(), IsModuleSetup()

Methods inherited from: SY_ConversionConstant

GetValidCnvTags$(), GetValidCnvTypes$(), FormatVersion$(), GetConstantValues(), IsPvxToSQLConversion(), IsPvxToSQLTable()

Methods inherited from: SY_FunctionHook

PostTableRead(), PreNextRecord(), PreTableWrite()