第一章 LotusScript与Notes公式语言概述 1
1.1在何处使用Script和公式 1
1.2编写便捷图标公式 6
1.3编写复制公式 7
1.4编写代理的Script和公式 8
1.5编写操作的Script和公式 10
1.6编写按钮和热点的Script和公式 12
1.7编写表单、选择和列公式 14
1.8编写窗口标题、区段存取和插入子表单公式 16
1.9编写区段标题和隐藏段落公式 17
1.10编写数据库、视图、表单和域事件的Script和公式 18
1.11编写域设计公式 19
1.12理解Script对象和事件 22
2.1使用LotusScript的设计窗格 25
第二章 LotusScript的用户界面 25
2.2使用Script编辑器的方法 26
2.3编译Script 31
2.4使用调试器的方法 31
2.5使用Script库 35
第三章 LotusScript Notes类编码指南 36
3.1使用Notes类 36
3.2在Notes中使用LotusScript特性的方法 37
3.3访问Notes数据库的方法 42
3.4访问Notes视图和文件夹的方法 53
3.5访问Notes文档的方法 57
3.6访问Notes条目的方法 77
3.7访问Notes会话的方法 90
3.8访问支持Notes对象的方法 95
3.9使用LotusScript通过ODBC访问外部数据库的方法 100
3.10连接到数据源 101
3.11查询表 104
3.12检查结果集合 108
3.13更新表 115
3.14处理ODBC错误 120
3.15处理ODBC事件 121
3.16处理运行错误 127
3.17使用OLE定制控件 142
3.18在Visual Basic中使用Notes类 146
第四章 LotusScript Notes类A-Z 148
Button类 157
Field类 158
Navigator类 159
NotesACL类 160
NotesACLEntry类 170
NotesAgent类 183
NotesDatabase类 194
NotesDateRange类 258
NotesDateTime类 261
NotesDbDirectory类 278
NotesDocument类 281
NotesDocumentCollection类 336
NotesEmbeddedObject类 349
NotesForm类 358
NotesInternational类 368
NotesItem类 377
NotesLog类 397
NotesName类 414
NotesNewsletter类 421
NotesRegistration类 428
NotesRichTextItem类 441
NotesRichTextStyle类 454
NotesSession类 495
NotesUIDocument类 499
NotesUIView类 543
NotesUIWorkspace类 552
NotesView类 564
NotesViewColumn类 593
ODBCConnection类 602
ODBCQuery类 619
ODBCResultSet类 634
第五章 Notes公式语言规则 696
5.1输入公式的方法 696
5.2使用语法规则的方法 697
5.3使用变量的方法 699
5.4使用常量的方法 701
5.5使用运算符的方法 703
5.6使用函数的方法 708
5.7使用关键字 711
5.8在公式中指定表单和视图的名称 712
5.9调试公式 712
第六章 Notes公式语言编码指南 713
6.1编写公式的方法 713
6.2编写消息和取得用户输入的方法 719
6.3处理错误的方法 724
6.4使用函数 725
6.5使用命令 727
6.6执行字符串操作的方法 728
6.7执行算术运算 734
6.8执行时间－日期运算 738
6.9访问用户环境 740
6.10访问当前数据库和视图 741
6.11在公式语言中访问当前文档 743
6.12访问在当前文档和数据库以外的数据 746
6.13使用函数通过ODBC访问外部数据库 747
第七章 Notes公式语言函数A-Z 749
7.1此函数用在何处？ 749
7.2 ECL安全性相关的函数 763
@Abs 764
@Abstrcat 765
@Accessed 770
@Adjust 771
@Acos 771
@AllChildren 773
@All 773
@AllDescendants 774
@Ascii 776
@Atan 777
@Asin 777
@Atan2 778
@AttachmentLengths 779
@Attachments 780
@AttachmentNames 780
@Begins 781
@Author 781
@Certificate 782
@Char 783
@ClientType 784
@CheckAlarms 784
@Command 785
@Cos 786
@Contains 786
@Created 787
@Date 788
@DbColumn（Notes数据库） 789
@Day 789
@DbColumn(ODBC) 792
@DbCommand(ODBC) 796
@DbExists 799
@DbLookup（Notes数据库） 800
@DbLookup(ODBC) 804
@DbManager 808
@DbName 809
@DDEExecute 810
@DbTitle 810
@DDEInitiate 812
@DDEPoke 813
DEFAULT 814
@DDETerminate 814
@DeleteField 815
@DeleteDocument 815
@DialogBox 816
@Do 817
@DocChildren 818
@DocDescendants 819
@DocFields 820
@DocLevel 821
@DocLength 821
@DocNumber 822
@DocMark 822
@DocParentNumber 823
@DocSiblings 824
@DocumentUniqueID 825
@Domain 826
@Elements 827
@EditUserECL 827
@EditECL 827
@Ends 828
@EnableAlarms 828
@Environment 829
ENVIRONMENT 829
@Exp 832
@Error 832
@Explode 833
@Failure 834
FIELD 835
@False 835
@GetPortsList 836
@GetDocField 836
@GetProfileField 837
@If 838
@Hour 838
@InheritedDocumentUniqueID 840
@Implode 840
@IsAgentEnabled 841
@Integer 841
@IsAvailable 842
@IsCategory 843
@IsDocBeingLoaded 844
@IsDocBeingEdited 844
@IsDocBeingRecalculated 845
@IsDocBeingMailed 845
@IsDocBeingSaved 846
@IsDocBeingSaved 846
@IsError 847
@IsDocTruncated 847
@IsExpandable 848
@IsMember 849
@IsNewDoc 850
@IsModalHelp 850
@IsNumber 851
@IsNotMember 851
@IsText 852
@IsResponseDoc 852
@IsUnavailable 853
@IsTime 853
@Keywords 854
@IsValid 854
@Left 855
@LeftBack 856
@Like 857
@Length 857
@Ln 858
@LowerCase 859
@Log 859
@MailDbName 860
@MailEncryptSentPreference 861
@MailEncryptSavedPreference 861
@MailSend 862
@MailSavePreference 862
@Matches 865
@MailSignPreference 865
@Member 867
@Max 867
@Middle 868
@MiddleBack 869
@Min 871
@Modified 872
@Minute 872
@Modulo 873
@Month 874
@Name 875
@No 877
@NewLine 877
@OptimizeMailAddress 878
@Now 878
@NoteID 878
@Password 879
@PickList 880
@Pi 880
@Platform 882
@PostedCommand 883
@Prompt 884
@Power 884
@Random 888
@properCase 888
REM 889
@RefreshECL 889
@Replace 890
@Repeat 890
@ReplaceSubstring 891
@Responses 892
@Return 893
@RightBack 894
@Right 894
@Round 895
@Second 896
SELECT 897
@Set 898
@Select 898
@SetDocField 899
@SetField 900
@SetEnvironment 900
@SetProfileField 901
@Sin 902
@Sign 902
@Sqrt 903
@Soundex 903
@Success 904
@Subset 904
@Sum 905
@Text 906
@Tan 906
@TextToNumber 908
@Time 909
@TextToTime 909
@Today 910
@Trim 911
@Tomorrow 911
@True 912
@Unique 913
@Unavailable 913
@URLGetHeader 914
@UpperCase 914
@URLHistory 915
@URLOpen 917
@UserAccess 918
@UserName 919
@UserPrivileges 920
@UserRoles 921
@V3UserName 922
@V2If 922
@ViewTitle 923
@Version 923
@Word 924
@Weekday 924
@Year 925
@Yesterday 926
@Yes 926
@Zone 927
8.2ECL安全性相关的@Command 929
8.1关于使用@Command 929
第八章 Notes公式语言命令参考 929
AddDatabase 931
AdminCertify 932
AddDatabaseRepID 932
AdminDatabaseQuotas 933
AdminDatabaseAnalysis 933
AdminCreateGroup 933
AdminCrossCertifyIDFile 933
AdminCrossCertifyKey 933
Administration 934
AdminIDFileSetPassword 934
AdminIDFileClearPassword 934
AdminIDFileExamine 934
AdminOpenAddressBook 935
AdminNewOrgUnit 935
AdminNewCertifier 935
AdminNewOrganization 935
AdminOpenServerLog 936
AdminOpenGroupsView 936
AdminOpenCatalog 936
AdminOpenCertLog 936
AdminOutgoingMail 937
AdminOpenUsersView 937
AdminOpenServersView 937
AdminOpenStatistics 937
AdminRemoteConsole 938
AdminRegisterUser 938
AdminRegisterFromFile 938
AdminRegisterServer 938
AgentEdit 939
AdminTraceConnection 939
AdminSendMailTrace 939
AdminStatisticsConfig 939
AgentSetServerName 940
AgentRun 940
AgentEnableDisable 940
AgentLog 940
AttachmentLaunch 941
AttachmentDetachAll 941
AgentTestRun 941
CalendarFormat 942
AttachmentView 942
AttachmentProperties 942
Compose 943
ChooseFolders 943
CalendarGoTo 943
CreateAgent 944
CreateAction 944
CreateForm 945
CreateFolder 945
CreateControlledAccessSection 945
CreateEllipse 945
CreateRectangle 946
CreatePolyline 946
CreateLayoutRegion 946
CreateNavigator 946
CreatePolygon 946
CreateTextbox 947
CreateSubForm 947
CreateRectangularHotspot 947
CreateSection 947
DesignDocumentInfo 948
DebugLotusScript 948
CreateView 948
DatabaseReplSettings 948
DesignFormShareField 949
DesignForms 949
DesignFormAttributes 949
DesignFormFieldDef 949
DesignFormNewField 949
DesignHelpUsingDocument 950
DesignHelpAboutDocument 950
DesignFormUseField 950
DesignFormWindowTitle 950
DesignReplace 951
DesignRefresh 951
DesignIcon 951
DesignMacros 951
DesignViewColumnDef 952
DesignViewAttributes 952
DesignSharedFields 952
DesignSynopsis 952
DesignViewAppendColumn 952
DesignViews 953
DesignViewNewColumn 953
DesignViewEditActions 953
DesignViewFormFormula 953
EditButton 954
EditBottom 954
DesignViewSelectFormula 954
DialingRules 954
EditCut 955
EditCopy 955
EditClear 955
EditDetach 956
EditDeselectAll 956
EditDown 957
EditDocument 957
EditFindNext 958
EditFindInPreview 958
EditEncryptionKeys 958
EditFind 958
EditHorizScrollbar 959
EditHeaderFooter 959
EditGoToField 959
EditInsertFileAttachment 960
EditInsertButton 960
EditIndent 960
EditIndentFirstLine 960
EditInsertPageBreak 961
EditInsertObject 961
EditInsertText 962
EditInsertTable 962
EditInsertPopup 962
EditLocations 963
EditLinks 963
EditLeft 963
EditPaste 964
EditOpenLink 964
EditMakeDocLink 964
EditNextField 964
EditProfile 965
EditPrevField 965
EditPasteSpecial 965
EditPhoneNumbers 965
EditRight 966
EditResizePicture 966
EditShowHideHiddenChars 967
EditSelectByDate 967
EditSelectAll 967
EditTop 968
EditTableInsertRowColumn 968
EditTableDeleteRowColumn 968
EditTableFormat 968
EditUp 969
EditUntruncate 969
EditUndo 969
Execute 970
ExchangeUnreadMarks 970
EmptyTrash 970
FileDatabaseCopy 971
FileDatabaseCompact 971
FileCloseWindow 971
FileDatabaseACL 971
FileDatabaseRemove 972
FileDatabaseInfo 972
FileDatabaseDelete 972
FileExport 973
FileExit 973
FileDatabaseUseServer 973
FileFullTextUpdate 975
FileFullTextInfo 975
FileFullTextCreate 975
FileFullTextDelete 975
FileImport 976
FileNewDatabase 977
FileOpenDatabase 978
FileNewReplica 978
FileOpenDBRepID 979
FilePageSetup 980
FilePrint 981
FileSaveNewVersion 982
FileSave 982
FilePrintSetup 982
FindFreeTimeDialog 983
FolderCustomize 984
FolderCollapse 984
Folder 984
FolderProperties 985
FolderMove 985
FolderExpand 985
FolderExpandAll 985
FolderExpandWithChildren 985
Help 986
GoUpLevel 986
FolderRename 986
FormActions 986
FormTestDocument 986
HelpIndex 987
HelpFunctions 987
HelpAboutDatabase 987
HelpAboutNotes 987
HelpTableOfContents 988
HelpReleaseNotes 988
HelpKeyboard 988
HelpMessages 988
HelpRelease3MenuFinder 988
InsertSubForm 989
HotSpotProperties 989
HelpUsingDatabase 989
HotSpotClear 989
LayoutElementSendToBack 990
LayoutElementProperties 990
LayoutAddGraphic 990
LayoutAddText 990
LayoutElementBringToFront 990
MailForward 991
MailComposeMemo 991
LayoutProperties 991
MailAddress 991
MailRequestNewName 992
MailRequestCrossCert 992
MailForwardAsAttachment 992
MailOpen 992
MailSendCertificateRequest 993
MailSend 993
MailRequestNewPublicKey 993
MailScanUnread 993
NavigateNextHighlight 994
NavigateNext 994
MailSendEncryptionKey 994
MailSendPublicKey 994
NavigateNextUnread 995
NavigateNextSelected 995
NavigateNextMain 995
NavigatePrevMain 996
NavigatePrevHighlight 996
NavigatePrev 996
NavigateToBackLink 997
NavigatePrevUnread 997
NavigatePrevSelected 997
ObjectProperties 998
ObjectOpen 998
NavigatorProperties 998
NavigatorTest 998
ObjectDisplayAs 998
OpenDocument 999
OpenCalendar 999
OpenView 1000
OpenNavigator 1000
PublishDatabase 1001
PictureProperties 1001
PasteBitmapAsBackground 1001
PasteBitmapAsObject 1001
RenameDatabase 1002
RemoveFromFolder 1002
RefreshHideFormulas 1002
ReplicatorReplicateSelected 1003
ReplicatorReplicateNext 1003
Replicator 1003
ReplicatorReplicateHigh 1003
ReplicatorStop 1004
ReplicatorStart 1004
ReplicatorReplicateWithServer 1004
ReplicatorSendMail 1004
ReplicatorSendReceiveMail 1004
SectionExpand 1005
SectionDefineEditors 1005
SectionCollapse 1005
SectionCollaPseAll 1005
SetCurrentLocation 1006
SectionRemoveHeader 1006
SectionExpandAll 1006
SectionProperties 1006
ShowHidePreviewPane 1007
ShowHideParentPreview 1007
ShowHideLinkPreview 1007
TextAlignCenter 1008
StyleCycleKey 1008
ShowProperties 1008
SmartIconsFloating 1008
SmartIconsNextSet 1008
TextAlignRight 1009
TextAlignNone 1009
TextAlignFull 1009
TextAlignLeft 1009
TextCycleSpacing 1010
TextBullet 1010
TextBold 1010
TextNorrnal 1011
TextItalic 1011
TextEnlargeFont 1011
TextFont 1011
TextParagraph 1012
TextOutdent 1012
TextNumbers 1012
TextReduceFont 1013
TextPermanentPen 1013
TextParagraphStyles 1013
TextSetFontFace 1014
TextSetFontColor 1014
TextSpacingOneAndAHalf 1015
TextSpacingDouble 1015
TextSetFontSize 1015
ToolsCategorize 1016
ToolsCall 1016
TextSpacingSingle 1016
TextUnderline 1016
ToolsMarkAllUnread 1017
ToolsMarkAllRead 1017
ToolsHangUp 1017
ToolsRefreshSelectedDocs 1018
ToolsRefreshAllDocs 1018
ToolsMarkSelectedRead 1018
ToolsMarkSelectedUnread 1018
ToolsRunMacro 1019
ToolsRunBackgroundMacros 1019
ToolsReplicate 1019
ToolsScanUnreadSelected 1020
ToolsScanUnreadPreferred 1020
ToolsScanUnreadChoose 1020
ToolsSmartIcons 1021
ToolsSetupUserSetup 1021
ToolsSetupLocation 1021
ToolsSetupMail 1021
ToolsSetupPorts 1021
UserIDClearPassword 1022
UserIDCertificates 1022
ToolsSpellCheck 1022
ToolsUserLogoff 1022
UserIDMergeCopy 1023
UserIDInfo 1023
UserIDCreateSafeCopy 1023
UserIDEncryptionKeys 1023
UserIDSetPassword 1024
UserIDSwitch 1024
V3EditNextField 1024
V3EditPrevField 1024
ViewArrangeIcons 1025
ViewBelowFolders 1025
ViewBesideFolders 1025
ViewCertify 1025
ViewChange 1026
ViewCollapse 1026
ViewCollapseAll 1026
ViewExpand 1027
ViewExpandAll 1027
ViewExpandWithChildren 1027
ViewHorizScrollBar 1027
ViewNavigatorsNone 1028
ViewNavigatorsFolders 1028
ViewPageDown 1028
ViewMoveName 1028
ViewRefreshUnread 1029
ViewRefreshFields 1029
ViewRenamePerson 1029
ViewUpDown 1029
ViewShowOnlyCategories 1030
ViewShowObject 1030
ViewShowOnlySearchResults 1030
ViewShowFieldHelp 1030
ViewShowPageBreaks 1031
ViewShowOnlyUnread 1031
ViewShowRuler 1031
ViewShowOnlySelected 1031
ViewShowUnread 1032
ViewShowServerNames 1032
ViewSwitchForm 1032
ViewShowSearchBar 1032
WindowMinimize 1033
WindowMaximizeAll 1033
WindowMinimizeAll 1033
WindowMaximize 1033
WindowCascade 1033
WindowTile 1034
WindowRestore 1034
WindowWorkspace 1034
WindowNext 1034
WorkspaceStackReplicaIcons 1035
ZoomPreview 1035
WorkspaceProperties 1035
附录 LotusScriptNotes课程指导 1036
第一课 打印数据库题 1036
第二课 统计视图中文档的数量 1039
第三课 发送电子邮件消息 1043