Lotus Domino程序员实战指南PDF电子书下载

第一章 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