LOCAL cHistoryIol$="IOLIST VERSION$, CONVERSIONTYPE$, TABLENAME$, CONVERSIONID$, DEVELOPERCODE$, CONVERSIONNOTES$, IGNORERECORD$, DATECREATED$, TIMECREATED$, USERCREATEDKEY$" |
PROPERTY LogObj * Read Only * |
FUNCTION ClearHistoryRecordsToUpdate() Clears the list of conversion history records to update. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION CloseTableCopy(copyComplete) Closes the source and destination channels of an open conversion copy operation. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION CreateTableNewCopy(tableName$, path$) Creates a new copy of a file or table and copies the original data then deletes the original. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION GetHistoryRecordsToUpdate$() Returns a list of conversion history records that will be performed when multiple conversion records are processed. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION OpenTableCopy(srcTable$, path$, srcCH, dstCH) Opens the source and destination channels in preparation of a conversion copy operation. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION RemoveDctDefinitions(fileList$) Removes file definitions from the old SY0DCT.SOA Dictionary | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION RemoveLegacyFileDefinitions(fileList$, ddFiles$) | ||||||||||||||
FUNCTION RemoveLegacyFileDefinitions(fileList$) Removes file definitions from the Legacy (Roswell) Data Dictionary (SY0DD2.SOA,SY0DD4.SOA,SY0DD5.SOA) | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION RemoveRecord(version$, tableName$) Removes a record from the given file based on the primary key in the conversion driver record. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION RemoveRecordTask(version$) Calls the DeleteTask() method for all the task deletes for a given version. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION RenameColumn(table$, path$, oldColumn$, newColumn$) | ||||||||||||||
FUNCTION RenameColumn(table$, path$, oldColumn$, newColumn$, addMethod$) Rename an existing column in a table. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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 | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION TableConversionEncryptTable(tableName$, path$) Encrypts records in the table by opening, reading, encrypting and writing all records | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION TableConvertRenameColumns(tableName$, path$, oldFieldList$, newFieldList$) | ||||||||||||||
FUNCTION TableConvertRenameColumns(tableName$, path$, oldFieldList$, newFieldList$, setCreatedUpdated) Table conversion where fields names have been changed | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION TableExists(tableName$) | ||||||||||||||
FUNCTION TableExists(tableName$, path$) | ||||||||||||||
FUNCTION TableExists(tableName$, path$, pvxFile) Checks if physical Providex file or SQL table exists in the database. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION UpdateCopyProgress(recCount) Updates the conversion progress meter. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL CopyTableName$(tableName$) Returns a unique temporary name for copying a file or table. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL CopyUDFsToMirrorTable(sourceTable$, mirrorTable$) Copy UDFs that exist in one table into its mirror table. Used when adding a new mirror table. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL EncryptRec(table$, encryptCols$, iol$, rec$) Encrypt the part of a record that is defined in the dictionary as PII. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
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. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL InitCustomizer() Instantiates customizer objects and opens tables | ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL ResolveColumnTag(conversionTag$, ioList$, record$) Resolves a directive token for a column to an expression that can be evaluated during conversion processing. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL ResolveValueToken$(token$)
Resolves a token to an actual value. For example, " | ||||||||||||||
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$. | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL UpdateProgressBar() | ||||||||||||||
FUNCTION LOCAL UpdateProgressBar(text$) | ||||||||||||||
FUNCTION LOCAL UpdateProgressBar(text$, percent) Function exposed to provide a progress bar to the conversion class | ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
FUNCTION LOCAL WriteToLog(logText$) | ||||||||||||||
FUNCTION LOCAL WriteToLog(logText$, logLevel) | ||||||||||||||
FUNCTION LOCAL WriteToLog(logText$, logLevel, logRaw) Writes text to the conversion log. | ||||||||||||||
| ||||||||||||||
|
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$ |
cnvtagCOLDROP$, cnvtagIDXDROP$, cnvtagSETDEFAULT$, cnvtagSETINVALID$, cnvtagSETVALUE$, cnvtagTBLCOPY$, cnvtagTBLUPDATE$, cnvtagTBLDROP$, cnvtagRECDROP$, cnvtypDATA$, cnvtypDICTIONARY$, cnvtypREMOVEDATA$, cnvtypINFORMATION$, vertokenSYSTEM$, vertokenPAYROLL$, devcodeSAGE$, versionSELECTLENGTH |
GetNOMADSIolist$(), MaskString(), RawString(), ClassValidateEMailAddress(), dateTODAY$(), Element$(), fmtMODCODE$(), fmtMODPREFIX$(), PERFORM FunctionBreak(), GetExceptionMsg$(), GetFileName(), GetJobTitles(), GetPrinterProps(), GetRecordCount(), isALPHA(), isDATE(), isNUMERIC(), MsgPath$(), ParseString(), ParseTagField(), Position(), QUO$(), ValidateFormatType() |
GetOriginalTableIOL$(), IsModuleSetup() |
GetValidCnvTags$(), GetValidCnvTypes$(), FormatVersion$(), GetConstantValues(), IsPvxToSQLConversion(), IsPvxToSQLTable() |
PostTableRead(), PreNextRecord(), PreTableWrite() |