《Lotus Domino程序员实战指南》

第一章 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编译Script31

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-Z148

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-Z749

7.1此函数用在何处？749

7.2 ECL安全性相关的函数763

@Abs764

@Abstrcat765

@Accessed770

@Adjust771

@Acos771

@AllChildren773

@All773

@AllDescendants774

@Ascii776

@Atan777

@Asin777

@Atan2778

@AttachmentLengths779

@Attachments780

@AttachmentNames780

@Begins781

@Author781

@Certificate782

@Char783

@ClientType784

@CheckAlarms784

@Command785

@Cos786

@Contains786

@Created787

@Date788

@DbColumn（Notes数据库）789

@Day789

@DbColumn(ODBC)792

@DbCommand(ODBC)796

@DbExists799

@DbLookup（Notes数据库）800

@DbLookup(ODBC)804

@DbManager808

@DbName809

@DDEExecute810

@DbTitle810

@DDEInitiate812

@DDEPoke813

DEFAULT814

@DDETerminate814

@DeleteField815

@DeleteDocument815

@DialogBox816

@Do817

@DocChildren818

@DocDescendants819

@DocFields820

@DocLevel821

@DocLength821

@DocNumber822

@DocMark822

@DocParentNumber823

@DocSiblings824

@DocumentUniqueID825

@Domain826

@Elements827

@EditUserECL827

@EditECL827

@Ends828

@EnableAlarms828

@Environment829

ENVIRONMENT829

@Exp832

@Error832

@Explode833

@Failure834

FIELD835

@False835

@GetPortsList836

@GetDocField836

@GetProfileField837

@If838

@Hour838

@InheritedDocumentUniqueID840

@Implode840

@IsAgentEnabled841

@Integer841

@IsAvailable842

@IsCategory843

@IsDocBeingLoaded844

@IsDocBeingEdited844

@IsDocBeingRecalculated845

@IsDocBeingMailed845

@IsDocBeingSaved846

@IsDocBeingSaved846

@IsError847

@IsDocTruncated847

@IsExpandable848

@IsMember849

@IsNewDoc850

@IsModalHelp850

@IsNumber851

@IsNotMember851

@IsText852

@IsResponseDoc852

@IsUnavailable853

@IsTime853

@Keywords854

@IsValid854

@Left855

@LeftBack856

@Like857

@Length857

@Ln858

@LowerCase859

@Log859

@MailDbName860

@MailEncryptSentPreference861

@MailEncryptSavedPreference861

@MailSend862

@MailSavePreference862

@Matches865

@MailSignPreference865

@Member867

@Max867

@Middle868

@MiddleBack869

@Min871

@Modified872

@Minute872

@Modulo873

@Month874

@Name875

@No877

@NewLine877

@OptimizeMailAddress878

@Now878

@NoteID878

@Password879

@PickList880

@Pi880

@Platform882

@PostedCommand883

@Prompt884

@Power884

@Random888

@properCase888

REM889

@RefreshECL889

@Replace890

@Repeat890

@ReplaceSubstring891

@Responses892

@Return893

@RightBack894

@Right894

@Round895

@Second896

SELECT897

@Set898

@Select898

@SetDocField899

@SetField900

@SetEnvironment900

@SetProfileField901

@Sin902

@Sign902

@Sqrt903

@Soundex903

@Success904

@Subset904

@Sum905

@Text906

@Tan906

@TextToNumber908

@Time909

@TextToTime909

@Today910

@Trim911

@Tomorrow911

@True912

@Unique913

@Unavailable913

@URLGetHeader914

@UpperCase914

@URLHistory915

@URLOpen917

@UserAccess918

@UserName919

@UserPrivileges920

@UserRoles921

@V3UserName922

@V2If922

@ViewTitle923

@Version923

@Word924

@Weekday924

@Year925

@Yesterday926

@Yes926

@Zone927

8.2ECL安全性相关的@Command929

8.1关于使用@Command929

第八章 Notes公式语言命令参考929

AddDatabase931

AdminCertify932

AddDatabaseRepID932

AdminDatabaseQuotas933

AdminDatabaseAnalysis933

AdminCreateGroup933

AdminCrossCertifyIDFile933

AdminCrossCertifyKey933

Administration934

AdminIDFileSetPassword934

AdminIDFileClearPassword934

AdminIDFileExamine934

AdminOpenAddressBook935

AdminNewOrgUnit935

AdminNewCertifier935

AdminNewOrganization935

AdminOpenServerLog936

AdminOpenGroupsView936

AdminOpenCatalog936

AdminOpenCertLog936

AdminOutgoingMail937

AdminOpenUsersView937

AdminOpenServersView937

AdminOpenStatistics937

AdminRemoteConsole938

AdminRegisterUser938

AdminRegisterFromFile938

AdminRegisterServer938

AgentEdit939

AdminTraceConnection939

AdminSendMailTrace939

AdminStatisticsConfig939

AgentSetServerName940

AgentRun940

AgentEnableDisable940

AgentLog940

AttachmentLaunch941

AttachmentDetachAll941

AgentTestRun941

CalendarFormat942

AttachmentView942

AttachmentProperties942

Compose943

ChooseFolders943

CalendarGoTo943

CreateAgent944

CreateAction944

CreateForm945

CreateFolder945

CreateControlledAccessSection945

CreateEllipse945

CreateRectangle946

CreatePolyline946

CreateLayoutRegion946

CreateNavigator946

CreatePolygon946

CreateTextbox947

CreateSubForm947

CreateRectangularHotspot947

CreateSection947

DesignDocumentInfo948

DebugLotusScript948

CreateView948

DatabaseReplSettings948

DesignFormShareField949

DesignForms949

DesignFormAttributes949

DesignFormFieldDef949

DesignFormNewField949

DesignHelpUsingDocument950

DesignHelpAboutDocument950

DesignFormUseField950

DesignFormWindowTitle950

DesignReplace951

DesignRefresh951

DesignIcon951

DesignMacros951

DesignViewColumnDef952

DesignViewAttributes952

DesignSharedFields952

DesignSynopsis952

DesignViewAppendColumn952

DesignViews953

DesignViewNewColumn953

DesignViewEditActions953

DesignViewFormFormula953

EditButton954

EditBottom954

DesignViewSelectFormula954

DialingRules954

EditCut955

EditCopy955

EditClear955

EditDetach956

EditDeselectAll956

EditDown957

EditDocument957

EditFindNext958

EditFindInPreview958

EditEncryptionKeys958

EditFind958

EditHorizScrollbar959

EditHeaderFooter959

EditGoToField959

EditInsertFileAttachment960

EditInsertButton960

EditIndent960

EditIndentFirstLine960

EditInsertPageBreak961

EditInsertObject961

EditInsertText962

EditInsertTable962

EditInsertPopup962

EditLocations963

EditLinks963

EditLeft963

EditPaste964

EditOpenLink964

EditMakeDocLink964

EditNextField964

EditProfile965

EditPrevField965

EditPasteSpecial965

EditPhoneNumbers965

EditRight966

EditResizePicture966

EditShowHideHiddenChars967

EditSelectByDate967

EditSelectAll967

EditTop968

EditTableInsertRowColumn968

EditTableDeleteRowColumn968

EditTableFormat968

EditUp969

EditUntruncate969

EditUndo969

Execute970

ExchangeUnreadMarks970

EmptyTrash970

FileDatabaseCopy971

FileDatabaseCompact971

FileCloseWindow971

FileDatabaseACL971

FileDatabaseRemove972

FileDatabaseInfo972

FileDatabaseDelete972

FileExport973

FileExit973

FileDatabaseUseServer973

FileFullTextUpdate975

FileFullTextInfo975

FileFullTextCreate975

FileFullTextDelete975

FileImport976

FileNewDatabase977

FileOpenDatabase978

FileNewReplica978

FileOpenDBRepID979

FilePageSetup980

FilePrint981

FileSaveNewVersion982

FileSave982

FilePrintSetup982

FindFreeTimeDialog983

FolderCustomize984

FolderCollapse984

Folder984

FolderProperties985

FolderMove985

FolderExpand985

FolderExpandAll985

FolderExpandWithChildren985

Help986

GoUpLevel986

FolderRename986

FormActions986

FormTestDocument986

HelpIndex987

HelpFunctions987

HelpAboutDatabase987

HelpAboutNotes987

HelpTableOfContents988

HelpReleaseNotes988

HelpKeyboard988

HelpMessages988

HelpRelease3MenuFinder988

InsertSubForm989

HotSpotProperties989

HelpUsingDatabase989

HotSpotClear989

LayoutElementSendToBack990

LayoutElementProperties990

LayoutAddGraphic990

LayoutAddText990

LayoutElementBringToFront990

MailForward991

MailComposeMemo991

LayoutProperties991

MailAddress991

MailRequestNewName992

MailRequestCrossCert992

MailForwardAsAttachment992

MailOpen992

MailSendCertificateRequest993

MailSend993

MailRequestNewPublicKey993

MailScanUnread993

NavigateNextHighlight994

NavigateNext994

MailSendEncryptionKey994

MailSendPublicKey994

NavigateNextUnread995

NavigateNextSelected995

NavigateNextMain995

NavigatePrevMain996

NavigatePrevHighlight996

NavigatePrev996

NavigateToBackLink997

NavigatePrevUnread997

NavigatePrevSelected997

ObjectProperties998

ObjectOpen998

NavigatorProperties998

NavigatorTest998

ObjectDisplayAs998

OpenDocument999

OpenCalendar999

OpenView1000

OpenNavigator1000

PublishDatabase1001

PictureProperties1001

PasteBitmapAsBackground1001

PasteBitmapAsObject1001

RenameDatabase1002

RemoveFromFolder1002

RefreshHideFormulas1002

ReplicatorReplicateSelected1003

ReplicatorReplicateNext1003

Replicator1003

ReplicatorReplicateHigh1003

ReplicatorStop1004

ReplicatorStart1004

ReplicatorReplicateWithServer1004

ReplicatorSendMail1004

ReplicatorSendReceiveMail1004

SectionExpand1005

SectionDefineEditors1005

SectionCollapse1005

SectionCollaPseAll1005

SetCurrentLocation1006

SectionRemoveHeader1006

SectionExpandAll1006

SectionProperties1006

ShowHidePreviewPane1007

ShowHideParentPreview1007

ShowHideLinkPreview1007

TextAlignCenter1008

StyleCycleKey1008

ShowProperties1008

SmartIconsFloating1008

SmartIconsNextSet1008

TextAlignRight1009

TextAlignNone1009

TextAlignFull1009

TextAlignLeft1009

TextCycleSpacing1010

TextBullet1010

TextBold1010

TextNorrnal1011

TextItalic1011

TextEnlargeFont1011

TextFont1011

TextParagraph1012

TextOutdent1012

TextNumbers1012

TextReduceFont1013

TextPermanentPen1013

TextParagraphStyles1013

TextSetFontFace1014

TextSetFontColor1014

TextSpacingOneAndAHalf1015

TextSpacingDouble1015

TextSetFontSize1015

ToolsCategorize1016

ToolsCall1016

TextSpacingSingle1016

TextUnderline1016

ToolsMarkAllUnread1017

ToolsMarkAllRead1017

ToolsHangUp1017

ToolsRefreshSelectedDocs1018

ToolsRefreshAllDocs1018

ToolsMarkSelectedRead1018

ToolsMarkSelectedUnread1018

ToolsRunMacro1019

ToolsRunBackgroundMacros1019

ToolsReplicate1019

ToolsScanUnreadSelected1020

ToolsScanUnreadPreferred1020

ToolsScanUnreadChoose1020

ToolsSmartIcons1021

ToolsSetupUserSetup1021

ToolsSetupLocation1021

ToolsSetupMail1021

ToolsSetupPorts1021

UserIDClearPassword1022

UserIDCertificates1022

ToolsSpellCheck1022

ToolsUserLogoff1022

UserIDMergeCopy1023

UserIDInfo1023

UserIDCreateSafeCopy1023

UserIDEncryptionKeys1023

UserIDSetPassword1024

UserIDSwitch1024

V3EditNextField1024

V3EditPrevField1024

ViewArrangeIcons1025

ViewBelowFolders1025

ViewBesideFolders1025

ViewCertify1025

ViewChange1026

ViewCollapse1026

ViewCollapseAll1026

ViewExpand1027

ViewExpandAll1027

ViewExpandWithChildren1027

ViewHorizScrollBar1027

ViewNavigatorsNone1028

ViewNavigatorsFolders1028

ViewPageDown1028

ViewMoveName1028

ViewRefreshUnread1029

ViewRefreshFields1029

ViewRenamePerson1029

ViewUpDown1029

ViewShowOnlyCategories1030

ViewShowObject1030

ViewShowOnlySearchResults1030

ViewShowFieldHelp1030

ViewShowPageBreaks1031

ViewShowOnlyUnread1031

ViewShowRuler1031

ViewShowOnlySelected1031

ViewShowUnread1032

ViewShowServerNames1032

ViewSwitchForm1032

ViewShowSearchBar1032

WindowMinimize1033

WindowMaximizeAll1033

WindowMinimizeAll1033

WindowMaximize1033

WindowCascade1033

WindowTile1034

WindowRestore1034

WindowWorkspace1034

WindowNext1034

WorkspaceStackReplicaIcons1035

ZoomPreview1035

WorkspaceProperties1035

附录 LotusScriptNotes课程指导1036

第一课 打印数据库题1036

第二课 统计视图中文档的数量1039

第三课 发送电子邮件消息1043