Manning Logo
Home | Ordering Info | Shopping Cart | Manage My Account | Login
Attention customers: online shopping is now available exclusively through our main website: http://www.manning.com. Thank you.
Practical LotusScript

Inside the book

Sample Chapters Table of Contents Errata Index Preface Source Code Author Online

Manning Blog

Why small is sweet?

Author Blogs

Dave Crane more...

Author Calendar

Upcoming Events

Catalog

Java .NET Perl XML All by Subject All by Title

About...

Manning Contact Us Ordering FAQs ebooks Covers Sandbox Forums Distributors Manning Early Access Program (MEAP) Affiliate Program Academia/Publicity User Group Program Press Releases Jobs

Manning Publications Co.
209 Bruce Park Avenue
Greenwich, CT 06830

Practical LotusScript
Anthony Patton

1999 | 512 pages
ISBN: 1884777767
  $43.95 Softbound print book Out of Stock (?)

Index

Symbols

    ! 216
    "" 217
    $File 176
    $UpdatedBy 156, 161
    %END REM 29
    %INCLUDE 34
    %Include 113
    %REM 29
    & 216
    .lss 113
    ?CreateDocument 287
    ?OpenAgent 284, 287
    ?OpenDocument 287
    @DBColumn 275, 295
    @DBLookup 295
    @function 215, 216
    @Functions 275, 276, 283
    @PickList 314
    @ProperCase 276
    @URLOpen 283
    @UserRoles 276
    _ 34
    {} 209, 217
    || 209, 217
    ~ 162

A

    Access Control List 143
    accessor methods 54
    ACL 142, 143, 145, 148, 149, 152
    ACLEntry 304
    action button 181, 295
    Activate 185
    ActivateApp 271, 274
    activity logging 110
    addElement 84
    AddNewLine 166, 167
    AddPageBreak 321
    AddRow 248
    AddTab 166, 167
    AdjustDay 257
    AdjustHour 257
    AdjustMinute 257
    AdjustMonth 257
    AdjustSecond 257
    AdjustYear 257
    agent log 115, 117, 120, 121
    agent.Run 297
    Agents 134, 297
    AllDocuments 48
    AMString 264
    AND 209, 210
    API 271, 273, 282
    apostrophe 29
    Append 91
    AppendParagraphStyle 321, 322
    AppendText 166, 167
    array 56, 61, 64, 65, 66, 68, 70, 71, 74, 79, 80, 81, 83
      multidimension 70
      of objects 55
    As 13
    Asc 196
    attachments 174 -179
    AUTH_TYPE 281
    Author access 143

B

    back slash 104
    back-end classes 57
    base class 53, 60
    beep 114
    binary 87, 89, 97
    binary access 86, 97 -98
    body 176
    Bold 167, 170
    Boolean 73, 83, 126, 128, 230
    braces 209
    breakpoints 6
    browsers 280, 287
      checkbox 4
      pane 4
    button 132
    byte 309

C

    Call 41
    CanCreateDocuments 148
    CanCreatePersonalAgents
    148
    CanCreatePersonalFolders
    148
    CanDeleteDocuments 148
    carriage return 196
    CCur 16
    CDat 16, 253
    CDbl 16
    CGI environment variables 288
    ChDir 100
    ChDrive 100
    checking objects 112
    ChildCount 324
    Chr 28
    CInt 16
    class 46, 48, 49, 50, 51, 52, 56, 59, 61, 309
    ClearAllTabs 322
    Click 132
    CLng 16
    Close 88, 107
    closing a database 137
    collection 75, 76, 78, 82
    color 170
    Comment 297
    commenting code 29
    CommonOwner 297
    ComposeDocument 57
    ComputeWithForm 295, 296, 301
    Connection 241
    ConnectTo 240
    CONST 14
    constants 14, 34
    constructor 51, 61
    contains 160
    CONTENT_LENGTH 281
    CONTENT_TYPE 281
    continuation 34
    Continue 126, 128
    converting
      data types 16
    ConvertToZone 257
    cookies 280
    CopyAllItems 159
    CopyItem 159
    CopyItemToDocument 158, 159
    CreateACLEntry 146, 149
    CreateDocument method 204
    CreateDocuments property 149
    CreateItem 201
    CreateLog 117
    CreateNewsLetter 232
    CreateObject 181, 182, 204
    CreatePersonalAgents 149
    CSng 16
    CStr 16
    CurDir 100
    CurDrive 100
    Currency 13
    CurrencyDigits 264
    CurrentAccessLevel 144
    CurrentDatabase 47, 58, 314
    currentDay 260
    CurrentDocument 57
    CurrentView 313
    CutOffDelete 319
    CutOffInterval 319
    CVar 16

D

    DATABASE 102
    database script 131
    DataType 17, 72
    DateNumber 253
    Dateonly 255
    DateSep 264
    DateTimeValue 162
    Day 253
    DBstsSuccess 244
    debugging 5, 113, 118
    DecimalSep 264
    Declare 272
    Delete 51, 53, 61
    delete 148
    delete objects 185, 186
    DeleteDocuments 149
    DeleteRole 151
    Depositor access 143
    derived classes 49, 53, 60
    destructor 51, 61
    detach 177
    Dim 13, 84
    dimension 65
    Dir 93, 98, 98 -100
    directories 98 -102
    Disabled 319
    DisableRole 152
    Do 20, 78, 91, 92, 93, 106
    doclinks 231
    Document 58
    DocumentCollection 76, 80
    DocumentContext 282
    Domino.Connect 236, 248
    DoNotCatalog 319
    DoScore 231, 232
    DoSubject 231, 232
    Dot notation 47, 61
    Double 13
    drive letter 175

E

    EditMode 129
    Editor access 142
    ElseIf 22
    EMBED_OBJECTLINK
    184
    embedded object 165, 176, 177, 184
    EmbeddedObject 182
    embeddedobject 166
    EmbeddedObjects 186
    embeddedobjects 177
    embedding 180, 199
    EmbedObject 183, 184
    encapsulation 46
    End 23
    EndDateTime 260
    Entering 130, 131, 293
    environment variables 281, 286
    EOF 90
      random access 90
      sequential access 90
    Erase 73
    Erl 113
    Err 113
    errors 5, 113, 119
      checking 122
      handling 116, 244
      messages 113, 120
      numbers 111
      trapping 110
      user-defined 112
    Evaluate 270, 275, 276
    events 124
      Click 132
      entering 130
      exiting 130
      Initialize 124
      ObjectExecute 132
      PostDocumentDelete 132
      PostModeChange 129
      PostOpen 125, 131, 133
      PostPaste 134
      PostRecalc 128
      QueryAddToFolder 133
      QueryClose 128, 132, 134
      QueryDocumentDelete 131
      QueryDocumentUndelete132
      QueryModeChange 128
      QueryOpen 126, 133
      QueryOpenDocument 133
      QueryPaste 134
      QueryRecalc 133
      QuerySave 127, 159, 292
      Terminate 124 -125
      user-defined 134
      WebQueryOpen 129, 287
      WebQuerySave 130, 287
    Excel 199
    Excel spreadsheet 197
    Excel.Sheet.8 197
    Exit 23
    Exit Sub 111
    Exiting 130, 293, 301
    explicit declaration 14
    export 7
      options 8
    ExtractFile 178

F

    field events 131
    field exit event 293
    FieldGetText 293
    fields 130
    file 86, 92
      open 87, 314
      separator 104
    file access 90
      Get 89, 90
      Input 89
      Line Input 89
    file attachments 165, 174
    File Not Found 111
    FileCopy 101
    FileDateTime 101
    FileLen 101
    FileOpenDialog 304
    filepath 182
    files 101
    FileSize 176
    FindFreeTimeDialogEx 316
    FindString 316
    FirstLineLeftMargin 322
    folder 133
    font 170
    FontSize 168
    For 19, 65, 68, 71, 76, 95
    Forall 22, 65, 66, 68, 71, 72, 80, 81, 83, 127, 177, 186, 204, 222, 226, 297
    format 33, 264
    FormatDocument 231
    FormatMsgWithDocLinks
    231
    forward references 308
    forward slash 104
    freefile 87
    FROM 238
    front-end classes 56
    FTSearch 75, 78, 211
    full-text index 75, 78, 208, 216
    function 38, 39, 40, 41, 42, 44, 49, 226

G

    garbage collection 54
    GATEWAY_INTERFACE 281
    GenerateHTML 318, 322
    GenerateHTMLString 318, 322
    Get 89, 90, 94, 98
    get 54
    GetAgent 298
    GetAllDocumentsByKey 211, 212, 213
    GetAttachment 178
    GetDatabase 204
    GetDocumentByKey 211, 213, 295
    GetDocumentsByKey 74
    GetEntry 149
    GetError 242
    GetErrorMessage 242
    GetExtendedErrorMessage
    242
    GetFirstDatabase 102
    GetFirstDocument 76, 77
    GetFirstEntry 323
    GetFirstItem 161
    GetFormattedText 166
    GetItemValue 161
    GetLastDocument 77
    GetNextDatabase 102
    GetNextDocument 76, 77
    GetNextEntry 148, 311
    GetNthDocument 44, 76, 77
    GetObject 186
    GetPrevDocument 77
    GetSelectedText 316
    globals 42
    Gmttime 255
    Goto 24
    GrantAccess 144

H

    handle errors 244
    HasEmbedded 179
    HasItem 81, 112
    hexadecimal 283
    HideDesign 319
    hotspot 132
    Hour 255
    HTML 283, 285, 286, 287, 304, 318
    HTTP_ACCEPT 281
    HTTP_REFERER 281, 283, 285
    HTTP_USER_AGENT 281, 283
    HTTPS 281

I

    IDE 2, 305, 328
    If 22, 78, 83, 106
    IgnoreDeletes 319
    IgnoreDestDeletes 319
    implicit declarations 14, 19
    import 7
    indentifiers 18
    InfoView 305
    inheritance 46
    Initialize 41, 44, 106, 124, 135, 140
    Input 89, 98
    input mode 87
    Input Validation 127, 131, 292
    InputBox 28, 223
    Instr 30, 32, 195
    Integer 13
    InterLineSpacing 322
    InternetLevel 326
    Is 53
    IsA 53
    IsArray 66
    IsAuthors 162
    IsCurrencySpace 265
    IsCurrencySuffix 265
    IsCurrencyZero 265
    IsDateDMY 265
    IsDateMDY 265
    IsDateYMD 265
    IsDST 255, 265
    Isdst 255
    IsElement 73, 221
    IsEnabled 297
    IsEncrypted 162
    IsFTIndexed 208, 217
    IsList 73
    IsNames 162
    IsNewDoc 126
    IsObject 53
    IsProtected 162
    IsPublic 297
    IsReaders 162
    IsRoleEnabled 152
    IsSigned 162
    IsSummary 162, 170, 222
    IsTime24Hour 265
    italics 167, 170
    Items 79

K

    Kill 101

L

    label 111
    LastRun 297
    layout regions 327
    Lbound 66
    LCase 29, 30
    Left 30, 32
    LeftMargin 322
    Len 29, 31, 95
    Level 148
    line feed 196
    Line Input 89
    linked object 180, 184
    lists 71, 72, 74, 82, 84
    ListTag 71, 72, 74
    LOC 90
      random access 90
      sequential access 90
    Localtime 255
    LOF 90
    Log 114, 116
    LogAction 115, 118, 119, 120
    LogError 115, 119, 120
    logging 110, 119
      activity 114
      email 118
      errors 118
      Notes database 117
      script activity 120
      text file 118
    logical operators 209
    Long 13
    looping 19
    Lotus SmartSuite 174
    LotusScript
      Data Object 236
      Extensions 113, 236
    LS:DO 191, 236 , 237, 246, 248
    LSCONST.LSS 34, 343
    lsconst.lss 113
    LSERR.LSS 34, 345
    lserr.lss 113, 114
    Lsgmttime 255
    LSLocalTime 255, 260
    LSX 239, 240, 248
    LSXBEERR.LSS 350
    lsxbeerr.lss 113
    LSXODBC 239
    LSXs 236
    LSXUIERR.LSS 356
    lsxuierr.lss 113
    LTrim 29, 31
    lxbeerr.lss 114

M

    Manager 144
    Me 49, 50
    MessageBox 25, 27, 28, 34, 224
    methods 46, 49, 51, 56, 61, 102
    Microsoft
      Access 237
      Excel 174, 179, 190, 196, 198
      Office 174, 180, 190
      Office 97 191, 197
      Outlook 190, 200
      PowerPoint 190, 200
      Word 181, 182, 190, 191, 193, 194, 275
    Mid 29, 30, 196
    Minute 254
    MkDir 100
    Month 253
    MQSeries 248
    MsgBox 25, 40
    mulitdimensioned array 70
    multidimensional array 69
    multivalued arrays 84

N

    NeverReplicate 319
    New 52, 61
    newsletter 215, 230
    NextRow 245
    No Access 143
    NOI 46
    NOT 209
    Notes 5.0 303 -328
    NotesACL 143, 145, 146, 148, 149, 150, 151, 153, 304, 326, 358 -360
    NotesACLEntry 145, 147, 148, 150, 151, 152, 153, 326, 360 -363
    NotesAgent 296, 297, 298, 301, 304, 325, 364 -366
    NotesColor 169
    NotesDatabase 43, 58, 68, 74, 75, 117, 143, 145, 146, 157, 208, 214, 216, 297, 298, 313, 314, 320, 366 -377
    NotesDateRange 260, 266, 377 -378
    NotesDateTime 216, 252, 255, 256, 258, 259, 262, 265, 378 -380
    NotesDBDirectory 102, 103, 381
      methods 102
    NotesDocument 58, 68, 77, 79, 81, 112, 157, 161, 163, 177, 178, 223, 282, 284, 288, 295, 324, 382 -390
    NotesDocumentCollection
    44, 48, 68, 74, 77, 78, 208, 211, 213, 215, 216, 315, 317, 323, 390 -393
    NotesEmbeddedObject 164, 174, 175, 178, 179, 184, 185, 197, 393 -395
    NotesFont 168
    NotesForm 395
    NotesInternational 252, 264, 397 -400
      creating object 265
    NotesItem 79, 81, 155 -171, 247, 400 -404
    NotesLog 115, 116, 118, 119, 120, 121, 404 -407
    NotesName 407 -410
    NotesNewsLetter 220, 230, 231, 233, 411 -412
    NotesOutline 304, 309, 311, 312, 314, 328, 412 -415
    NotesOutlineEntry 304, 311, 312, 313, 415 -417
    NotesPump 329 -341
    NotesRegistration 417 -422
    NotesReplication 304, 318, 319, 422 -425
    NotesRichTextItem 163, 164, 165, 166, 170, 171, 176, 179, 183, 205, 425 -427
    NotesRichTextParagraphStyle 304, 321, 427 -429
    NotesRichTextStyle 167, 170, 171, 429 -431
    NotesRichTextTab 321, 431
    NotesSession 57, 68, 117, 204, 232, 313, 432 -437
    NotesSQL 236, 248, 249
    NotesTimer 437
    NotesUIDatabase 304, 314, 320, 325, 438
    NotesUIDocument 57, 58, 80, 126, 127, 128, 129, 135, 181, 182, 184, 186, 293, 294, 295, 316, 439 -447
    NotesUIView 133, 304, 324, 447
    NotesUIWorkspace 57, 288, 304, 313, 315, 316, 448 -454
    NotesView 58, 74, 212, 295, 313, 323, 454 -460
    NotesViewColumn 460 -465
    NotesViewEntry 304, 323, 324, 465 -467
    NotesViewEntryCollection 304, 323, 324, 467 -470
    NotesViewNavigator 470 -473
    Nothing 78, 186
    Now 252
    NPActivity 331
    NPConnect 332
    NPField 336
    NPFieldList 333
    NumActions 119
    NumErrors 120

O

    Object 204, 309
    object browser 190
    ObjectExecute 132
    object-oriented 46, 48, 54
    ObjectView 305
    ODBC 236, 237, 239, 240, 244, 249
      LSX 248
    ODBCConnection 237, 239, 240, 241, 242, 244
    ODBCQuery 237, 241, 242
    ODBCResultSet 237, 242, 245, 248
    OLE 164, 171, 179 -184, 190, 191, 194, 199, 201, 202, 203, 205
      Automation 180
      object 186, 192
      registry 182
    On Error 111, 114, 244
    On Error Resume 151
    On Event 134, 136, 140
    onHelpRequest 327
    Open 86, 113
    Open AgentLog 120
    Open DataBase Connectivity 236
    OpenFileLog 118
    opening a database 137
    OpenMailLog 118
    OpenNavigator 325
    OpenNotesLog 117
    OpenView 325
    Option Base 15
    Option Compare 15
    Option Declare 16
    Option Explicit 14
    Option Public 16
    Options 15, 113, 300
    OR 209, 210, 228
    Oracle 236, 248
    outline 310
    Outlook 201, 202
    Output 91

P

    parameter 39
    PassThruHTML 321
    PATH_INFO 281
    PATH_TRANSLATED 281
    PickList 304, 314
    PickListCollection 315
    PMString 265
    position 322
    PostDocumentDelete 132
    PostDragDrop 327
    PostModeChange 129
    PostOpen 125, 131, 133, 134, 135, 136
    PostPaste 134
    PostRecalc 128
    PostSave 327
    Preserve 56, 67, 71, 84
    Print 7, 25, 89, 280
    printing 8
      scripts 305, 307
    Priority 319
    Private 18, 39, 49, 54, 61, 226
    Prompt 304, 315
    property 46, 47, 49, 54, 56, 61
    Property Get 54, 55, 61, 226
    Property Set 54, 55, 226
    Public 19, 39, 49, 54, 61
    Put 90, 94

Q

    Query 297
    Query_String 280, 281, 283, 284, 285, 287
    QueryAccess 145, 146
    QueryAddToFolder 133
    QueryClose 128, 132, 134, 136
    QueryDocumentDelete 131
    QueryDocumentUndelete
    132
    QueryDragDrop 326
    QueryExecuteTimeOut 241
    QueryModeChange 128, 129
    QueryOpen 126, 133, 135
    QueryOpenAgent 287
    QueryOpenDocument 133
    QueryPaste 134
    QueryRecalc 133
    QuerySave 127, 134, 135, 159, 292, 301
    QuerySaveAgent 287

R

    random 87, 89
    random access 86, 88, 90, 94 -96, 97, 106
      versus sequential 94
    Read 87
    Reader access 143
    reading files 89, 98
    Redim 67, 68, 69, 71, 84
    REMOTE_ADDR 281
    REMOTE_HOST 281
    REMOTE_IDENT 281
    REMOTE_USER 281
    remove 185
    RemoveItem 158
    REPLICA_CANDIDATE
    102
    replication 318, 320
    reports 220, 222, 226, 230
      generation 224
    REQUEST_METHOD 281
    Reset 319
    response documents 76
    Resume 111
    Resume Next 111
    RevokeAccess 145
    Rich Text 81, 84, 164, 165, 166, 167, 170, 174, 175, 183, 184, 193, 198, 199, 205
    RichTextItem 164
    RichTextStyle 164
    Right 30, 32
    RightMargin 322
    RmDir 100
    Roles 150, 153
    Round 38
    RTrim 30, 31
    RunOnServer 298, 299, 301

S

    SAP 248
    Save 146, 319
    SaveOptions 222, 224
    scope 42, 49, 61, 114
    script libraries 42, 224, 299, 300, 306
    SCRIPT_NAME 281
    search 78
      database 213
      string 209
    Second 255
    Seek 94
    SELECT 238
    Select Case 23
    Send 205
    sequential 87, 88, 89, 96
      access 89, 90, 91 -94
    SERVER_NAME 281, 285
    SERVER_PORT 282
    SERVER_PROTOCOL 282
    SERVER_SOFTWARE 282
    SERVER_URL_GATEWAY_INTERFACE 282
    ServerName 297
    Set 52, 61
    set method 54
    SetAnyDate 257
    SetAnyTime 257
    SetNow 256, 258
    SetTabs 322
    Shared 87
    Shell 270, 271
    Single 13
    source 131
    SpacingAbove 322
    SpacingBelow 322
    SpellCheck 316
    SQL 236, 238 -239, 241, 244, 247, 248
    StartDateTime 260
    static 18, 19, 39, 54
    StdR4AgentLog 117
    Stop 6
    strikethrough 168, 170
    strings 13, 29 -33, 222
    STYLE_NO_CHANGE 169
    subclassed 53
    subform 125
    SubjectItemName 231, 232
    Submit 287
    subroutine 38, 40, 41, 42, 44, 49, 50

T

    Tabs 322
    TEMPLATE 102
    TEMPLATE_CANDIDATE 102
    Terminate 41, 44, 124, 140
    Text 260
    text files 91
    ThousandsSep 265
    threads 309
    tilde 162
    Time 252
    TimeDifference 258
    TimeNumber 253
    Timeonly 255
    TimeSep 265
    TimeValue 253
    Timezone 255, 265
    Today 252, 265
    Tomorrow 265
    Trim 29, 31
    Type 177
    TypeName 17, 72

U

    Ubound 66, 79
    UCase 29, 30
    UML 48
    underline 167, 168, 170
    UnderScore 34
    UniformAccess 153
    UnprocessedDocuments 75
    UnprocessedFTSearch 75, 213, 214, 216
    UnprocessedSearch 75, 215, 216
    UpdateAll 215
    UpdateFTIndex 216, 217
    Use 300
    Uselsx 244
    Uselsx "*LSXODBC" 239
    user-defined
      errors 112
      events 136

V

    value arrays 84
    variant 13, 14, 17
    VBA 201
    vertical bars 209
    view 133
    visibility 42
    Visual Basic 180, 190, 192, 204

W

    watching variables 6
    web events 130
    Web Navigator 287
    WebQueryOpen 129, 280, 287
    WebQuerySave 130, 280, 287
    WeekDay 254
    wend 21
    WHERE 238
    While 21, 148
    Windows API 274
    Windows/DOS separator 105
    With 50, 51, 53, 56, 61, 106, 204, 205, 319
    With/End 50
    Word 193, 196
    Word.Document.8 192
    Write 87, 89
    writing 89

Y

    Y2K 252, 261, 266
    Year 254
    Yesterday 265

DESCRIPTION

Practical LotusScript covers the LotusScript programming language like no other book on the market. It starts with the core languge and proceeds to cover the specifics of Lotus Notes in complete detail. Advanced topics include report generation, working with the web, Office 97 integration, and 5.0 enhancements.

Practical LotusScript is designed for:

  • Lotus Notes developers, both experienced and inexperienced
  • Visual Basic programmers looking to get up to speed in the Notes environment
  • any developer wanting more information on the Notes/Domino development environment

ABOUT THE AUTHOR...

Anthony Patton has worked with Lotus Notes for more than five years and is a both a Certified Lotus Principle Application Developer and System Administrator. He is the president of BaseLine, Inc. which specializes in custom and commercial software development.
Home | Catalog | Privacy Policy | About Manning

© 2003-2006 Manning Publications Co.