Table of Contents

Datawindow caching 6, Error handling 7, Transaction registration 7, Debug 7, Security 7, Finishing the application manager 7

Inheritance 10, Where to put changes 10

The PFC layer 12, The third party library layer 12, The corporate layer 13, The PFE layer 13, The departmental layer 13, The application layer 14

of_about 18, of_getAppIniFile 18, of_getAppKey 19, of_getCopyright 19, of_getFrame 19, of_getHelpFile 20, of_getLogo 20, of_getMicrohelp 20, of_getUserID 20, of_getUserIniFile 21, of_getUserKey 21, of_getVersion 21, of_isRegistryAvailable 21, of_logonDlg 22, of_setAppIniFile 22, of_setAppKey 23, of_setCopyright 23, of_setDebug 23, of_setDwCache 23, of_setError 24, of_setFrame 24, of_setHelpFile 24, of_setLogo 24, of_setMicrohelp 25, of_setTrRegistration 25, of_setUserID 25, of_setUserIniFile 25, of_setUserKey 26, of_setVersion 26, of_splash 26

of_boolean 28, Boolean to integer 28, String to boolean 29

of_dayOfWeek(date) 30, of_days(long) 31, of_firstDayOfMonth(date) 31, of_gregorian(long) 31, of_hours(long) 32, of_isLeapYear(date) 32, of_isValid(date) (dateTime) 32, of_isWeekday(date) 33, of_isWeekend(date) 33, of_julian(date) 33, of_julianDayNumber(date) 33, of_lastDayOfMonth(date) 34, of_milliSecAfter(time,time) 34, of_monthsAfter(date,date) 34, of_relativeDateTime (dateTime,dateTime) 34, of_relativeMonth(date,long) 35, of_relativeYear(date,long) 35, of_secondsAfter(dateTime, dateTime) 35, of_wait(dateTime) 36, of_weekNumber(date) 36, of_weeksAfter(date,date) 36, of_yearsAfter(date,date) 36

of_assemblePath 40, of_changeDirectory 41, of_createDirectory 41, of_directoryExists 41, of_dirList 41, of_fileRename 42, of_getAltFileName 42, of_getCreationDateTime 43, of_getCurrentDirectory 43, of_getDiskSpace 43, of_getDriveType 43, of_getFileAttributes 44, of_getFileSize 44, of_getLastAccessDate 45, of_getLastWriteDateTime 45, of_getLongFileName 45, of_removeDirectory 45, of_setCreationDateTime 46, of_setFileAttributes 46, of_setAccessDateTime 46, of_setLastWriteDateTime 46

of_delete 47, of_getKeys 48, of_getSections 48

Mechanics 49

of_binary 50, of_bitwiseAnd 50, of_bitwiseNot 51, of_bitwiseOr 51, of_bitwiseXor 51, of_decimal 51, of_getBit 52

Starting the SQLSpy object 53, Starting the log file 53, The SQLSpy popup window 53, The SQLSpy inspector window 53

of_arrayToString 55, of_countOccurrences 56, of_getKeyValue 56, of_getToken 57, of_globalReplace 57, of_isAlpha 57, of_isAlphaNum 58, of_isArithmeticOperator 58, of_isComparisonOperator 58, of_isEmpty 59, of_isFormat 59, of_isLower 59, of_isPrintable 59, of_isPunctuation 60, of_isSpace 60, of_isUpper 60, of_isWhiteSpace 60, of_lastPos 61, of_leftTrim 61, of_padLeft 62, of_padRight 62, of_parseToArray 62, of_quote 63, of_removeNonprint 63, of_removeWhiteSpace 63, of_rightTrim 63, of_wordCap 64

of_describe 66, of_dwArguments 67, of_getColumnNameSource 68, of_getDisplayItem 68, of_getDisplayUnits 68, of_getHeaderName 68, of_getHeight 69, of_getItem 69, of_getItemAny 70, of_getObjects 72, of_getWidth 72, of_modify 73, of_refreshDDDWs 74, of_setColumnNameSource 74, of_setItem 74

Datawindow linkage services 76, Datawindow drop-down calendar service 77, Datawindow drop-down calculator service 77, Datawindow properties service 77

Datawindow caching 79, Debugging 80, Error 80, Security 80, Transaction registration 81

of_arrayToString 84, of_occurrences 85, of_getKeyValue 85, of_getToken 86, of_globalReplace 86, of_isAlpha 87, of_isAlphaNum 87, of_isArithmeticOperator 87, of_isComparisonOperator 88, of_isEmpty 88, of_isFormat 88, of_isLower 88, of_isPrintable 89, of_isPunctuation 89, of_isSpace 89, of_isUpper 89, of_isWhiteSpace 90, of_lastPos 90, of_leftTrim 90, of_padLeft 90, of_padRight 91, of_parseToArray 91, of_quote 91, of_removeNonPrint 91, of_removeWhiteSpace 92, of_rightTrim 92, of_setKeyValue 92, of_trim 92, of_wordCap 92

Basic window services 93, Preferences 94, Sheet management 95, of_getCurrentState 95, of_getSheetCount 95, of_getSheets 95, of_getSheetsByClass 96, of_getSheetsByTitle 96, of_setCurrentState 96, of_setRequestor 96, Status bar service 97

Mechanics 97

Mechanics 102

Mechanics 103, Suggestion 104

Instance variables 105, User object functions 105, Events 105

Instance variables 105, User object functions 105, Events 106

Instance variables 107, User object functions 107, Events 107

Instance variables 109, User object functions 109, Events 109

Instance variables 110, User object functions 111, Events 116

Instance variables 128, User object functions 128, Events 129

Instance variables 130, User object functions 131, Events 131

Instance variables 131, User object functions 131, Events 132

Instance variables 132, User object functions 133, Events 133

Instance variables 134, User object functions 135, Events 140

Instance variables 141, User object functions 141, Events 142

Instance variables 143, User object functions 144, Events 144

Instance variables 147, User object functions 147, Events 148

Instance variables 148, User object functions 148, Events 148

Instance variables 149, User object functions 149, Events 150

Mechanics 151

Instance variables 152, User object functions 152, Events 153

Instance variables 153, User object functions 154, Events 160

Instance variables 166, User object functions 167, Events 167

Instance variables 169, User object functions 169, Events 170

Instance variables 171, User object functions 171, Events 171

Instance variables 172, User object functions 172, Events 173

Structures 173, Instance variables 174, User object functions 174, Events 178

Instance variables 180, User object functions 180, Events 180