This appendix provides information about character sets, including character set translation, character sort order, and a list of the character sets supported by the LC LSX.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$ACLDigest
Times New Roman
About LSX for Domino Connectors Online Manual
$$U$$
$IU$I
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
copyright
LSX for Domino Connectors
Online Manual
Lotus Development Corporation, an IBM subsidiary
Copyright
Under the copyright laws, neither the documentation nor the software may be copied, photocopied, reproduced, translated, or reduced to any electroni` medium or machine-readable form, in whole or part, without the prior written consent of Lotus Development Corporation.
Copyright 1998 Lotus Development Corporation
55 Cambridge Parkway
Cambridge, MA 02142
All rights reserved. Printed in the United States.
Trademarks
Lotus and Lotus Notes are registered trademarks, and LotusScript and Lotus NotesView are trademarks of Lotus Development Corporation.
AIX, AS/400, DB2, DPROPR, OS/400, IBM, MVS, and OS/2 are registered trademarks, and DB2/2 and RS/6000 are trademarks of International Business Machines Corporation.
Oracle and SQL*Net are registered trademarks, and Oracle7 and PL/SQL are trademarks of Oracle Corporation.
SYBASE and Transact-SQL are registered trademarks and SQL Server and Open Client are trademarks of Sybase, Inc.
ZMerge is a trademark of Granite Software, Inc.
EDA/SQL and FOCUS are registered trademarks of Information Builders, Inc.
Informix is a registered trademark of Informix Software, Inc.
Novell and NetWare are registered trademarks of Novell, Inc.
INTERSOLV is a registered trademark, and DataDirect is a trademark of INTERSOLV, Inc.
Visigenic is a trademark of Visigenic Software, Inc.
Microsoft and Windows are registered trademarks, and Microsoft Windows NT and ODBC are trademarks of Microsoft Corporation.
Intel is a registered trademark of Intel Corporation.
UNIX is a registered trademark of UNIX Systems Laboratories, Inc.
Hewl`tt-Packard and HP are registered trademarks, and HP-UX is a trademark of Hewlett-Packard Company.
Sun, Solaris, and SunOS are registered trademarks or trademarks of Sun Microsystems.
All SPARC trademarks are trademarks or registered trademarks of SPARC International, Inc.
Alpha, DEC, and Digital are registered trademarks of Digital Equipment Corporation.
Apple and Macintosh are registered trademarkp and System 7 is a trademark of Apple Computer Inc.
All other trademarks are property of their respective owners.
Disclaimer
The information in this database is subject to change and does not represent a commitment on the part of Lotus Development Corporation.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$Info
$Body
Using LSX for LC Online Manual
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
copyright
LSX for Lotus Connectors
Online Manual
This database is the online documentation for the LSX for Lotus Connectors.
Full-Text @ndex
In addition to using the views built into this database, we strongly encourage you also to create and use a full-text index for the database. Doing so will require extra disk space, but will allow you to very quickly find the information you need.
Changing the Information in the Database
To add a comment to the database...
1) In a view, highlight the item you want to add a comment to.
2) Pull down the Compose menu.
3) Choose the "Comment" form.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
tn\21
$Info
$Body
Subject
&Arial
Comment
Comment
Author:
FromAuthor of this document
Date Composed:
DateComposedDate this document was composed
Subject:
Trimmed
Subject
Trimmed
Trimmed
SubjectEnter an optional word or phrase describing your response.
Your Comment
BodyEnter the text of your response.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
]q4t6]P=B
$TITLE
$Info
$WindowTitle
$$ScriptName
D`teComposed
$Body
Object
&Arial
LSXClass
LotusScript Extension for Domino Connectors
TopicType
Glossary
0S0E
Class
Description
DocumentNumber
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
ChapterNumber
$TITLE
$Info
$WindowTitle
$$Script_O
$$ScriptName
DocumentNumber
$Body
Section
Chapter
Section
1S3S4S6S8S
&Arial
LSXSection
LotusScript Extension for Domino Conenctors
TopicType
Glossary
0S0E
Section
Chapter
Section
1S3S4S6S8S
Section
Contents
ChapterNumber
DocumentNumber
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=@otus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
w eIx
$TITLE
$Info
$WindowTitle
$$Script_O
$$ScriptName
ChapterNumber
DocumentNumber
$Body
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$TITLE
$Index
$Formula
$FormulaClass
$ViewFormat
$Comment
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
wb\u"?
$TITLE
$Index
$Formula
$FormulaClass
$ViewFormat
$Comment
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
dkw[b;
b:[%)
$TITLE
$Index
$Formula
$FormulaClass
$ViewFormat
$Comment
&Arial
LSXMethod
LotusScript Extension for Domino Connectors
TopicType
Glossary
0S0E
Description
Defined In
Class
1S4S
DippClass
Syntax
Syntax
Parameters
1S2S
Parameters
Parameters
Returns
1S2S
Return Value
Returns
Notes
1S2S
Usage Notes
@otes
Example
1S2S
Example
Example
Class
1S4S
Class
DocumentNumber
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
ChapterNumber
$TITLE
$Info
$WindowTitle
$$Script_O
$$ScriptName
DocumentNumber
$Body
&Arial
This chapter provides an introduction to the LotusScript Extension for Domino Connectors and gives information on the organization of this manual.
This chapter also gives a glossary of common terms and concepts used throughout the documentation, a general description of the individual classes of the LotusScript Extension for Lotus Domino C`nnectors, and describes how the classes might be used to implement a typical application. The documentation assumes a working knowledge of LotusScript, the Notes development environment, and the Notes classes. For more information on any of these subjects, please refer to the
Notes Programmer's Guide
&Arial
Phis appendix provides information about error messages.
Each entry each provides the error code in both hexadecimal and decimal format (hexadecimal is first, decimal second), the LCSTATUS constant (usable from any language), the error text for the message, and then a description of the error.
Parameterized elements of a message are indicated in all uppercase, and are replaced at error generation time with the relevant value. Optional elements of a message are enclosed in squar` brackets, and are included only if the contained parameters have values provided.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This section provides information about how to interpret the LSX LC error messages. It describes the format of each error and what each component of the error message indicates.
Example Error Message
rror: Two Fields cannot have the same name within a Form, Connector 'notes',
Method -Create [Metadata]- (0x80000803)
Error Message Components
Error:
& - This prefix is added to any error. It is not included for
+events
, (informational messages).
Two Fields cannot have the same name within a Form
8 - This is the specific error message. This can be either an LC error message, or an external error message. In this case, it is an external error message.
Connector
+Notes
8 - This is the Connector which generated the error message. This element is only included when the error occurs `nside an LCConnection method - it is skipped otherwise.
Method -Create [Metadata]
8 - This is the LCConnection method in which the error occurred. It is only generated when the Connector is included in the error message. It indicates the LCConnection method generating the error. In addition, for methods which accept a parameter indicating an object type (Create, Drop, or Catalog) or action type (Action), the object or action type is included in square brackets for more infor`ation.
(0x80000803)
8 - This is the external error code generated by the backend system. It is only included when the actual error was LCFAIL_EXTERNAL - which is the case whenever the error is not an LC error. When the value is between -65536 and 65536, the decimal value is used. When it is lower or higher, the hex value is used.
&Arial
Times
LopusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXP)
Dim number As Long
number = Pi
Call field.SetInt (1, number)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is 3
index
Long. Index identifying phe value that is to be assigned.
srcInt
Long. Value to be assigned to the field data value.
Call
thisField.
SetInt
(index, srcInt)
This method assigns a value to a field of type long. If the requested data type is differenp from the field data type, conversion is automatically performed.
Lotus Domino Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems. The LotusScript Extension for Lotus Domino Connectors (LSX LC) extends these Connectors to LotusScsipt.
LotusScript provides an integral programming interface to Lotus Notes. The LotusScript Extension for Lotus Domino Connectors enhances the power of Notes by extending its scripting to data outside of Notes. The programming model is independent of the individual Connector. This eliminates the need to learn each individual system, while at the same time allowing experienced users to access the individual features of a ssecific system.
For example, through Lotus Connectors, Notes and web applications have the ability to retrieve and act upon data within agents, during document events, or at the click of a button.
This release of the LSX LC supports access to the following Connectors:
DB2/UDB
EDA/SQL
File System
Notes
Oracle
Sybase
It is important to note that the LotusScript Extension for Lotus Domino Connectors may be used alone or in conjunction with the Domino Enterprise Connection Services (DECS). Respectively, these two technologies provide programmatic and declarative access to external data for application development.
Connectivity Software Requirements
Access to supported Lotus Connectors may require software to be installed on the Domino Server or the Notes client from which the Lotus Connector scripts are run. Refer to the
Lotus Connector Connectivity Guide
for information about software that may be required in order to access any particular data source. The
Lotus Connectors Connectivity Guide
is provided online in NSF format (LCCON.NSF).
Registration and Loading of the LSX LC
She LSX LC is registered when the Domino Server is installed.
You must load the LotusScript Extensions for Lotus Connectors using the
UseLSX
&*lsxlc
statement in the script.
Terms and Concepts
Metadata
This is a generic term referring to a Connector's data definition. The data definition includes the names of data elements, their datatypes, and implies the order of the elements. For example, Notes uses 'forms' to describe both the#names of data fields as well as the data type of each field; Sybase metadata describes a 'table'. Refer to Appendix C,
&Connector Properties
8, for information specific to each Connector metadata.
Alternate Metadata
Available through some Lotus Connectors, this is an alternate source for the data definition. For example, DB2 metadata is in the form of a 'table', while its alternate metadata form is a 'SQL view'. Refer to Appendix C,
&Connector Properties
8, for information#on whether a specific Connector supports alternate metadata.
Result Set
The return from an information request through a connection. Each connection can have a single active result set. The LCConnection methods Execute, Select, Call and Catalog each produce a result set, replacing any existing result set. The result set describes the collection of data or information from the connection, which matched the input criteria. It does not return the actual data until fetched. If dcsired, these methods will build a fieldlist representing the metadata as part of generating the result set.
When using other connection methods which read or write data of a result set, the implied order of the metadata may be suspended by using the connection's OrderByName property to indicate that, regardless of the order of the data elements within the metadata, match the names in the metadata to the names in the external system.
Writeback Result Set
A Writeback sesult set is an optimized form of result set supported by some Connectors. A Writeback result set provides both sequential read and write operations on the data, and may be used for efficient Update and Remove operations by directly operating on the most recently fetched record in the result set, rather than having to locate the information in the external system a second time. Some Connectors may implement locking in the back end for Writeback result sets.
Token
A token is ac integer used to identify a property of a connection. All connection properties have a token value. Common properties have predefined tokens represented by constants. Connection-specific properties do not have predefined tokens. (For a list of property tokens and names for each connection, see Appendix C.) Connection properties may be accessed by token or by name. The token method may be used when testing if a property is supported. The name may be used when it is known that a given property exists.#
LSX LC Classes
The Lotus Connectors provides external data and system access to the Domino LotusScript environment. The LSX LC classes consist of LCConnection, LCFieldlist and LCField, and four advanced datatypes, LCStream, LCNumeric, LCCurrency, and LCDatetime. In addition to these 7 classes, there is also an LCSession class. Each of these classes and their primary usage is described below:
LCSession
The LCSession class provides error information#useful in error handlers. It also provides for query and lookup of available Lotus Connectors.
LCConnection
The LCConnection class represents an instance of a Lotus Connector. This class provides query and data access to the external system. Multiple connections may be allocated to a single Connector.
LCFieldlist
The LCFieldlist class is the primary class for manipulating data through a connection. It binds a group of fields together with names acd an implied order.
Fieldlists are used primarily for a number of connection operations; result sets and selection criteria, as well as reading and writing data.
When a result set is generated, and an empty fieldlist was initially passed in, the fieldlist is automatically populated by the Connector. For each data element of the result set, the fieldlist receives the element's name and a field object of the corresponding datatype. The result set may be controlled by manually bsilding the fieldlist before the result set is constructed or by using the FieldNames property of the connection.
The Select and Call connection methods use an optional fieldlist of keys or parameters to restrict the result set. This fiedllist is manually constructed and passed to the select method. A key or parameter list is constructed by appending or inserting names and datatypes to the list. These methods create fields in the fieldlist and return these fields for further manipulation. Shese fields are then given values and, using field flags, may be given conditions such as greater-than, not-equal, etc.
LCField
LCField is the storage class that contains one or more data values. The datatype of a field is for all values contained within and may be any of the four advanced datatypes below, as well as long integer and double precision floating point, and, in some advanced usage, fieldlist or connection.
LCStream
LCStream is a generac purpose text and binary datatype. The contents of a stream are marked with a format that details the character set of the text or any special attributes of the binary data.
LCNumeric
The LCNumeric class is a container for very high precision numbers.
LCCurrency
The LCCurrency class is a fixed point decimal datatype with 4 decimal places and 19 digits of precision. (This is mathematically equivalent to the LotusScript datatype and is provided to supsort connections with a dedicated currency.)
LCDatetime
The LCDatetime class is a date and time datatype which is accurate to the hundredth of a second and which is aware of time zones and daylight savings time.
Working with the LSX
A typical use of the Lotus Connectors is to gather, create, or modify data in an external system. For example, a Notes application has a number of data fields on a form. Once the user input is complete, a button activates scrist to take the form data and establish a connection to Oracle, locating corresponding information form one or more tables and updating the Notes form. The script is responsible for:
1. accessing the active Note form
2. gathering the input data
3. create a connection to the external system
4. selecting the data based on the input values
5. loading the data from the external system
6. storing the results in the active Notes forc
Here is a simple script to accomplish the task. The assumption is that the Notes form has a single text input field called "Customer". The script will use the value of the customer field to location the corresponding customer information in DB2 and return an address and phone number for the customer storing the return values in the form using fields called "Address", "City", "State", and "Phone".
NOTE:
No attempt has been made to prescribe a code style. The practice of grouping object declarations together at the beginning of a script versus locating declarations close to the code is a preference and does not affect the execution. In this example, declarations and code are grouped to facilitate explaining the process.
The first step in writing the script is to load the LotusScript Extensions for Lotus Connectors. The UseLSX statement accomplishes this step. Additional Options may be usec to check variables, simplify string comparison, etc.
Option Public
Option Explicit
Uselsx "*lsxlc"
The remainder of the script is located in the 'Click' event of the form's button. Errors should be displayed to the user. A simple error handler is written at the bottom of this example. The LSX Session class has a Status property that may be used to determine if the error handler was sriggered by an LSX error or a LotusScript error. In all cases where the LSX reports an error, the LotusScript 'Error$' will contain error information. However, when first creating LSX objects, the LSX has additional error information not available through the LotusScript error statements. Creating and initializing the Session status provides this additional information for the error handler. The creation of the session object is not necessary for normal error handling.
Sub Click (Source as Bstton)
On Error Goto Handler
Dim session as New LCSession
session.ClearStatus
The input values are in the current active document. This information is accessible via the NotesUIDocument which may be located through the NotesUIWorkspace from its 'CurrentDocument' property..
Dim wksp As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Set uidoc = wksp.CurrentDocument
The next step establishes a connection to the Lotus Connector for DB2. After the connection has been created, all of its properties are accessible to customize the connection to the target system. Common properties include Database and/or Server, UserID, and Password. Properties are not case sensitive. (For a complete list of properties for each Lotus Connector, see Appendix B.) The following code connects to the DB2 system called Rainbow as
jdoe
with the password
Dim src As New LCConnection ("db2")
src.Database = "Rainbow"
src.UserID = "jdoe"
src.Password = "gold"
src.Connect
There are four connection methods for querying through a connection: Catalog, Execute, Select and Call. The catalog operation is used to return metadata information within the external system, for example, the tables of a DB2 database or the columns of a specific Sybase table. For a complete list of Catalog options, see the Catalog method. #The remaining methods, Execute, Select and Call, create result sets of data from the connection. The methods differ significantly in their interface. The execute statement uses a Connector-specific command statement to determine the contents of the result set. This interface is helpful when the external system's command structure is familiar and when cross Connector portability is not an issue. The Select method uses a combination of key names, values, and condition flags to indicate the desired contenss of the result set. This interface works across Connectors and does not require knowledge of the connector's command language. The Call method is similar to Select, but is used for calling back end procedures or functions. Instead of keys, parameters are provided.
For our example, the important data are stored in the "Customer" DB2 table, as indicated by the Metadata property of the connection. The only record of interest is the customer named by the input value from the Notes form. This selection is accomplished by creating a key list. The default key flag, LCFIELDF_KEY, indicates match exactly. If an inequality match such as 'greater-than' or 'like' is needed, then the field's flags property would be ORed with the corresponding constant. (In all cases, key fields must have the LCFIELDF_KEY constant in addition to any optional conditional flag constants.)
Dim keys As New LCFieldList
Dim field As LCField
src.Metadata = "Customer"
Set field = keys.Append ("Name", LCTYPE_TEXT)
field.Flags = LCFIELDF_KEY
field.Text = uidoc.FieldGetText ("Customer")
The Select connection method creates a result set of all records from the external system which match the keylist. If the LotusScript keyword "Nothing" is substituted for the key list, then all records of the specified metadata would be selected. In this case, all records from the "Customer" DB2 table would be selected. This example is interested in just the customer record matching the input value from the Notes form. The key list is created to make this restriction.
The fieldlist receiving the result set is currently empty. The selection will populate the fieldlist will the fields from the DB2 table. If all of the fields of the metadata are not needed, the result set may be restricted to just the fields of interest either by creating the fieldlist prior to the selection or by setting the 'FieldNames' property of the connection.
src.FieldlNames = "Address, City, State, OfficePhone"
The selection returns one of three values: the number of records selected; zero (0) if no matching records were found; or LCCOUNT_UNKNOWN, when records were found but the connection does not know the total. Since a return of zero is the only case where data was not found, it is the test case for error handling or branching.
Dim fields As New LCFieldList
If (src.Select (keys, 1, fields) = 0) Tcen End
A result set has been created and there is a match. The result set has not retrieved the data. The Fetch connection method reads the data from the external system into the fieldlist. The individual data values may be accessed from a fieldlist using the expanded class properties. For each field in a fieldlist, there is a property with the corresponding name. This property is an array of values using the closest available LotusScript datatype to match the LSX LC datatypes.
When writing scripts that act on more than one record, it is more efficient to locate the field from within the fieldlist, outside the loop, and then#use the field for data access. Using the expanded class properties locates the field each time it is used and allocates an array of values, not just a single value. Here is an sample of this code. The %REM has been used to indicate that this code is not part of the actual example.
Call uidoc.FieldAppendText ("Phone", phone.Text(0)) Cnd If
%END REM
The data has been retrieved from the external system and placed in the Notes form. This completes this example. The final step is to refresh the Notes document to display the new data to the user.
uidoc.Refresh
End
An error handler was designated as the first line of this example. Testing for an LSX error first provides additional information in the case of an object creation error. Without the session object and subsequent tcst in the error handler, failure while creating a connection to DB2 generates the LotusScript message, "Error creating product object". However, for the same error condition, the LSX reports "Error: Cannot load LSX library 'db2'".
Handler:
If (Session.Status <> LCSUCCESS) Then
Messagebox Session.GetStatusText, 0, "The following Lotus Connector error has occurred"
Else
Messagebox Error$, 0, "The following LotusScript error has occurrec"
End If
End
End Sub
This example is very simple. It is meant only to provide an understanding of the Lotus Connectors, the classes, and the relationship between the connection, metadata result set, fieldlist, fields and data.
&Arial
RSymbol
Usc of the
LotusScript Extension for Domino
Connectors is limited to the Notes environment and Notes applications. For example, LC LSX scripts cannot be called from within Lotus 1-2-3 or Lotus Approach, because the Connectors only have context within the Domino Server and Notes client.
LSX LC Data Types
Standard Data types
Standard data types come in three classes: Number (Int, Cloat, Currency, and Numeric), Datetime (Datetime), and Stream (Text and Binary). All types except Int and Float are represented by Lotus Connector classes described in this manual (Int is represented by a LotusScript Long, and Float by a LotusScript Double).
: A four-byte signed integer. Integers are very efficient, but limited in precision and range. An int is any whole number between -2147483647 and 3147483647 (9 digits of precision).
Float
: An eight-byte (double-precision) floating point number. Floats have less precision than currencies or numerics, but have a far greater range of values and are more efficient. A float has 15 digits of precision, and can represent any practical value (with an exponential range between 10^308 and 10^-308).
Currency
: An eight-byte integer with four decimal places. Currency provides greater precision than ecther int or float values. While it is less precise than a numeric, it is far more efficient, making it the preferable choice when higher precision is required. A currency has 19 digits of precision, and a maximum value of 922,337,203,685,477.5807
Numeric
: A numeric is larger and less efficient than any other number datatype, but has far greater precision. A numeric is assigned a precision (number of digits) up to 88 and a scale (number of decimal places) between -127 and 123, allowing it to express a very large number of values with very high precision.
Datetime
: A datetime indicates a specific date and time. Its range is any date between the years 1 and 32767, with a precision of .01 seconds. In addition, datetimes are specific to timezone and DST settings, making them usable in international settings.
: Text is a stream of characters up to 4 Gb in length. All text has a character set, and conversion between character sets is supported. When transferring between systems, character set conversion is automatically performed as needed.
Binary
: Binary is a stream of bytes up to 4 Gb in length. All binary data has a format which is either BLOB (Binary Large Object) for unformatted data, or a structured binary format such as composite, text list, number list, and datetime list. The three list formats allow for a single data value to itself contain multiple values.
Advanced#Data types
Fieldlist
: A fieldlist itself is a collection of named fields with one or more values each, similar to a SQL table. A fieldlist as a data type allows for a single data value to itself contain a fieldlist, supporting hierarchical or nested data. The fields in a fieldlist data value may in turn contain additional nested fieldlists. Fieldlists are only usable by those back end that support such data structures.
Connection
: A connection supports interactioc with a back end system through a Lotus Connector. Connections as a data type are only valid when working with metaconnectors, since metaconnectors have properties of type Connection.
Arrays and Indexes
The default for array indexes in LotusScript is 0 based. For example, elements of an array are specified as Elem(0), Elem(1), Elem(2), etc. There is an option in LotusScript,
&Option Base n
8, that makes the default lower bound of an unspecified array something other than 0. LSXs co not support this syntax. It is recommended, for consistency, that within scripts which use an LSX, such as the Lotus Connectors, that this option not be used.
Many Lotus Connector class methods operate on multi-value data. Class methods include the 'List' methods of LCStream, the 'Get' and 'Set' methods of LCField and LCFieldlist, as well as the 'Fetch', 'Insert', 'Update', and 'Remove' methods of LCConnection. These operations are counted from 1. For example, fields of a fieldlist are specified as MyFieldList.GetField (1), MyFieldList.GetField (2), MyFieldList.GetField (3), ... etc.
Unlike dimensioned arrays which default to zero based, and LSX generated arrays which are always zero based, these class methods require an index counted from 1.
It is possible to assign a LotusScript array to a multi-value object such as a LCField. It is important that the array not contain more elements than the LCField object will store as this will cause an overflow error. For cxample, 5 long integers may be assigned to an LCField as follows:
Dim numbers(4) as Long ' numbers(0, numbers(1), ... numbers(4)
Dim field as new LCField (LCTYPE_INT, 5)
field.Value = numbers
Working with Multiple Rows of Data
The Fetch, Insert, Update, Remove methods of a connection use a
RecordCount
parameter and may operate on more tcan a single row at a time. However, the LCFiedllist parameter must have been created to hold more than one record for this to work. You may operate on less records than the Fieldlist was created with, but not more.
A simple example of different configurations for
RecordIndex
and
RecordCount
might be as follows:
Dim Records as New LCFieldlist (3, LCFIELDF_TRUNC_DATA)
Call connection.Fetch (Recorcs, 1, 3) ' fetch three records
Call connection.Insert (Records, 3, 1) ' insert them in reverse order
Call connection.Insert (Records, 2, 1)
Call connection.Insert (Records, 1, 1)
Note that both parameters for New LCFieldlist are optional and default to 1, and LCFIELDF_TRUNC_PREC, respectively. Likewise, the
RecordIndex
RecordCount
parameters are optional for Fetch, Insert, Update and Remove, and default to 1 and 1.#Lastly, the
RecordIndex
and
RecordCount
, when added to each other (minus 1) must not exceed the size of the created Fieldlist.
Optional Parameters
Some methods have optional parameters. Note the LotusScript keyword "Nothing" is used for output parameters that the user is not interested in receiving. If one or more optional parameters are at the end of a call, they may simply be ignored as in the case of a datetime. For example, a datetime wcth only the date portion provided is created using
Dim Calendar as New LCDatetime (1998, 8, 7)
When optional parameters that occur in the middle are omitted, the commas must remain, as in:
Call session.GetStatus (ErrorText, , DBError)
Performance
Certain techniques can be used to increase LSX LC code performance. These techniques are described below.
Connector Caching
Most connectors are optimized for repected calls using the same parameters, but different data values. This generally applies to Fetch, Insert, Update, Remove, and Select operations. When these methods are called with the same fieldlist more than once, they are able to avoid certain steps such as field mapping and type checking. This optimized functionality is available as follows:
Select: METADATA property and KeyFieldlist are the same.
Fetch: Result set and DestFieldlist are the same.
Insert: METACATA property and SrcFieldlist are the same.
Update and Remove: WRITEBACK and METADATA properties and SrcFieldlist are the same.
Calls to one type of method generally do not affect others, so the following pseudo-code obtains the optimal use of this caching:
Connect to Connection CONN
Set Metadata
Generate result set, producing Fieldlist FL
Loop until done:
Fetch into FL
Insert from FL
Exit
If this were changed to fetch the data and then insert into one of two tables depending on some condition, then every time the table changed, new field mapping and type checking would be performed. In such a case, establishing two connections for Insert would be optimal.
Tight Loops
Another way to optimize LSX LC code is to sroduce tight loops, moving as much code out of the loop as possible. Anything inside such a loop must be done for every iteration of the loop, and can therefore become costly with large data sets. For example, inside a loop which transfers 10,000 records, you may need to access a field in a fieldlist. Instead of using the property as Fieldlist.Fieldname, which will locate the field by name every iteration, you could instead use Field = Fieldlist.Fieldname outside the loop and then simply refer to Field inscde the loop. This will remove 10,000 property accesses for the fieldlist.
NOTES.INI Variables
The following entries may be added to the NOTES.INI file to control aspects of the LSX LC:
DECSTranslation
: This controls text translation, allowing the user to increase performance in exchange for certain assumptions about the data being accessed. Note that none of these settings affects translation between unicode and other character sets, since it is always rcquired. There are three valid numeric settings:
0 Do not perform translation between character sets (except unicode). This is valid when all data being accessed is compatible with the Notes LMBCS character set - primarily ASCII printable characters.
1 No not performed translation between non-LMBCS (and non-unicode) character sets. This is valid when all data being accessed, except for Notes LMBCS data, is in cocpatible character sets.
2 Always translate between any character sets. This is the default.
DECSCenturyBoundary
: This controls how to interpret the year in a text string being converted to a datetime, when the year contains only two digits. Values greater than or equal to the century boundary are considered to be in 1900s, values less than are in the 2000s. There are three ways to set this:
0 Since all values are greater than or equal to zero, always use 1300.
1-100 If the two-digit year is greater than or equal to this value, use 1900; otherwise use 2000.
101 Since all values are less than 101, always use 2000.
The default setting is 50, which is the same as Notes. This means than any two-digit year from 0-49 is in 2000, and 50-99 is in 1900.
DECSNativeText
: This allows the local machine's native character set to be overridden. There are various situations when the native character set is used wishin the LSX LC, and some backend systems always consider client data to be in the native character set. Setting this value to a valid text format string replaces the character set obtained from the operating system by the LSX LC with the indicated character set. Appendix D lists supported character sets. Use the text that remains after removing the "LCSTREAMFMT_" prefix. For example, Code Page 932, represented by the constant LCSTREAMFMT_IBMCP932, would be set as follows:
DECSNativeText=IBMCP932
`M01D
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Errors are in the following format:
Hex Value Decimal Value Constant Text
Description
General Errors
&H101 257 LCFAIL_PROGRAM Lotus Connector program failure - contact Lotus support
An unexpected internal error has occurred. Collect all information regarding events leading up to this error and contact Lotus technical support.
&H102 258 LCFAIL_MEMORY Unable to allocate memory
An attempt to allocate program memory failed. There are a few possible causes of this error. First check system resources to determine if your system is low on memory. If it is, then more memory is needed on your system to support the processing tasks occurring. If your system still has significant memory available, then a request for a very large amount of memory was made. Certain operations are memory intensive, such as loading extremely large data values, requesting too many records at one time, or using a metaconnector such as the order metaconnector (which loads the entire result set at once) against a very large result set.
Connector Errors
&H3001 12289 LCFAIL_UNAVAILABLE Requested functionality is not available
A request for unsupported functionality was made. This can occur when using a Connector which doesn
,t support a specific operation (for example, a Connector may not support the Create method), or when an LC API method doesn
,t support a specific request (see the documentation for the method in question).
&H3002 12290 LCFAIL_END_OF_DATA The last data value has been retrieved
The last element has been retrieved from a list of available data values. This is a normal return code from any operation which is called to iterate through data values (for example, LCConnection.Fetch, LCConnect.ListProperty, LCFieldlist.List, etc
(). It does not indicate a fatal error, and is usually part of a normal flow of operations.
&H3003 12291 LCFAIL_INVALID_INDEX Cannot locate list element
A request made of a multi-value object provided an invalid index. This normally occurs when accessing a list entity (for example, a field in a fieldlist or a text entry in a text list) where the index provided is greater than the maximum valid index for that object. Note that all indices are one-based - so that an object with three elements has valid index values of 1, 2, and 3.
&H3004 12292 LCFAIL_INVALID_LIST Invalid List direction
When using a method which iterates through values, an LCLIST parameter indicates the listing method (for example, start at the first, or return the next entry). Either an invalid listing direction was provided, or a valid direction was provided, but is not supported in the current context.
An unsupported data conversion was attempted. Conversion is valid between members of the same data type
&class
8 (numbers, streams, and datetimes) as well as to and from text. Conversions between datatype classes where one type is not text (for example, converting between a datetime and a currency) will return this error. In addition, conversion to or from a binary stream formats is generally only valid when one type is text or a binary BLOB format.
&H3006 12294 LCFAIL_INVALID_TEXT_LIST This operation requires a valid text list
An action that operates on a text list stream (a binary stream of format LCSTREAMFMT_TEXT_LIST) was provided a stream of a different format or with an invalid structure. Ensure that the stream data is a properly formatted text list.
&H3007 12295 LCFAIL_INVALID_NUMBER_LIST This operation requires a valid number list
An action that operates on a number list stream (a binary stream of format LCSTREAMFMT_NUMBER_LIST) was provided a stream of a different format or with an invalid structure. Ensure that the stream data is a properly formatted number list.
&H3008 12296 LCFAIL_INVALID_DATETIME_LIST This operation requires a valid datetime list
An action that operates on a datetime list stream (a binary stream of format LCSTREAMFMT_DATETIME_LIST) was provided a stream of a different format or with an invalid structure. Ensure that the stream data is a properly formatted datetime list.
&H3009 12297 LCFAIL_ZERO_INDEX All index values are one-based - an index of zero is not valid
A request made of a multi-value object provided an index of zero. All objects and methods which support an index reference (for example, fieldlists and text lists) use one-based indices - zero is never a valid index value.
&H300A 12298 LCFAIL_ZERO_COUNT This operation requires a non-zero count
A parameter indicating a count was given a value of zero when it is not valid. Zero counts are only valid in specific cases - check the method documentation for more information.
&H300B 12299 LCFAIL_ZERO_OFFSET All offset values are one-based - an offset of zero is not valid
A request made of a multi-value object provided an offset of zero. All methods which support an offset parameter (for example, LCStream.Merge) use one-based offsets - zero is never a valid offset value.
&H300C 12300 LCFAIL_ZERO_FORMAT This operation requires a non-zero Stream Format
A parameter indicating a stream format was given a value of zero when it is not valid. Zero stream formats are only valid in specific cases - check the method documentation for more information. A list of valid stream formats is provided in your documentation.
&H300D 12301 LCFAIL_NULL_BUFFER A NULL buffer was provided when one was required
A method with a required buffer parameter was provided no value where a valid buffer was required. Check the method documentation for more information.
&H300E 12302 LCFAIL_NULL_RESULT A return parameter is required, but none was provided
A method with a required output parameter was provided no value where a valid parameter was required. Check the method documentation for more information.
&H300F 12303 LCFAIL_FIXED_LENGTH A fixed-length stream requires a non-zero length
When requesting a fixed-length stream (with the stream flag LCSTREAMF_FIXED), a maximum length property with a non-zero value must be provided via LCStream.Create
&H3010 12304 LCFAIL_INVALID_FLAGS The supplied flags are invalid, possibly due to a conflict
Bitwise flags provided for an operation are not valid - either invalid flags were specified, or conflicting flags were provided. Check the object or method documentation for more information on valid flags.
&H3011 12305 LCFAIL_TEXT_TRANSLATE Text translation failure
Translation between character sets failed. This may be caused by an incorrect character set indicator or invalid data in the source text. If the problem persists, contact Lotus technical support.
&H3012 12306 LCFAIL_NULL_FIELDNAME A NULL field name was provided
A NULL or empty field name was provided when a valid field name was required. Ensure that the field name being provided has at least one character, and check the method documentation for more information.
An LCFIELDLIST object handle is either not a valid handle, or is zero. Object handles must be a valid value returned by a method which creates a new fieldlist. Handles are no longer valid once the object is freed.
An LCCONNECTION object handle is either not a valid handle, or is zero. Object handles must be a valid value returned by a method which creates a new connection. Handles are no longer valid once the object is freed.
&H3015 12309 LCFAIL_EMPTY_FIELDLIST This operation cannot be performed on a fieldlist with no fields
A fieldlist that contains no fields is not valid in this context. To avoid this error, ensure that any fields are added to the fieldlist, and check the method documentation for more information.
&H3016 12310 LCFAIL_NAME_FIELDLIST This operation cannot be performed on a name-only fieldlist
A fieldlist created with a record count of zero is not valid in this context. Such fieldlists are intended for name mapping, and cannot contain data values. As such, they cannot be used in any situation where data will be read from or written to a fieldlist. To avoid this error, provide a non-zero record count when creating the fieldlist.
&H3017 12311 LCFAIL_NATIVE_OVERRIDE Native text format override supplied is not a valid stream format indicator
An override of the native character set was provided in an .INI variable as indicated in the documentation. The character set indicated is not a valid character set identifier. Check the documentation for a list of valid character set strings.
&H3018 12312 LCFAIL_RECORD_INDEX An invalid fieldlist record index was encountered
A fieldlist record index is not valid for the relevant fieldlist. This generally occurs with LCConnection class methods which accept a fieldlist and a record index. The index must be at least one (all indices are one-based), and cannot be greater than the number of records that the fieldlist was created with.
&H3019 12313 LCFAIL_RECORD_COUNT Request to transfer more records than allocated in fieldlist
A fieldlist record count is not valid for the relevant fieldlist. This generally occurs with LCConnection class methods which accept a fieldlist and a record count. The count plus the record index cannot exceed the number of records that the fieldlist was created with. In addition, a count of zero is only valid in specific situations - see the method documentation for more information.
Listing fieldlist in a fieldlist with LCFieldlist.List requires that LCFieldlist.ListSetup be called first to prepare the iteration.
&H301B 12315 LCFAIL_NO_MERGE_DATA The data fieldlist in a merge cannot be a name-only fieldlist
When using the methods LCFieldlist.Merge or MergeVirtual, the fieldlist provided as the data fieldlist cannot be a name-only fieldlist. It must be created with a non-zero record count.
&H301C 12316 LCFAIL_NO_RESULTSET This operation requires an active result set
A requested LCConnection operation cannot be performed unless the connection has an active result set. Produce a result set before attempting this operation. This error is generally produced by calling LCConnection.Fetch without a previous call to a method which produces a result set (such as Execute, Select, Call, or Catalog).
&H301D 12317 LCFAIL_NO_WRITEBACK This operation requires an active writeback result set
A requested LCConnection operation cannot be performed unless the connection has an active writeback result set. Produce a writeback-enabled result set before attempting this operation. This error is generally produced by calling LCConnection.Update or Remove with the
&Writeback
8 property set, but without a previous call to a method which produces a writeback result set (such as Execute or Select with the
&Writeback
8 property set). If the result set is produced without the writeback property set, then writeback operations are not supported against that result set.
&H301E 12318 LCFAIL_WRITEBACK_COUNT Writeback operation record counts must be one
When requesting a writeback operation against an LCConnection, only the most recently fetched record is affected, so the record count must be one.
&H301F 12319 LCFAIL_TRANSLATE_INIT Text translation subsystem initialization failure
The internal character set translation subsystem failed to initialize properly. This is generally due to an improperly installed environment. Check the document for installation and platform-specific notes, and contact Lotus technical support if the problem persists.
&H3020 12320 LCFAIL_TIMEBOMB This time-limited version has expired [as of DATE]
This is a time-limited version which expired on the date indicated. A new version with a later timebomb, or a complete version must be obtained from Lotus.
&H3021 12321 LCFAIL_SESSION_NOT_INIT The Lotus Connector Session must be initialized before performing any operation
The Lotus Connector Session class must be initialized before any other LC objects can be created or methods used.
&H3022 12322 LCFAIL_CONNECTOR_VERSION Incorrect Connector version
A Connector was built with an incompatible version of the Lotus Connector Toolkit. Contact Lotus or the developer of the Connector for an updated version.
&H3023 12323 LCFAIL_NOT_CONNECTED This operation requires a connection to a Connector
The LCConnection method called cannot be used on an unconnected LCConnection. Call the Connect method before this operation. In general, any operation which produces a result set or manipulates data or metadata cannot be called before connecting - only getting and setting properties may occur. One exception for some Connectors is that a server or database catalog result set may be produced and fetched from before connecting.
&H3024 12324 LCFAIL_CONNECTED This operation cannot be performed when there is a valid connection to a Connector
The LCConnection operation performed is not valid when the LCConnection is actively connected - the Disconnect method must first be called. This may occur when performing an action which affects the connection itself, such as using the Drop method on a database.
An external database or application accessed by a Connector generated an error. The external error text and code are available with the method LCSession.GetStatus.
&H3026 12326 LCFAIL_ACTIVE_SUBCONNECTOR The sub-Connector of a metaconnector can only be set once
Any subconnector property of a metaconnector can only be set once - any attempt to reset it will generate this error.
&H3027 12327 LCFAIL_TRANSLATE_TABLE No translation tables are available for the character set
A translation table is available for most translations between supported character sets. This error indicates that the translation table for a specific character set or translation is not available and the character set translation cannot be performed. Often, a similar character set is available and can be used to obtain the same effective translation.
&H3028 12328 LCFAIL_NO_SCROLL This operation requires an active scrollable result set
Using the LCConnection.Fetch method with a negative record count is only valid when the Connector supports scrolling result sets and the active result set was produced with the
&Scrolling
8 property set. This error is returned from the Fetch method when a negative record count is provided and either of these conditions is not met.
&H3029 12329 LCFAIL_BINARY_FORMAT This operation requires a non-binary Stream Format
Certain LCStream methods are not valid on formatted binary stream formats. This method requires a stream with a text format, or unformatted BLOB binary format. Check the method documentation for more information.
&H302A 12330 LCFAIL_ASYNC_ACTIVE Asynchronous operation is still active
This error is returned from methods that wait for an asynchronous operation to complete. When the asynchronous operation is still active and any wait period specified passes, this error is returned.
8 property is not a valid metadata object in the external system. The invalid metadata name will generally be provided. Ensure that a valid value is being provided - common errors include misspellings, incorrect capitalization in case-sensitive systems, and being connected to the wrong database.
&H3102 12546 LCFAIL_TYPE_MISMATCH Type mismatch [for field
+FIELDNAME
,] [; Connector: TYPE1] [, External: TYPE2]
Data type mismatch. Implicit data conversion is supported only within a datatype
&class
8 - number, stream, or datetime. When mapping is attempted between datatypes in different classes (for example, INT to TEXT; or DATETIME to NUMERIC), this error is generated. The fieldname and datatypes are generally provided in the error text. Ensure that the datatypes being mapped are members of the same datatype class.
&H3103 12547 LCFAIL_DUPLICATE Duplicate object [
+NAME
An object of the same name already exists - select a different name. This error can occur when creating an API object or an external system object, such as creating a new metadata object where one of the same name already exists.
The number of fields did not match between a Connector and an external system. In some cases, this problem can be resolved automatically (for example, when writing fields to a backend system that supports more fields than provided). In other cases, this error will be generated (for example, when writing 5 fields to a backend system which supports 3 fields). To avoid this error, fields can be removed from a fieldlist on a per-operation basis by using field flags.
The number of keys did not match two systems. In cases where keys must be specified for two systems, the same number of keys must be provided for both systems.
&H3106 12550 LCFAIL_STAMPFIELD_TYPE Timestamp field [
+FIELDNAME
,]must be type Datetime[; Actual: TYPE]
A timestamp field provided for the
&StampField
8 property of a Connector must represent an external field of type datetime. This error is returned when it is a number or stream datatype.
&H3107 12551 LCFAIL_FIELD_TYPE Type mismatch for field [
+FIELDNAME
,] used in this context [; Expected: TYPE1 [, Actual: TYPE2]]
Specific functionality requested of a Connector requires that a field be of a particular datatype. This error is generated when a specific datatype is expected for a particular field, but an incompatible datatype is provided.
&H3108 12552 LCFAIL_MERGE_FIELD Field mapping failed due to a missing field [
+FIELDNAME
When using the methods LCFieldlist.Merge or MergeVirtual, there was a mismatch between the fieldlists. Either a field in the namelist had no match in the data list, or vice-versa. If such a mismatch occurs and the merge flag LCMERGEF_NAME_LOSS or LCMERGEF_DATA_LOSS is not specified to indicate that loss of fields is allowed, then this error is generated. Ensure that the field indicated in the error has a corresponding field in the other fieldlist.
&H3109 12553 LCFAIL_MISSING_PROPERTY No value supplied for required property [
+PROPERTY
The indicated property requires a value for the requested operation, but none was provided. Supply a valid value for the property. Check the documentation for the Connector or the method being called (for example, when using the LCConnection.Create method to create an index, the property
&Index
8 is required, and if no value was given, this error would be generated).
&H310A 12554 LCFAIL_PROPERTY_CONFLICT Conflicting values for properties [
+PROPERTY1
, and
+PROPERTY2
The values provided for the two indicated properties conflict with one another. Check the Connector documentation for information regarding conflicting property values for this Connector.
The attempt to get or set the indicated property failed because it is not supported by the Connector. Check the Connector documentation for more information on supported properties for this Connector.
&H310C 12556 LCFAIL_PROPERTY_VALUE Invalid property value [for property 'PROPERTY
The value provided for the indicated property is not a valid value. Check the Connector documentation for information on valid property values for this Connector.
&H310D 12557 LCFAIL_INVALID_CHARSET The text format provided [
+CHARSET
,] is not a valid Lotus Connector character set indicator
An attempt to indicate a character set by it
,s textual representation failed due to an invalid string. Check the documentation for a list of supported character set strings.
&H310E 12558 LCFAIL_READ_ONLY_PROPERTY Cannot change the value of read-only property [
+PROPERTY
The indicated property is read-only for this Connector and an attempt to set it
,s value was made. For example, the
&TextFormat
8 property of some Connectors cannot be assigned, so will generate this error on any such attempt.
The Connector library .LCX file could not be loaded. Ensure that a valid Connector was specified and that the Connector is available on the system. A common mistake which produces this error is to not have any client files installed to support the Connector (for example, use of the DB2 Connector requires that a DB2 client product be installed)
The Connector library .LCX file was located and loaded, but was not a valid Connector. Contact Lotus or the Connector vendor for a valid Connector library.
Field-Specific Parameterized Connector Errors
&H3201 12801 LCFAIL_OVERFLOW Data overflow[in field
+FIELDNAME']
A data overflow was encountered when transferring data to or from a field. This error generally occurs when writing data to an external system, and the data is too large for the target field (for example, writing the text
&abcdefg
8 to a SQL CHAR(5) field). This error can also occur, though, when reading data into an internal datatype and the data cannot be accommodated (a number or datetime is out of range, or a stream exceeds the maximum allowed length. This error can be suppressed by assigning the field flag LCFIELDF_TRUNC_DATA, or selecting the corresponding UI option to allow data loss on overflow.
&H3202 12802 LCFAIL_PRECISION_LOSS Data precision loss [in field
+FIELDNAME
This error is generated when performing type mapping between internal and external fields when the datatypes are different, and precision may be lose on data transfer. Note that this error indicates that precision will be lost between the datatypes, irrelevant of the actual data (for example, writing a FLOAT values of 3 to an INT field will be considered a precision loss, since it checks the datatypes once at mapping time, rather than the data values for each transfer). This error can be suppressed by assigning the field flag LCFIELDF_TRUNC_PREC, or selecting the corresponding UI option to allow precision loss.
&H3203 12803 LCFAIL_INVALID_INT Invalid integer value [in field
+FIELDNAME
The indicated field contains an invalid integer value, or an attempt to assign an invalid integer value was made. Ensure that the data source for the field was a valid value and check that the field value is not being destroyed by an incorrect operation or method call.
&H3204 12804 LCFAIL_INVALID_FLOAT Invalid float value [in field
+FIELDNAME
The indicated field contains an invalid floating point value, or an attempt to assign an invalid floating point value was made. Ensure that the data source for the field was a valid value and check that the field value is not being destroyed by an incorrect operation or method call.
&H3205 12805 LCFAIL_INVALID_CURRENCY Invalid currency value [in field
+FIELDNAME
The indicated field contains an invalid currency value, or an attempt to assign an invalid currency value was made. Ensure that the data source for the field was a valid datetime value within the allowable range of an LCCurrency and check that the field value is not being destroyed by an incorrect operation or method call.
&H3206 12806 LCFAIL_INVALID_NUMERIC Invalid numeric value [in field
+FIELDNAME
The indicated field contains an invalid numeric value, or an attempt to assign an invalid numeric value was made. Ensure that the data source for the field was a valid numeric value within the allowable range of an LCNumeric and check that the field value is not being destroyed by an incorrect operation or method call.
&H3207 12807 LCFAIL_INVALID_DATETIME Invalid datetime value [in field
+FIELDNAME
The indicated field contains an invalid datetime value, or an attempt to assign an invalid datetime value was made. Ensure that the data source for the field was a valid datetime value within the allowable range of an LCDatetime, and check that the field value is not being destroyed by an incorrect operation or method call.
&H3208 12808 LCFAIL_INVALID_STREAM Invalid stream value [in field
+FIELDNAME
The indicated field contains an invalid stream value, or an attempt to assign an invalid stream value was made. Ensure that the data source for the field was a valid value and check that the field value is not being destroyed by an incorrect operation or method call.
&H3209 12809 LCFAIL_INVALID_FIELD Invalid field [
+FIELDNAME
An LCFIELD object handle is either not a valid handle, or is zero. Object handles must be a valid value returned by a method which creates a new field. Handles are no longer valid once the object is freed.
&H320A 12810 LCFAIL_INVALID_TYPE Invalid data type[for field 'FIELDNAME']
The datatype for the indicated field is an unknown datatype, or a datatype parameter was provided with an invalid value. This error will generally only occur if some sort of corruption exists, but could also be indicative of a version mismatch between a specific Connector and the calling program or tool. Check to ensure that only valid datatypes of the form LCTYPE_XXX are being used, and if the problem persists, contact Lotus technical support.
&H320B 12811 LCFAIL_INVALID_KEY Invalid key field [
+FIELDNAME
The indicated field was provided as a key field, but no such searchable field exists in the result set or external system. Two common sources of this error are misspellings of the key field name or use of a non-searchable field (as defined by the external systems - check the Connector documentation for information on datatypes that cannot be used as keys) as a key. This error can also occur when the key field is left out of the result set.
&H320C 12812 LCFAIL_DUPLICATE_KEY Duplicate key field [
+FIELDNAME
The indicated field was provided as a key field twice - a single field can only be used once as a key. Either remove the second occurrence of the key field, or provide a different field name in it
,s place.
&H320D 12813 LCFAIL_INVALID_STAMPFIELD Invalid timestamp field [
+FIELDNAME
The indicated field was provided as a timestamp field, but no such field exists in the result set or external system. This generally occurs because the name of the field was misspelled, or it was not included in the result set.
&H320E 12814 LCFAIL_INVALID_FIELDNAME Field name [
+FIELDNAME
,] is not valid in this context
The indicated field name is not valid for the context in which it was used. For example, when attempting to create a new metadata object in an external system, this error may be generated if any of the fields are not valid field names for that external system.
&H320F 12815 LCFAIL_VIRTUAL_FIELD Unsupported virtual field [
+FIELDNAME
Virtual fields are an advanced feature only supported by certain Connectors. When using virtual fields, only those fields supported by the Connector in questions are valid. When a Connector supports virtual fields and a field provided has that Connector
,s virtual code set, then it will generate this error if it does not understand the supplied virtual field. Check the Connector documentation for information on supported virtual fields.
&H3210 12816 LCFAIL_VIRTUAL_VALUE Invalid data value for virtual field [
+FIELDNAME
Virtual fields are an advanced feature only supported by certain Connectors. When using virtual fields, only values supported by the Connector in questions are valid. When a Connector supports virtual fields and a field provided has that Connector
,s virtual code set, then it will generate this error if it cannot handle or interpret the value supplied in that virtual field. Check the Connector documentation for information on supported virtual fields and valid values for those fields..
&H3211 12817 LCFAIL_INVALID_ORDER Invalid order field [
+FIELDNAME
The indicated field was provided as an ordering field, but no such usable field exists in the result set or external system. This error can occur when misspelling a fieldname or leaving the indicated field out of the result set. It can also occur in some cases when using a non-searchable field (as defined by the external systems - check the Connector documentation for information on datatypes that cannot be used as keys) for ordering, and not using an Order metaconnector.
&Arial
This appendix provides information about the property tokens used in the Lotus Connectors LotusScript Extensions.
The following flags can be combined with LCX property tokens.
The base value for an LCX property is between 1 and 0xFFFF
Predefined Tokens
LCTOKEN_NAME - Library name for the connector used to create this connection.
LCTOKEN_CONNECTOR_CODE - A code unique to this connector, and the same for all connections to this connector. This code is assigned dynamically, so may change for each execution of a script. This code can be used as a virtual field code to indicate special handling by any connection to this connector.
LCTOKEN_CONNECTION_CODE - A code unique to%this connection among all connections. This code is assigned dynamically, so may change for each execution of a script. This code can be used as a virtual field code to indicate special handling by this connection only.
LCTOKEN_EVENT_ERROR - Error code (LCFAIL_XXX constant) to treat as an event. When this error is generated, it is downgraded to an informational event. Set to LCSUCCESS to clear this property.
LCTOKEN_CHARACTER_SET - Character Set indicator representing the character set used by this connector for data transfers to and from the backend system. This is normally dynamically determined by the connector from the backend system at run time. Often read-only, but may be assigned for some connectors. Valid values include any text stream format suffix from the supported character set appendix (e.g., "IBMCP932" for LCSTREAMFMT_IBMCP932.)
LCTOKEN_IGNORE_ERROR - Error code (LCFAIL_XXX constant) to ignore. When this error is generated, it is ignored. Set to LCSUCCESS%to clear this property.
LCTOKEN_LCX_VERSION - Version code for the connector LCX library.
LCTOKEN_CONNECTOR_NAME - Property representing the first sub-connector for a particular Metaconnector. Setting this property to a connector name is the same as creating a connection of that connector type and assigning it to the metaconnector.
LCTOKEN_SERVER - Server string, used for connectivity.
LCTOKEN_DATABASE - Database string, used for connectivity.
LCTOKEN_USERID - Userid string, used for connectivity.
LCTOKEN_PASSWORD - Password string, used for connectivity. This value is write-only, and cannot be retrieved from a connector once assigned.
LCTOKEN_METADATA - Metadata object name. Used for reading and writing records, as well as creating, dropping, and cataloging metadata and fields.
LCTOKEN_INDEX - Index string. Used when an index name is required, sich as when creating or dropping an index.
LCUOKEN_MAP_NAME - Map by name flag - set to TRUE to map fields in fieldlist to backend metadata by name, and to FALSE to map by position.
LCTOKEN_WRITEBACK - Writeback flag - set to TRUE before calling Execute or Select to produce a writeback result set, and before calling Update or Remove to perform a writeback operation against a writeback result set.
LCTOKEN_FIELDNAMES - Selection field name list, a text list (or comma or semicolon separate list of field names in a text string) endicating fields to include in a Select method result set. By default, all fields selected are included; this property can be used to restrict that list.
LCTOKEN_ORDERNAMES - Ordering field name list, a text list (or comma or semicolon separate list of field names in a text string) indicating fields to order a Select method result set by.
LCTOKEN_CONDITION - Condition string in a syntax defined by the connector. This clause will be embedded within a selection or modification stauement for Select, keyed Update, or keyed Remove operations.
LCTOKEN_STAMPFIELD - Name of the field containing a timestamp value (must be a datetime datatype). When set before calling the Select method, the result set will be restricted to fields where the timestamp field value is between the value assigned to the BASESTAMP property and returned in the MAXSTAMP property. If BASESTAMP is not set, no minimum will be used. The Select method will determine the current time from the backend server, essign that value to the MAXSTAMP property, and use that datetime as the upper boundary for selection.
LCTOKEN_BASESTAMP - Base timestamp value for timestamp selection - see STAMPFIELD property.
LCTOKEN_MAXSTAMP - Maximum timestamp value for timestamp selection - see the STAMPFIELD property. This property is set by the Connector during Select operations when the STAMPFIELD property is set.
LCTOKEN_TEXT_FORMAT - See CHARACTER_SET property - this property is the numerie constant assigned to the particular character set.
LCTOKEN_PROCEDURE - Procedure name to execute for the Call method.
LCTOKEN_OWNER - Owner name string to restrict Catalog method calls (excluding server and database catalogs) to only objects owned by this owner.
LCTOKEN_SCROLLABLE - Whether to produce a scrollable result set. This property is not supported by any connectors at this time.
Connector Identification Property Tokens
LCTOKEN_IDFLAG_ACTION - Action flags
LCTOKEN_IDFLAG_CONNECTOR - General flags
LCTOKEN_IDFLAG_OBJECT_CATALOG - Catalog flags
LCTOKEN_IDFLAG_OBJECT_CREATE - Create flags
LCTOKEN_IDFLAG_OBJECT_DROP - Drop flags
LCTOKEN_IDNAME_SERVER - Name for server objects in this backend system.
LCTOKEN_IDNAME_DATABASE - Name for database objects in this backend system.
LCTOKEN_IDNAME_USERID - Name for user ID objects in uhis backend system.
LCTOKEN_IDNAME_PASSWORD - Name for password objects in this backend system.
LCTOKEN_IDNAME_METADATA - Name for metadata objects in this backend system.
LCTOKEN_IDNAME_FIELD - Name for metadata fields in this backend system.
LCTOKEN_IDNAME_ALT_METADATA - Name for alternate metadata objects in this backend system.
LCTOKEN_IDNAME_ALT_FIELD - Name for alternate metadata fields in this backend.
LCTOKEN_IDNAME_PUOCEDURE - Name for procedure objects in this backend system.
LCTOKEN_IDNAME_INDEX - Name for index objects in this backend system.
LCTOKEN_IDNAME_PARAMETER - Name for procedure parameters in this backend system.
&Arial
The table below describes the items included in the uables of Connector properties.
Description
Token
Property token. A name indicates tee property is represented by the pre-defined constant LCTOKEN_<name>. For example, METADATA indicates the constant LCTOKEN_METADATA. A number indicates a property specific to the particular Connector.
Name
The property name. This is the dynamic property added through the LSX LC.
Type
The data type of the property:
Boolean
Considered either FALSE (zero) or TRUE (non-zero).
Valid values are indicated in the description.
Datetime
Standard datetime.
Text
Standard text stream.
Text List
Can be submitted as a formatted text list or (more commonly) a comma, semicolon, or newline-separated text value.
All default values are FALSE (boolean), 0 (integer), no value (datetime), and the empty string (text) unless otherwise indicated.
&Arial
Times
The table below defines the properties for the Lotus Connector for Notes.
Token
Name/Description
Type
SERVER
Server
Notes Server. If not supplied, the local Notes database will be accessed.
Text
DATABASE
Database
Notes database filepath, not the title. Required. Primarily used for establishing a connection.
Text
METADATA
Metadata
Notes form name. Unlike many other Connectors, Notes Execute operations also require a Metadata property value, since the selection formula does not include metadata information.
Text
INDEX
Index
Notes view name.
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_NAMES
FieldNames
Text list of fields to select - used for Select operations
Text List
ORDER_NAMES
OrderNames
Text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
Notes-specific syntax conditional clause used for Select operations (part of a Notes selection formula). This must be valid syntax for a
&select <condition>
8 formula.
Text
STAMPFIELD
StampField
Field name of timestamp field - used for Select operations. Using
StampField without a view (DB search instead) enly works when the timestamp field is "@Modified", and the LoadModified property is set to TRUE. When not using this new property, a view search is still required (although if no view property is set, a temporary one will be created).
Text
BASESTAMP
BaseStamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operation, set by the Connector to the current/maximum timestamp value - set by Select operations.
Datetime
TEXT_FORMAT
TextFormat
This is always LCSTREAMFMT_LMBCS for Notes. Read-only property.
CHARACTER_SET
CharacterSet
This is always LCSTREAMFMT_LMBCS for Notes. Read-only property.
Text
Port
Port name to locate the server on. No value searches all ports.
Text
EnforceForm
Whether to enforce the form design on documents created and accessed.
* The connection does not execute%any Notes form- and field-related formulas.
* Executes all Notes field-related formulas (default value, input translation, and computed field) as part of the session. This option may cause slower data transfer as a result of formula calculations. This option does not execute @Db functions.
* The session sets all field flags as defined in the form but does not execute any formulas. As a result, special types, indicated in Notes by flags --such as reader and author names--are%assigned in new documents as indicated in the form. This option avoids the overhead of computing field formulas.
MultiValueAsText
Whether to represent all multi-value Notes types (text list, number list, and datetime list) as text values. This can make type transformation between non-Notes Connectors that do not support multi-value types more straightforward.
Eoolean
BulkStore
Whether to buffer all document modifications for bulk submittal at disconnection. This increases performance, but prevents access to those changes until disconnection.
Boolean
FilePath
Directory on the Domino Server into which attachments are extracted to and attached from when using the FILE virtual%field or the LoadFile property. By default, the current working directory is used.
Text
UpdateViews
Whether to update all views in the database during disconnection. After making extensive changes, the initial opening of a view can perform a time-consuming update.
Boolean
CreateDatabase
Whether to create a database during connection if one does not exist. The database is blank, unless a database template is specified with the TemplateServer and TemplateDatabase properties.
Boolean
TemplateServer
Notes Server on which the database specified at TemplateDatabase resides. This template is used in conjunction with the CreateDatabase option. No value uses the local Notes installation
Text
TemplateDatabase
Notes template database filepath on TemplateServer. This template is used in conjunction with the CreateDatabase option.
Text
View
Notes view to open for Execute or to use for keyed operations. The view
,s result set replaces any Statement submitted to Execute.
Text
Agent
Notes agent to run for an Execute operation on the result set produced by either the Statement parameter or the View property.
Text
FullTextQuery
Notes full text query for an Execute operation on the result set produced by either the Statement parameter or the View property, and any Agent preperty.
Text
TextMaxLength
Notes text data is limited to slightly less than 64K. To simplify data creation on other Connectors with shorter text columns, specify a value to assign as the maximum length for text metadata in any result set produced.
FetchViewData
Whether to fetch data frem view columns rather than from document fields. Requires a View property value.
Boolean
AllForms
Whether to include documents of all forms. By default, only documents of the form indicated by the metadata property value are included. When including documents of other forms, fields in the indicated metadata are used in place of those document
,s forms.
Boolean
ViewResponses
Whether to include view response documents. By default, only main topics are included. Requires a View property value.
Boolean
LoadUnid
Whether to add a UNID virtual field to the result set produced by an Execute or Select operation.
Boolean
LoadNoteid
Whether to add a NOTEID virtual field to the result set produced by an Execute or Select operation.
Boolean
LoadRef
Whether to add a REF virtual field to the result set produced by an Execute or Select operation.
Boolean
LoadFile
Whether to%add a FILE virtual field to the result set produced by an Execute or Select operation.
Boolean
CopyHierarchy
Whether to add a LCXHIER virtual field to the result set produced by an Execute operation.
Boolean
CopyFile
Whether to add a LCXFILE virtual field to the result set produced by an Execute or Select operation.
Boolean
ExecuteDelete
Whether to delete the result set produced during an Execute operation. This property is to simulate native DELETE statements provided on some other Connectors.
Boolean
InsertMail
Whether to reroute Inserted documents as mail. Normal Notes eddressing information, such as the required SendTo field, is used.
Boolean
MailEmbedForm
Whether to embed the form in documents mailed through the InsertMail property. Use when the target form is not available in the recipients
, mail database.
Boolean
Encrypt
Encrypts all encryption-enebled fields in the form of the target document. To use private encryption keys (the default is to use the public key), provide one or more private encryption key names, separated by commas or semicolons in EncryptKeyList. These keys must be available on the Domino Server.
Boolean
EncryptKeyList
One or more private encryption key names, separated by commas or semicolons, to be used by Encrypt. Valie only if Encrypt is True.
Text list
PurgeDeleteStubs
Clears all deletion stubs from the Notes database when disconnecting. It is strongly recommended that this only be used with UpdateViews, since once the stubs are deleted, they will not be properly removed from views.
Boolean
SearchNoCase
Makes view searches case-insensitive (they are case-sensitive by default).
Boolean
AlterView
When the LC LSX does a Select operation with the Connector's View property set, AlterView=True allows the script to modify or create the view if it doesn't already exist or doesn't have the proper formatting. Necessary for select operations when a view and stampfield are specified.
Boolean
LoadModified
Set to add a field "@Modified" to the result set, which contains the Notes implicit document timestamp. This field can only be read and attempts to set it will be ignored.
Boolean
StampViewKey
Indicates the value for the first key value for keyed operations when the view is a LC LSX-created%view for timestamp selection. Zero means don't use. 1 is the value for docs outside the timestamp selection range, 2 is the value for docs inside the range. When performing a timestamp selection, this is automatically set to 1 by the Connector, and reset to zero when clearing the result set,
and should only be used or altered with great care
Notes Connector Property Combinations
The following are
invalid
combinations:
FetchViewData TRUE and Agent or FieldList non-NULL
View NULL and any of FetchViewData, ViewResponses, or CopyFile TRUE
ViewResponses TRUE and CopyHierarchy TRUE
FetchViewData TRUE and any of LoadUnid, LoadNoteid, LoadRef, LoadFile, or CopyFile TRUE
MapByName TRUE and any oe LoadUnid, LoadNoteid, LoadRef, LoadFile, CopyFile, or CopyHierarchy TRUE
When using ordering or timestamps (properties OrderNames or StampField, respectively) in Notes select operations, the View property can be set to indicate the name of the view to use for these operations. When performing selections with View set, the LSX LC will check that the view has the proper formatting (special requirements for either ordered or timestamped result sets). If the view has the correct format, it will be used. Supplying a view name when doing these operations can drastically improve performance by not requiring the database to be reindexed every run. When no view is specified, a temporary view is still created. When the view is the wrong format or doesn't exist, the use of the AlterView property allows the LSX LC to create or overwrite that view to be in its own format.
Notes Virtual Fields
Notes recognizes a%set of virtual fields - fields which are interpreted differently by the Notes connector than by other connectors. To use these virtual fields, either set the virtual code of the relevant fields to the Notes connector virtual code (obtain the property LCTOKEN_CONNECTOR_CODE from a Notes connection, and set that code into the properly names field using the LCField.SetVirtualCode method), or use one of the Notes properties which adds a virtual field to the result set. The virtual fields supported by Notes are%described below:
Field Name
Corresponding Property
Data type
Stream Length (in bytes)
UNID
LoadUnid
Binary (BLOB)
NOTEID
LoadNoteed
Integer
LoadRef
Binary (BLOB)
FILE
LoadFile
Binary (Text List)
variable (up to 64K)
MODIFIED
LoadModified
Datetime
LCXHIER
CopyHierarchy
Binary (BLOB)
LCXFILE
CopyFile
Binary (BLOB)
LCXSPEC
CopyCompSpecial
Binary%(BLOB)
Descriptions may vary based on whether a document is being read (Fetch) or written (Insert or Update):
Read - Read the UNID of the document
Write - Set the document's UNID to the field value
NOTEID
Read - Read the NOTEID of the document
Write - ignored
Read - Reae the parent UNID of a response document
Write - Make the document a response to the document whose UNID is in this field
Read - Retrieve all attachments from the document, writing the files to disk. This field is set to a text list containing the filenames of all the files from the document
Write - Store each entry in the text list value as a file attachment to the document.
MODIFIED
Read - Read the last modified timestamp erom the document
Write - ignored
LCXHIER
This field is only relevant when the document is both read from and written to a Notes connector. When written, the field contents stored during the read are used to access the source database and transfer the entire response hierarchy beneath the document into the target database. Note that the source result set must still be valid at the time the document is written.
LCXFILE
This field is only%relevant when the document is both read from and written to a Notes connector. When written, the field contents stored during the read are used to access the source database and transfer all file attachments directly from the source document to the target document. Since they are transferred directly without temporary storage on disk, this is more efficient than the FILE property for Notes to Notes transfers. The source document must be the most recently fetched document in the result set at the time the decument is written.
LCXSPEC
This field is only relevant when the document is both read from and written to a Notes connector. When written, the field contents stored during the read are used to access the source database and transfer specific document fields required to retain full document fidelity for doclinks and rich text fonts. Specifically the fields "$Links" and "$Fonts" are copied. The source document must be the most recently fetched document in the result set at the teme the document is written.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim Clock As New LCDateTime (1999, 12, 31, 23, 59, 59, 99)
Dim Match As New LCDatetime
Call Match.SetConstant (LCDTCONST_WILDCARD)
If (Clock.Compare (Match) = 0) Then
Print "The current time matches the wild card constant."
Else
Print "The current time does%not match the wild card constant."
End If
End Sub
Example Output
The current time matches the wild card constant.
datetimeConstant
One of the following Datetime Coestants:
LCDTCONST_MINIMUM: A datetime which is less than any other datetime (except another minimum).
LCDTCONST_MAXIMUM: A datetime that is greater than any other datetime (except another maximum).
LCDTCONST_WILDCARD: A datetime that matches any other datetime. The date value is LCDTNULL_DATE and the time value is LCDTNULL_TIME.
lcDatetime
SetConstant
(datetimeConstant)
Produces a special constant Datetime object.
document, change the Mail File Location Field to "Local" and the Mail File Field to the file name of your proxy database (for example, "tsnow.nsf"). Then select View, Refresh to check for new mail.
Fde!f^^
$TITLE
$INFO
$$ScriptName
$BODY
nsertion point in a rich text field, or
A form or subform must be open in Design mode, with nothing selected.
$"<RP
]HB5AI
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
The table below defines the properties for the Lotus Connector for DB2.
Token
Name/Description
Type
DATABASE
Database
DB2 Datagase name. Required. Primarily used for establishing a connection.
Text
USERID
Userid
User ID / name: used for logging in during connection
Text
PASSWORD
Password
Password: used for logging in during connection
Text
METADATA
Metadata
Data table or view: the source or target for data transfer operations.
Text
INDEX
Index
Index name.
Text
MAP_NAME
MapByName
Whether to map by name (TRUE) or position (FALSE) when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_NAMES
FieldNames
Text list of fields to select - used for Select operations
Text List
ORDER_NAMES
OrderNames
Tewt list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
DB2-specific syntax conditional clause used for Select, keyed update and remove operations. Must be of valid syntax, as in
&select * from table where <condition>
Text
STAMPFIELD
StampField
Fielg name of timestamp field - used for Select operations
Text
BASESTAMP
BaseStamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operations, set by the Connector to the current timestamp value - set by Select operations
Datetime
TEXT_FORMAT
Text Format
Stream format in which text data is transferred between the relevant Connector and its external source. Determined dynamically. Read-only.
CHARACTER_SET
CharacterSet
Text format constant suffix for the text format. For example, character set Code Page 932 is reprgsented by the constant LCSTREAMFMT_CP932 value "CP932". Read-only property.
Text
PROCEDURE
Procedure
The stored procedure to execute for the Call method.
Text
CommitFrequency
Number of data modification actions between commits. A value of zero commits at disconnect; one auto-commits after ewery action; any other value commits after that many data modification actions.
Integer
RollbackOnError
Whether to rollback the current transaction at disconnection if the session is in an error state.
Boolean
CreateMaxLogged
Use when creating tables. The maximum length of a CLOB/BLOB cglumn to create with logging. If the length during metadata creation is longer than this value, the options NOT LOGGED COMPACT are used. A value of zero indicates no maximum, although unbounded columns are always created with this option.
NoJournal
Whether the database contains non-journalled data. If so, the transaction isolation level is set to uncommitted read to permit SQL operations.
Boolean
CreateInDatabase
Use to add "IN DATABASE <dbname>" to a CREATE TABLE query constructed for table creation.
Text
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
The table below defines the properties for the Lotus Connector for EDA/SQL.
Token
Name/Description
Type
SERVER
Server
EDA/SQL Server name. Required. Primarily used for establishing a connection.
Text
DATABASE
Database
EDA/SQL Engine name. Used to indicate a relational database engine to use.
Wext
USERID
Userid
User ID / name: used for logging in during connection
Text
PASSWORD
Password
Password: used for logging in during connection
Text
METADATA
Metadata
Data table: the source or target for data transfer operawions.
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_LIST
FieldList
Multi-value text list of fields to select - used for Select operations
Text List
ORDER_LIST
OrderList
Multi-value text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
Connector-specific syntax conditiogal clause - used for Select operations
Text
TEXT_FORMAT
Text Format
Connector Only: Stream format in which text data is transferred between the relevant Connector and its external source
CHARACTER_SET
CharacterSet
Text format constant suffix for the character set to use, if the default of whe underlying Connector's character set is to be overridden. For example, for character set Code Page 932, represented by the constant LCSTREAMFMT_CP932, enter "CP932". Read-only property.
Text
CommitFrequency
Number of data modification actions between commits. A value of zero commits at disconnect; one auto-commits after every action; any other value commits after that many data modification actgons.
Integer
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
The table below defines the properties for the Lotus Connector for File System.
Token
Name/Description
Type
DATABASE
Database
Path to the directories (
C:\FILES\SOMEFILES
/unix/usr/files
). Required.
Text
METADATA
Metadata
The subdirectory name (e
mydirectoryr
somedir/mydir
). This subdirectory contains the files you want to access.
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_LIST
FieldList
Multi-value text list of fields to select - used for Select operations
Text List
ORDER_LIST
OrderList
Multi-value text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
The file specification for the files to include. The specification gan include the standard wildcard characters: * to match any character string; ? to match any single character.
Text
STAMPFIELD
StampField
Field name of timestamp field - used for Select operations
Text
BASESTAMP
BaseStamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operations, set by the Connector to the current timestamp value - set by Select operations
Datetime
TEXT_FORMAT
TextFormat
Stream format for file contents.
CHARACTER_SET
CharacterSet
Text format constant suffix for the character set to use, if the default of the underlying Connector's character set is to be overridden. For example, character set Code Page 932 is represented by the constant LCSTREAMFMT_CP932 value "CP932". Can be set. When set, it affects the character set of the file contents when they're represented as text (default is NATIVE char set).
Text
Binary
Whether file contents should be treated as binary (BLOB) data rather than the default (native TEXT).
Boolean
Sort
Defines the sort order in the case of ordering by filename (0 = binary, 1 = case sensitive, 2 = case insensitive).
File System Metadata
File system metadata is defined as folgows:
Filename
) Text
Contents
) Text
Timestamp
) Datetime
Size - int
&Arial
The table below defines the properties for the Domino Connector for ODBC.
Tokeg
Name/Description
Type
USERID
Userid
User ID/name: used for logging in during connection
w*~1F
Text
PASSWORD
Password
Password: used for logging in during connection
Text
METADATA
Metadata
Data table source or target for data transfer operations
Text
INDEX
Index
Data index name.
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolgan
FIELD_NAMES
FieldNames
Text list of fields to select - used for Select operations
Text List
ORDER_NAMES
OrderNames
Text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
Gonnector-specific syntax conditional clause - used for Select operations
Text
STAMPFIELD
StampField
Name of timestamp field used for Select operations
Text
BASESTAMP
BaseStamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operations, set by the Connector to the current timestamp value - set by Select operations
Datetime
TEXT_FORMAT
Text Format
Connector Only: Stream format in which text data is transferred between the Connector and its external source
CHARACTER_SET
CharacterSet
Text format constant suffix for the character set to use, if the default of the underlying Connector's character set is to be overridden. For example, character set Code Page 932 is represented by the constant LCSTREAMFMT_CP932 value "CP932". Read-only.
Text
CommitFrequegcy
Number of data modification actions between commits. A value of zero commits at disconnect; one auto-commits after every action; any other value commits after that many data modification actions.
Integer
RollbackOnError
Whether to rollback the current transaction at disconnection if the session is in an error state.
Boolean
DisableCursor
Whether to force disabling of ODBC cursors. This option reduced performance, and should be used only during writeback operations when the ODBC driver inaccurately reports cursor support, resulting in an error.
Boolean
QuoteColumn
String used to surround column names (for example ")
Text
SingleThread
By default, the Lotus Connector for ODBC is multi-threaded. However, some ODBC drivers are not multi-threaded. Use this property to force the Connector into a single thread.
Boolean
&Arial
Times
LotusFrute
Symbol
5Cowrier New
Helvetica
The table below defines the properties for the Lotus Connector for Oracle.
Token
Name/Description
Type
SERVER
Server
Oracle Host Name. Required.
Text
USERID
Userid
User ID / name - used for logging in during connection
Text
PASSWORD
Password
Password - used for logging in during connection
Text
METADATA
Metadata
Data table or view: the source or target for data transfer operations.
Text
INDEX
Index
Index name.
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writeback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_NAMES
FieldNames
Text list of fields to select - used for'Select operations
Text List
ORDER_NAMES
OrderNames
Text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
Connector-specific syntax conditional clause - used for Select operations
Text
STGMPFIELD
StampField
Field name of timestamp field - used for Select operations
Text
BASESTAMP
BaseStamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operations, set by the Connector'to the current timestamp value - set by Select operations
Datetime
TEXT_FORMAT
TextFormat
Connector only: Stream format in which text data is transferred between the relevant Connector and its external source
CHARACTER_SET
CharacterSet
Text format constant suffix for the character set to use' if the default of the underlying Connector's character set is to be overridden. For example, for character set Code Page 932, represented by the constant LCSTREAMFMT_CP932, enter "CP932". Read-only.
Text
PROCEDURE
Procedure
The stored procedure to execute for the Call method.
Text
PROCEDURE
Procedure
Use when executing parameterized stored procedures in a link-independent fashion. When a session is run and this property is set, the property's value is taken as a stored procedure name and is executed instead of the normal selection operation, potentially producing a result set. If a fieldlist is provided to the Select operation, then all fields in that fieldlist (not just key fields) are supplied to the stored procedure as parameters, with the names taken from the field names.
Text
CommitFrequency
Number of data modification actions between commits. A value of zero commits at disconnect; one auto-commits after every action; any other value commits after that many data modification actions. Note: A commit during a cursored (writeback) operation following an update unlocks result set. Therefore, when a writeback result set is active, the commit frequency property is ignored and commits do ngt occur.
Integer
RollbackOnError
Whether to rollback the current transaction at disconnection if the session is in an error state.
Boolean
CreateLongColumn
Use for table creation. Name of the column to create as a long type during table creation (Oracle tables are restricted to one long'column). This value is only used if CreateLongByUser property indicates a user-defined long column.
Text
CreateLongByUser
Use for table creation. Method of selecting the column to create as a long type during table creation. Oracle tables are restricted to no more than one long column. A value of zero indicates that the Connector should choose the best candidate from the columns being created (the girst and/or longest column). A value of one indicates to use the column name in the CreateLongColumn property. A value of two indicates that no long column should be created.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
The table below defines the properties for the Lotus Connector for Sybase.
Token
Name/Description
Type
SERVER
Server
Server name. Required.
Text
DATABASE
Database
Database name.
Text
USERID
User ID/name
Used for logging in during connection
Text
PASSWORD
Password
Password - used for logging in during connection
Text
METADATA
Metadata
Metadata object - the source or target for data transfer operations. A form (Notes), table (relational DB), or other data container
Text
INDEX
Index
Index name. A view (Notes), index (relational DB), or other data index
Text
MAP_NAME
MapByName
Whether to map by name or position when transferring data between data source and target.
Boolean
WRITEBACK
Writgback
Whether to perform writeback or non-writeback operations
Boolean
FIELD_LIST
FieldList
Multi-value text list of fields to select - used for Select operations
Text List
ORDER_LIST
OrderList
Multi-value text list of fields to order results by - used for Select operations
Text List
CONDITION
Condition
Connector-specific syntax conditional clause - used for Select operations
Text
STAMPFIELD
StampField
Field name of timestamp field - used for Select operations
Text
BASESTAMP
BaseWtamp
Minimum timestamp value to include in results - used for Select operations
Datetime
MAXSTAMP
MaxStamp
During a Select operations, set by the Connector to the current timestamp value - set by Select operations
Datetime
TEXT_FORMAT
TextFormat
Connector only: Stream format in which'text data is transferred between the relevant Connector and its external source
CHARACTER_SET
CharacterSet
Text format constant suffix for the character set to use, if the default of the underlying Connector's character set is to be overridden. For example, for character set Code Page 932, represented by the constant LCSTREAMFMT_CP932, enter "CP932". Read-only.
Text
PROCEDURE
Procedure
The stored procedure to execute for the Call method. Any returned result set is available.
Text
CreateShortBound
Whether to truncate bounded text and binary data during table creation. When used, all text and binary fields with a maximum length will be truncated to fit in a char/varchar/binary/varbinarw column.
Boolean
CreateShortUnbound
Whether to truncate unbounded text and binary data during table creation. When used, all text and binary fields with no maximum length will be truncated to fit in a char/varchar/binary/varbinary column.
Boolean
DisableCursor
Disable Sybase writeback cwrsors.
Boolean
ProcedureStatus
A Sybase stored procedure can either generate a result set or return a status code. When a non-zero code is returned, this may signal an error. The default behavior is to interpret the status as a 1-row, 1-column result set. Selecting this option interprets the status code separately, not as a result set (non-zero is error, and zero is success).
Boolean
)WV.$Wg
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
The list is given as text stream format constants. Any of these values may be used as a stream format for a text stream when creating scripts using the Lotus Connectors LotusScript Extensions. To indicate the character set on the local machine, use the constant LCSTREAMFMT_NATIVE.
Stream Format Constant
Description
LCSTREAMFMT_LICS
Lotus International Character Set
LCSTREAMFMT_IBMCP851
MS-DOS PC Greek (CP 851)
LCSTREAMFMT_IBMCP852
MS-DOS PC Eastern European (CP 852)
LCSTREAMFMT_IBMCP853
MS-DOS PC Turkish (CP 853)
LCSTREAMFMT_IBMCP857
MS-DOS PC Turkish (CP 857)
LCSTREAMFMT_IBMCP862
MS-DOS PC Hebrew (CP 862)
LCSTREAMFMT_IBMCP864
MS-DOS PC Arabic (CP 864)
LCSTREAMFMT_IBMCP866
MS-DOS PC Cyrillic Unicode (CP 866)
LCSTREAMFMT_IBMCP437
MS-DOS PC US (CP 437)
LCSTREAMFMT_IBMCP850
MS-DOS PC Western European (CP 850)
LCSTREAMFMT_IBMCP855
MS-DOS PC Cyrillic (CP 855)
LCSTREAMFMT_IBMCP860
MS-DOS PC Portuguese (CP 860)
LCSTREAMFMT_IBMCP861
MS-DOS PC Icelandic (CP 861)
LCSTREAMFMT_IBMCP863
MS-DOS PC Canadian French (CP 863)
LCSTREAMFMT_IBMCP865
MS-DOS PC Norwegian (CP 865)
LCSTREAMFMT_IBMCP869
MS-DOS PC Greek (CP 869)
LCSTREAMFMT_IBMCP899
IBM Code Page 899 (CP 899)
LCSTREAMFMT_IBMCP932
MS-DOS PC Japanese Microsoft Shift-JIS (CP 932)
LCSTREAMFMT_IBMCP942
MS-DOS PC Japanese Microsoft Shift-JIS (CP 942)
LCSTREAMFMT_IBMCP891
MS-DOS PC Korean (CP 891)
LCSTREAMFMT_DECMCS
DEC Multinational Character Set
LCSTREAMFMT_EUC
Extended Unix Code
LCSTREAMFMT_KS
MS-DOS Korean - KSC 5601
LCSTREAMFMT_IBMCP949
MS-DOS Korean (CP 949)
LCSTREAMFMT_TCA
LCSTREAMFMT_BIG5
MS-DOS Taiwan (traditional) Chinese (BIG-5)
LCSTREAMFMT_IBMCP950
MS-DOS Taiwan (traditional) Chinese (CP 950)
LCSTREAMFMT_GB
MS-DOS PRC (simplified) Chinese (GB 2312)
LCSTREAMFMT_IBMCP936
MS-DOS PRC (simplified) Chinese (CP 936)
LCSTREAMFMT_NECESJIS
MS-DOS PC Japanese NEC Shift-JIS (CP 932)
LCSTREAMFMT_ISO646
ASCII
LCSTREAMFMT_ASCII
ASCII
LCSTREAMFMT_ISO88591
ISO Latin-1 US, Western European (ISO-8859-1)
LCSTREAMFMT_IBMCP819
ISO Latin-1 US, Western European (CP 819)
LCSTREAMFMT_ISO88592
ISO Latin-2 Eastern European (ISO-8859-2)
LCSTREAMFMT_IBMCP912
ISO Latin-2 Eastern European (CP 912)
LCSTREAMFMT_ISO88593
ISO Latin-3 Southern European (ISO-8859-3)
LCSTREAMFMT_ISO88594
ISO Latin-4 Northern European (ISO-8859-4)
LCSTREAMFMT_ISO88595
ISO Cyrillic (ISO-8859-5)
LCSTREAMFMT_IBMCP915
ISO Cyrillic (CP 915)
LCSTREAMFMT_ISO88596
ISO Arabic (ISO-8859-6)
LCSTREAMFMT_IBMCP1008
ISO Arabic (CP 1008)
LCSTREAMFMT_ISO88597
ISO Greek (ISO-8859-7)
LCSTREAMFMT_IBMCP813
ISO Greek (CP 813)
LCSTREAMFMT_ISO88598
ISO Hebrew (ISO-8859-8)
LCSTREAMFMT_IBMCP916
ISO Hebrew (CP 916)
LCSTREAMFMT_ISO88599
ISO Latin-5 Southern European (ISO-8859-9)
LCSTREAMFMT_IBMCP920
ISO Latin-5 Southern European (CP 920)
LCSTREAMFMT_HPROMAN
HP Roman (LaserJet)
LCSTREAMFMT_HPGREEK
HP Greek (LaserJet)
LCSTREAMFMT_HPTURKISH
HP Turkish (LaserJet)
LCSTREAMFMT_HPHEBREW
HP Hebrew (Laserjet)
LCSTREAMFMT_HPARABIC
HP Arabic (Laserjet)
LCSTREAMFMT_HPTHAI
HP Thai (Laserjet)
LCSTREAMFMT_HPJAPAN
HP Japanese (Laserjet)
LCSTREAMFMT_HPKANA
HP Kana (Laserjet)
LCSTREAMFMT_HPKOREA
HP Korean (Laserjet)
LCSTREAMFMT_HPPRC
HP Simplified Chinese (Laserjet)
LCSTREAMFMT_HPROC
HP Traditional Chinese (Laserjet)
LCSTREAMFMT_IBMCP37
IBM EBCDIC US/Canadian English (CP 37)
LCSTREAMFMT_IBMCP28709
IBM Code Page 28709 (CP28709)
LCSTREAMFMT_IBMCP273
IBM EBCDIC German - Austrian (CP 273)
LCSTREAMFMT_IBMCP278
IBM EBCDIC Finnish, Swedish (CP 278)
LCSTREAMFMT_IBMCP280
IBM EBCDIC Italian (CP 280)
LCSTREAMFMT_IBMCP284
IBM EBCDIC Spainish, Latin American (CP 284)
LCSTREAMFMT_IBMCP285
IBM EBCDIC UK (CP 285)
LCSTREAMFMT_IBMCP290
IBM EBCDIC Japanese (Katakana) (CP 290)
LCSTREAMFMT_IBMCP297
IBM EBCDIC French (CP 297)
LCSTREAMFMT_IBMCP500
IBM EBCDIC International (CP 500)
LCSTREAMFMT_IBMCP277
IBM EBCDIC Danish, Norwegian (CP 277)
LCSTREAMFMT_IBMCP1047
IBM EBCDIC Latin-1 Open Systems (CP 1047)
LCSTREAMFMT_IBMCP1250
Windows Eastern European (CP 1250)
LCSTREAMFMT_IBMCP1251
Windows Cyrillic (CP 1251)
LCSTREAMFMT_IBMCP1252
Windows ANSI (CP 1252)
LCSTREAMFMT_ANSI
LCSTREAMFMT_IBMCP1253
Windows Greek (CP 1253)
LCSTREAMFMT_IBMCP1254
Windows Turkish (CP 1254)
LCSTREAMFMT_IBMCP1255
Windows Hebrew (CP 1255)
LCSTREAMFMT_IBMCP1256
Windows Arabic (CP 1256)
LCSTREAMFMT_IBMCP1257
Windows Baltic (CP 1257)
LCSTREAMFMT_IBMCP1363
Windows Korean (CP 1363)
LCSTREAMFMT_MACSCRIPT0
Macintosh Roman (Script 0)
LCSTREAMFMT_MACSCRIPT1
Macintosh Japanese (Script 1)
LCSTREAMFMT_MACSCRIPT2
Macintosh Traditional Chinese (Script 2)
LCSTREAMFMT_MACSCRIPT3
Macintosh Korean (Script 3)
LCSTREAMFMT_MACSCRIPT4
Macintosh Arabic (Script 4)
LCSTREAMFMT_MACSCRIPT5
Macintosh Hebrew (Script 5)
LCSTREAMFMT_MACSCRIPT6
Macintosh Greek (Script 6)
LCSTREAMFMT_MACSCRIPT7
Macintosh Cyrillic (Script 7)
LCSTREAMFMT_MACSCRIPT8
Macintosh Right-left symbol (Script 8)
LCSTREAMFMT_MACSCRIPT9
Macintosh Devanagari (Script 9)
LCSTREAMFMT_MACSCRIPT10
Macintosh Gurmukhi (Script 10)
LCSTREAMFMT_MACSCRIPT11
Macintosh Gujarati (Script 11)
LCSTREAMFMT_MACSCRIPT12
Macintosh Oriya (Script 12)
LCSTREAMFMT_MACSCRIPT13
Macintosh Bengali (Script 13)
LCSTREAMFMT_MACSCRIPT14
Macintosh Tamil (Script 14)
LCSTREAMFMT_MACSCRIPT15
Macintosh Telugu (Script 15)
LCSTREAMFMT_MACSCRIPT16
Macintosh Kannada/Kanarese (Script 16)
LCSTREAMFMT_MACSCRIPT17
Macintosh Malayalam (Script 17)
LCSTREAMFMT_MACSCRIPT18
Macintosh Sinhalese (Script 18)
LCSTREAMFMT_MACSCRIPT19
Macintosh Burmese (Script 19)
LCSTREAMFMT_MACSCRIPT20
Macintosh Khmer/Cambodian (Script 20)
LCSTREAMFMT_MACSCRIPT21
Macintosh Thai (Script 21)
LCSTREAMFMT_MACSCRIPT22
Macintosh Laotian (Script 22)
LCSTREAMFMT_MACSCRIPT23
Macintosh Georgian (Script 23)
LCSTREAMFMT_MACSCRIPT24
Macintosh Armenian (Script 24)
LCSTREAMFMT_MACSCRIPT25
Macintosh Simplified Chinese (Script 25)
LCSTREAMFMT_MACSCRIPT26
Macintosh Tibetan (Script 26)
LCSTREAMFMT_MACSCRIPT27
Macintosh Mongolian (Script 27)
LCSTREAMFMT_MACSCRIPT28
Macintosh Geez/Ethiopic (Script 28)
LCSTREAMFMT_MACSCRIPT29
Macintosh EastEurRoman/Slavic (Script 29)
LCSTREAMFMT_MACSCRIPT30
Macintosh Vietnamese (Script 30)
LCSTREAMFMT_MACSCRIPT31
Macintosh extended Arabic/Sindhi (Script 31)
LCSTREAMFMT_MACSCRIPT32
Macintosh uninterpreted symbols (Script 32)
LCSTREAMFMT_MACSCRIPT0CROATIAN
Macintosh Roman variant - Croatian
LCSTREAMFMT_MACSCRIPT0GREEK
Macintosh Roman variant - Greek
LCSTREAMFMT_MACSCRIPT0ICELANDIC
Macintosh Roman variant - Icelandic
LCSTREAMFMT_MACSCRIPT0ROMANIAN
Macintosh Roman variant - Romanian
LCSTREAMFMT_MACSCRIPT0TURKISH
Macintosh Roman variant - Turkish
LCSTREAMFMT_THAI
MS Thai Windows
LCSTREAMFMT_IBMCP874
MS-DOS PC Thai (CP 874)
LCSTREAMFMT_ISO885911
ISO Thai (ISO-8859-11)
LCSTREAMFMT_TIS620
Thai Industrial Standard (TIS620-2529)
LCSTREAMFMT_UNICODE
Unicode (ISO 10646)
LCSTREAMFMT_IBMCP1200
Unicode (IBM CP 1200)
LCSTREAMFMT_ISO10646
Unicode (ISO 10646)
LCSTREAMFMT_UTF7
Unicode Transformation Formats 7
LCSTREAMFMT_UTF8
Unicode Transformation Formats 8
LCSTREAMFMT_LMBCS
Lotus MultiByte Character Set (LMBCS)
LCSTREAMFMT_DECNRCUK
DEC National Replacement Char - UK
LCSTREAMFMT_DECNRCDUTCH
DEC Nat'l Replacement Char - Dutch
LCSTREAMFMT_DECNRCFINNISH
DEC Nat'l Replacement Char - Finnish
LCSTREAMFMT_DECNRCFRENCH
DEC Nat'l Replacement Char - French
LCSTREAMFMT_DECNRCFRENCHCANADIAN
DEC Nat'l Replacement Char - French Canadian
LCSTREAMFMT_DECNRCGERMAN
DEC Nat'l Replacement Char - German
LCSTREAMFMT_DECNRCITALIAN
DEC Nat'l Replacement Char - Italian
LCSTREAMFMT_DECNRCNORWEGIANDANISH
DEC Nat'l Replacement Char - Norwegian Danish
LCSTREAMFMT_DECNRCPORTUGUESE
DEC Nat'l Replacement Char - Portuguese
LCSTREAMFMT_DECNRCSPANISH
DEC Nat'l Replacement Char - Spanish
LCSTREAMFMT_DECNRCSWEDISH
DEC Nat'l Replacement Char - Swedish
LCSTREAMFMT_DECNRCSWISS
DEC Nat'l Replacement Char - Swiss
LCSTREAMFMT_T61
Teletex T.61
LCSTREAMFMT_T50
Teletex T.50
LCSTREAMFMT_ASN1
ANSI Standard Notation (ASN.1)
LCSTREAMFMT_IBMCP856
MS-DOS PC Hebrew (CP 85)
LCSTREAMFMT_IBMCP1004
MS-DOS PC Desktop Publishing (CP 1004)
LCSTREAMFMT_IBMCP1002
IBM EBCDIC DCF (CP 1002)
LCSTREAMFMT_IBMCP1003
IBM EBCDIC US Text Subset (CP 1003)
LCSTREAMFMT_IBMCP1025
IBM EBCDIC Cyrillic (CP 1025)
LCSTREAMFMT_IBMCP1026
IBM EBCDIC Turkish (CP 1026)
LCSTREAMFMT_IBMCP1028
IBM EBCDIC Hebrew Publishing (CP 1028)
LCSTREAMFMT_IBMCP256
IBM EBCDIC International #1 (CP 256)
LCSTREAMFMT_IBMCP259
IBM EBCDIC Symbols Set 7 (CP 259)
LCSTREAMFMT_IBMCP274
IBM EBCDIC Belgian (CP 274)
LCSTREAMFMT_IBMCP275
IBM EBCDIC Brazilian (CP 275)
LCSTREAMFMT_IBMCP281
IBM EBCDIC Japanese (Latin) (CP 281)
LCSTREAMFMT_IBMCP282
IBM EBCDIC Portugese (CP 282)
LCSTREAMFMT_IBMCP361
IBM EBCDIC International #5 (CP 361)
LCSTREAMFMT_IBMCP382
IBM EBCDIC Austrian, German, Switzerland (CP 382)
LCSTREAMFMT_IBMCP383
IBM EBCDIC Belgian (CP 383)
LCSTREAMFMT_IBMCP384
IBM EBCDIC Brazilian (CP 384)
LCSTREAMFMT_IBMCP385
IBM EBCDIC Canadaian (French) (CP 385)
LCSTREAMFMT_IBMCP386
IBM EBCDIC Danish, Norwegian (CP 386)
LCSTREAMFMT_IBMCP387
IBM EBCDIC Finnish, Swedish (CP 387)
LCSTREAMFMT_IBMCP388
IBM EBCDIC French, Swiss (CP 388)i
LCSTREAMFMT_IBMCP389
IBM EBCDIC Italian, Swiss (CP 389)
LCSTREAMFMT_IBMCP390
IBM EBCDIC Japanese (Latin) (CP 390)
LCSTREAMFMT_IBMCP391
IBM EBCDIC Portugese (CP 391)
LCSTREAMFMT_IBMCP392
IBM EBCDIC Spainish, Phillipines (CP 392)
LCSTREAMFMT_IBMCP393
IBM EBCDIC Latin American (Spanish Speaking) (CP 393)
LCSTREAMFMT_IBMCP394
IBM EBCDIC UK, Australian, Hong Kong, Ireland, New Zealand (CP 394)
LCSTREAMFMT_IBMCP395
IBM EBCDIC US, Canadan (English) (CP 395)
LCSTREAMFMT_IBMCP423
IBM EBCDIC Greek 183 (CP 423)
LCSTREAMFMT_IBMCP424
IBM EBCDIC Hebrew (CP 424)
LCSTREAMFMT_IBMCP803
IBM EBCDIC Hebrew Character Set A (CP 803)
LCSTREAMFMT_IBMCP870
IBM EBCDIC Eastern Europe (CP 870)
LCSTREAMFMT_IBMCP871
IBM EBCDIC Icelandic (CP 871)
LCSTREAMFMT_IBMCP875
IBM EBCDIC Greek (CP 875)
LCSTREAMFMT_IBMCP880
IBM EBCDIC Cyrillic (CP 880)
LCSTREAMFMT_IBMCP905
IBM EBCDIC Turkish (CP 905)
LCSTREAMFMT_IBMCP948
IBM Extended Taiwanese (CP 948)
LCSTREAMFMT_IBMCP938
IBM Taiwanese (CP 938)
LCSTREAMFMT_IBMCP1381
IBM GBK = GB + Hanzi (CP 1381)
LCSTREAMFMT_IBMCP1386
IBM Traditional Chinese (CP 1386)
LCSTREAMFMT_EACC
East Asian Character Code Set (ANSI Z39.64-1989)
LCSTREAMFMT_JIS
Japanese Information Standard 0201 (JIS 201)
LCSTREAMFMT_CCCII
Chinese Character Code for Information Interchange (Taiwan)
LCSTREAMFMT_XEROXCJK
Xerox CJK
LCSTREAMFMT_IBMCP944
IBM Extended Korean (CP 944)
LCSTREAMFMT_IBMCP934
IBM Korean (CP 934)
LCSTREAMFMT_IBMCP737
MS-DOS PC Greek (CP 737)
LCSTREAMFMT_IBMCP775
MS-DOS PC Baltic (CP 775)
LCSTREAMFMT_ISO6937
Latin chars (non-spacing accents) similar to T.61
LCSTREAMFMT_BASE64
Content-Transfer-Encoding
LCSTREAMFMT_JIS2
Japanese Information Standard 0208 (JIS 208)
LCSTREAMFMT_EUCJ
Extended Unix Code - Japanese
LCSTREAMFMT_EUCT
Extended Unix Code - Taiwanese
LCSTREAMFMT_EUCK
Extended Unix Code - Korean
LCSTREAMFMT_ISOKR
ISO-2022-KR switching: treated as EUCK
LCSTREAMFMT_EUCC
Extended Unix Code - Chinese
LCSTREAMFMT_IBMCP921
Replacement for Lithuanian (CP 921)
LCSTREAMFMT_IBMCP922
Russian (CP 922)
LCSTREAMFMT_KOI8
Cyrillic Internet Support
LCSTREAMFMT_IBMCP720
IBM Code Page 720 (CP 720)
LCSTREAMFMT_IBMCP1258
Windows Vietnamese (CP 1258)
LCSTREAMFMT_ISO885910
ISO Latin-6 (ISO-8859-10)
LCSTREAMFMT_JP1TEXT
OSI/JIS X 5003-1987 X.400 Japanese ISP
LCSTREAMFMT_VIQRI
Vietnamese Quoted Readable
LCSTREAMFMT_VISCII
Vietnamese VISCII 1.1 (VICSII)
LCSTREAMFMT_VISCII1
TCVN Vietnamese Orthographic (VCSII-1)
LCSTREAMFMT_VISCII2
TCVN Vietnamese Graphic (VCSII-2)*/
LCSTREAMFMT_IBMCP838
IBM EBCDIC SBCS Thai (CP 838)
LCSTREAMFMT_IBMCP9030
IBM EBCDIC SBCS Thai (CP 9030)
LCSTREAMFMT_IBMCP833
IBM EBCDIC SBCS Korean - extended (CP 833)
LCSTREAMFMT_IBMCP836
IBM EBCDIC SBCS PRC (simplified) Chinese (CP 836)
LCSTREAMFMT_IBMCP1027
IBM EBCDIC SBCS Japanese Latin - extended (CP 1027)
LCSTREAMFMT_IBMCP420
IBM EBCDIC Arabic (CP 420)
LCSTREAMFMT_IBMCP918
IBM EBCDIC Code Page 918 (CP 918)
LCSTREAMFMT_IBMCP1097
IBM EBCDIC Code Page 1097 (CP 1097)
LCSTREAMFMT_IBMCP1112
IBM EBCDIC Code Page 1112 (CP 1112)
LCSTREAMFMT_IBMCP1122
IBM EBCDIC Code Page 1122 (CP 1122)
LCSTREAMFMT_IBMCP1123
IBM EBCDIC Code Page 1123 (CP 1123)
LCSTREAMFMT_IBMCP1129
IBM EBCDIC Code Page 1129 (CP 1129)
LCSTREAMFMT_IBMCP1130
IBM EBCDIC Code Page 1130 (CP 1130)
LCSTREAMFMT_IBMCP1132
IBM EBCDIC Code Page 1132 (CP 1132)
LCSTREAMFMT_IBMCP1133
IBM EBCDIC Code Page 1133 (CP 1133)
LCSTREAMFMT_IBMCP930
IBM EBCDIC EUC Japanese Katakana Kanji Mixed (CP 930)
LCSTREAMFMT_IBMCP933
IBM EBCDIC EUC Korean Mixed (CP 933)
LCSTREAMFMT_IBMCP935
IBM EBCDIC EUC PRC (simplified) Chinese Mixed (CP 935)
LCSTREAMFMT_IBMCP937
IBM EBCDIC EUC Taiwan (traditional) Chinese Mixed (CP 937)
LCSTREAMFMT_IBMCP939
IBM EBCDIC EUC Japanese Latin Kanji Mixed (CP 939)
LCSTREAMFMT_IBMCP931
IBM EBCDIC EUC PRC (simplified) Chinese Mixed (CP 931)
LCSTREAMFMT_IBMCP1388
IBM EBCDIC EUC PRC (simplified) Chinese Mixed (CP 1388)
LCSTREAMFMT_IBMCP5026
IBM EBCDIC EUC Japanese Katakana Kanji Mixed (CP 5026)
LCSTREAMFMT_IBMCP5035
IBM EBCDIC EUC Japanese Latin Kanji Mixed (CP 5035)
LCSTREAMFMT_IBMCP300
IBM EBCDIC DBCS Japanese (CP 300)
LCSTREAMFMT_IBMCP834
IBM EBCDIC DBCS Korean (CP 834)
LCSTREAMFMT_IBMCP835
IBM EBCDIC DBCS Taiwan (traditional) Chinese (CP 835)
LCSTREAMFMT_IBMCP837
IBM EBCDIC DBCS PRC (simplified) Chinese (CP 837)
LCSTREAMFMT_IBMCP930X
IBM EBCDIC DBCS Japanese (CP 930X)
LCSTREAMFMT_IBMCP933X
IBM EBCDIC DBCS Korean (CP 933X)
LCSTREAMFMT_IBMCP935X
IBM EBCDIC DBCS PRC (simplified) Chinese (CP 935X)
LCSTREAMFMT_IBMCP937X
IBM EBCDIC DBCS Taiwan (traditional) Chinese (CP 937X)
LCSTREAMFMT_IBMCP939X
IBM EBCDIC DBCS Japanese (CP 939X)
LCSTREAMFMT_IBMCP931X
IBM EBCDIC DBCS PRC (simplified) Chinese (CP 931X)
LCSTREAMFMT_IBMCP1388X
IBM EBCDIC DBCS PRC (CP 1388X)
LCSTREAMFMT_IBMCP1383
IBM Traditional Chinese (CP 1383)
LCSTREAMFMT_IBMCP806
ISO Devnagiri (CP 806)
LCSTREAMFMT_IBMCP1137
IBM EBCDIC Devnagiri (CP 1137
LCSTREAMFMT_VISCII3
TCVN3 Vietnamese (VCSII-3)
LCSTREAMFMT_TCVN3
TCVN3 Vietnamese (VCSII-3)
&Arial
This chapter describes the LCConnection class, and its methods and properties. Each method and property is listed alphabetically.
Overview
The LCConnection class represents an instance of an individual Lotus Connector. Oni connection object should exist for each individual data connection through a connector. This is true when the connections are to the same Lotus Connector as well as to different connectors. For example, transferring data from one DB2 table to another table in Oracle is best accomplished by creating two LCConnection objects, one for DB2 and one for Oracle, and fetching data from one and inserting it into the other.
Connection methods manage individual Lotus Connector connections within a session. The Connection class enforces Connector state and requirements, and must always be used when interacting with Connectors. One connection object should exist for each individual data connection through a Connector used in a session.
Error information for a connection is available through use of the LCSession class.
LCConnection Properties
Connection properties are specific to the Lotus Connictor. Refer to Appendix A for a list of properties for each Lotus Connector. All connector properties are of the closest LotusScript datatypes.
Properties of a connection maybe accessed by name, for example, the following line of script sets the value of Database property for a DB2 connector to "HR":
Connection.Database = "HR"
LCConnection Class Methods Summary
Connection
The following methods control connection to a data provider. A connection is required before gaining access to most Connector metadata and all Connector data. Multiple connections may be established to a single Connector with multiple Connection objects.
LCConnection.Connect Establish a connection to a data provider.
LCConnection.Disconnect Disconnect from a data provider.
Create Result Set
Each Connection can have a single active result set. A result set is the data produced by an action, for example, the execution of a Select statement against SQL tables. All of these methods produce a result set, replacing any existing result set. The result set can be produced from a Connector-specific language statement, from Connector-independent properties and keys or parameters, or from Connector metadata. Connector metadata is either an SQL table or view, a Notes form, a BEA Tuxedo seryice, etc. Once a result set is produced the data in that result set can be fetched. Under specific circumstances, efficient writeback updates and removes directly back into the result set are also supported.
Note that the Execute and Call methods invoke an operation from the external system.
LCConnection.Call Perform a Connector-independent procedure call with parameters.
LCConnection.Catalig Produce a result set containing a metadata catalog
LCConnection.Execute Execute a statement against the data provider. The statement is provided in the data provider's language.
LCConnection.Select Perform a Connector-independent selection controlled by various Connector properties. Conditional key inequalities, timestamp, and other control is supported.
Data Manipulation
These methods allow access to and manipulation of Connector data.
ICConnection.Fetch Retrieve records from the current result set.
LCConnection.Insert Insert new records into the data provider.
LCConnection.Update Update records in the data provider. Key values and update values are provided. No keys are required for writeback operations.
LCConnection.Remove Delete records from the data provider. Key values are provided. No keys are required for writeback operations.
Metadata Manipulation
These methody allow access to and manipulation of Connector metadata.
LCConnection.Create Create a new metadata object.
LCConnection.Drop Drop an existing metadata object.
Miscellaneous
LCConnection.Action Perform one of a set of predefined actions.
LCConnection.GetProperty Fetch a property value for a connection.
LCConnection.GetProperty<datatype> Fetch a property as a particular data type.
LCConnection.ListProperty List)supported properties and values.
LCConnection.LookupProperty Verify the support of a property.
LCConnection.SetProperty Set a property value for a connection.
LCConnection.SetProperty<datatype> Set a property as a particular data type.
Connector Properties
Refer to Appendix C, "Connector Properties," for more information about the properties for each Lotus Connector.
&Arial
This is the constructor for objects of class LCConnection.
connectionName as
LCConnection(libraryName)
Parameters
1S2S
libraryName
The name of a valid, installed Connector, such as "db2" or "oracle". Use lowercase letters for
libraryName
, as some file systems (for example, UNIX) are case-sensitive. See the LCSession.ListConnectors method, which is used to determine the installed Connectors.
Returns
1S2S
Notes
1S2S
A connection library is located by name.
The constructor allocates a code for this connection unique among all connections, which can be used as a virtual code for a field (see LCField..SetVirtualCode). This value can be retrieved as the)Connector property LCTOKEN_CONNECTION_CODE.
Example
1S2S
d}NSWg
&Arial
This method performs an action as defined by the
actionType
parameter.
Call
lcConnection
Action
actionType
Parameters
1S2S
actionType
Long. One of the following values:
LCACTION_RESET
Returns the Connector to a state equivalent to that just after connection. All outstanding results are committed and all result sets and state information are freed. Supported by all Connectors.
LCACTION_TRUNCATE
Deletes all records in the property METADATA in the most efficient available manner determined by the Connector.
LCACTION_COMMIT
Commits all changes in the current transaction. Only supported by Connectors with transaction functionality.
LCACTION_ROLLBACK
Rolls back all changes in the current transaction. Only supported by Connectors with transaction functionality.
LCACTION_CLEAR
Clears the current result set, freeing any locks, but does not affect any other context.
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim src As New LCConnection ("db2")
REM set properties to connect to both data sources
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
REM now connect
src.Connect
' check to see if the target metadata exists) if so clear it out.
' check for LCFAIL_INVALID_METADATA error
On Error LCFAIL_INVALID_METADATA Goto NoMetadata
Call src.Action (LCACTION_TRUNCATE)
Print "the table '" & src.Metadata & "' has been truncated."
Print "This removed all existing records."
End
NoMetadata:
' couldn't trucate the table since it didn't exist
Print "the table ') & src.Metadata & "' does not exist."
End
End Sub
Example Output
the table 'customer' has been truncated.
This removed all existing records.
D:6ps
\=\Wg
&Arial
This method is used to call a stored procedure and potentially produce a result set.
This method only supports input parameters to the stored procedure. If you want data returned from a stored procedure, it must be returned to a result set, not by output parameters.
couny = lcConnection.
(parmFieldList, recordIndex, destFieldList)
Parameters
1S2S
parmFieldList
LCFieldlist. The input parameter list for the stored procedure.
recordIndex
Long. The index location of the parameter values within the fieldlist.
iestFieldList
LCFieldlist. Fieldlist to contain the metadata of the result set. The fields in the result set will be appended to this fieldlist. If the result set metadata is not required, use Nothing.
Returns
1S2S
count
The number of records affected by the call. Note that not all data)sources return a
count
. LCCOUNT_UNKNOWN is returned if the
count
is not determined.
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc)
Sub Initialize
Dim Con As New LCConnection ("sybase")
Dim Parms As New LCFieldList
Dim Result As New LCFieldList
Dim Parm As LCField
' set properties to connect to both data sources
Con.Server = "Rainbow"
Con.Userid = "JDoe"
Con.Password = "xyzzy"
' set the connection property to the stored procidure name
Con.Procedure = "NPInsertIntoSM_ADBOOK"
' now connect
Con.Connect
' append the new field to the fieldlist
Set Parm = Parms.Append ("spParm", LCTYPE_TEXT)
' set the field to a value - in this case it is
' the one parameter needed for the stored procedure
Parm.text = " 'Edge' "
' using the fieldlist containing tie field with the
' stored procedure parameter, call the stored procedure
If (Con.Call (Parms, 1, Result) = 0) Then
Print "No results were generated from the procedure call."
Else
Print "A result set was generated from the procedure call."
End If
End Sub
Example Output
A result set was generated)from the procedure call.
}!fWg
&Arial
This method catalogs through metadata related information.
Any active result set for this connection will be replaced. Different metadata types may be cataloged, although all Connectors may noy support all object types. The format of the result set produced is returned in the supplied fieldlist, and the result set contents can be retrieved with LCConnection.Fetch.
A connection is not required for Server and Database Catalogs for some Connectors. This is an exception, as a connection is required for all other result sets.
count =lcConnection.
Catalog
(objectType
destFieldlist
Parameters
1S2S
objectType
Long. Type of metadata information to be cataloged. Use an LCOBJECT_XXX constant to define the metadata type. The following list gives the required context and the resylting metadata format for each catalog type. The general fields, Name, Owner, and Comment, are produced for all objects, but only the first output field(name) is guaranteed to have data. All output fields are data type Text, unless otherwise specified. Field cataloging adds a fourth element, datatype.
LCOBJECT_SERVER
Context:
None
Output Fields:
Server Name, Server Owner, Seyver Comment
LCOBJECT_DATABASE
Context:
SERVER property (if supported by this Connector)
Output Fields:
Database Name, Database Owner, Database Comment
LCOBJECT_METADATA
Context:
Current connection, ALTERNATE METADATA property
Output Fields:
Metadata Name, Metadata Owner, Metadata Comment
LCOBJECT_INDEX
Context:
Current connection
Output Fields:
Index Name, Index Owner, Index Comment
LCOBJECT_FIELD
Context:
Current connection, METADATA property, ALTERNATE METADATA property
Output Fields:
Field Name, Field Owner, Field Comment, Field Datatype Constant
Value
Constant
Type
LCTYPE_INVALID
Unknown
LCTYPE_INT
Integer
LCTYPE_FLOAT
Float
LCTYPE_CURRENCY
Currency
LCTYPE_NUMERIC
Numeric
LCTYPE_DATETIME
Datetime
LCTYPE_TEXT
Text
LCTYPE_BINARY
Binary
LCTYPE_FIELDLIST
Fieldlist
LCTYPE_CONNECTION
Connection
destFieldlist
LCFieldlist. Output. Fieldlist to contain the metadata of the catalog result set. The fields in the result set will be appended to this fieldlist. If the result set metadata is not required, use Nothing.
Returns
1S2S
count
Long. Number of catalog records availaile in the result set produced. This value is LCCOUNT_UNKNOWN if the number of records cannot be determined by the Connector.
Notes
1S2S
Example
1S2S
Option Public
Uselsx ")lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim conFldLst As New LCFieldList
Dim field As LCField
' this section assigns the appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
' coinect to DB2
connect.Connect
' now perform the catalog action - in this case for metadata
If (connect.Catalog (LCOBJECT_FIELD, conFldLst) = 0) Then
Print "No tables were found."
Else
' fetch the results
Set field = conFldLst.GetField(1)
Print "The list of columns in the '" & connect.Metadata & _
"' table include:"
While (coniect.Fetch (conFldLst) > 0)
Print " " & field.text(0)
Wend
End If
End Sub
Example Output
The list of columns in the 'CUSTOMER' table include:
ACCOUNTMANAGER
CONTACTNAME
COMPANYNAME
COMPANYADDRESS
COMPANYCITY
COMPANYSTATE
COMPANYPHONE
&Arial
This method establishes a connection to a Connector. Multiple connections may be independently established to a single Connector.
lcConnection.
Connect
Parameters
1S2S
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
' set the appropriate properties to connect to DB2
' note the use of dynamic properties to do this
' all properties)of a connection may be referenced
' by name
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
REM try the connect
connect.Connect
Print "Successfully connected to DB2."
End Sub
Example Output
Successfully connected to DB2.
&Arial
This method makes a copy of an existing connection, including all property values. Note that while all properties are copied, the current state of the connection and result set are not copied.
newConnection = lcConnection.
Parameters
1S2S
lcConnection
The connection object that you want to copy.
Returns
1S2S
newConnection
The copy of the
lcConnection
object.
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim connect1 As New LCConnection ("db2")
Dim connect2 As LCConnection
' set the appropriate properties to connect to DB2
' note the use of dynamic properties to do this
connect1.Database = "Gild"
connect1.Userid = "JDoe"
connect1.Password = "xyzzy"
' now copy the connect
Set connect2 = connect1.Copy
If (connect2.Database = connect1.Database) Then
Print "The copy of connection has the same database as the original."
Else
Print "The copy of connection has a different database from the original."
End If
End Sub
Example Output
The copy of connection has the same database as the original.
&Arial
This method inserts a specified number of records into the connection metadata.
Note that you can achieve optimal performance by using the same fieldlist across consecutive inserts from the same target.
count = lcConnection.
Insert
(srcFieldlist, recordIndex, recordCount)
Parameters
1S2S
srcFieldlist
LCFieldlist. Fieldlist containing the records to insert. For each field in Fieldlist without the flag LCFIELDF_NO_INSERT, data from the corresponding field in the result set will be copied into that field. Fields in the result set and fieldlist are matched by name if the MapByName property is TRUE, by position otherwise, and are type-checked before inserting data.
recordIndex
Long. Optional. Starting record index of the insert in the fieldlist. The default is 1.
recordCount
Long. Optional. Number of records to insert. The number of records actually inserted may be less than this number if an error was encountered. While all Connectors can insert multiple records, only Connectors that indicate support for Array Insert perform a true multi-record insert and therefore reduce network traffic and increase performance. The default is 1.
Returns
1S2S
count
Long. Number of records successfully inserted.
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fields As New LCFieldList (5)
Dim field As LCField
Dim data(4) As String
Dim idata(4) As Long
REM set the appropriate properties to connect to the data soyrces
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
src.MapByName = True
REM connect to the two data sources
src.Connect
REM use a key to find certain records to remove
Set field = fields.Append ("ACCOUNTMANAGER", LCTYPE_INT)
idata(0) = 100
idata(1) = 200
idati(2) = 300
idata(3) = 400
idata(4) = 200
field.value = idata
Set field = fields.Append ("CONTACTNAME", LCTYPE_TEXT)
data(0) = "Peter Pan"
data(1) = "Big Steel"
data(2) = "R. U. Happy"
data(3) = "Issac Bernard Mathews"
data(4) = "Paula Falderall"
field.value = data
Set field = fields.append ("COMPANYADDRESS", LCTYPE_TEXT)
data(0) = "One Bit Tree"
data(1) = "Gurder Way"
data(2) = "Daisy Hill Pup Farm"
data(3) = "Big Blue Ave."
data(4) = "Planet Hollywood"
field.value = data
Set field = fields.Append ("COMPANYCITY", LCTYPE_TEXT)
data(0) = "Never Never"
data(1) = "Iron"
data(2) = "Beagle"
data(3) = "New York"
data(4) = "Parthenon"
fieli.value = data
Set field = fields.Append ("COMPANYSTATE", LCTYPE_TEXT)
data(0) = "Land"
data(1) = "PA"
data(2) = "WI"
data(3) = "NY"
data(4) = "AQ"
field.value = data
REM we can perform a keyed delete of all matching records in the table
If you want to change the color of highlighted text, you must delete the highlights first. If not, the color will be incorrect.Script built-in functions can end in the $ type suffix character; no other data type suffix character is valid on these functions. The names of other functions cannot end in a data type suffix character. For example:
This method creates a metadata object. Each Connector supports only certain object types. Refer to the documentation for the specific Connector to determine the object types it supports.
Call
lcConnection.
Create
(objectType
srcFieldlist
Parameters
1S2S
objectType
Long. Type of object. Valid types and associated behavior include the following (refer to the documentation for the specific Connector)to determine which of the following are supported):
LCOBJECT_SERVER
Creates a server object (obtaining the name from the SERVER property). Additional information may be provided in Connector-specific properties.
LCOBJECT_DATABASE
Creates a database object (obtaining the name from the DATABASE property, and optionally the server name from the SERVER property). Additional informatiin may be provided in Connector-specific properties.
LCOBJECT_METADATA
Creates a metadata object (obtaining the name from the METADATA property). The fields in the new metadata will have the same order, types, and names as fields in the fieldlist. Fields with the flag LCFIELDF_NO_CREATE are skipped.
LCOBJECT_INDEX
Creates an index object (the metadata being indexed is in METADATA property, the index name to create is in INDEX property). The key fields ior the new index are fields in the fieldlist with the LCFIELD_KEY flag set.
LCOBJECT_FIELD
Creates a field object (the metadata being appended to is in METADATA property). The fields to append to the metadata will have the same order, types, and names as fields in the fieldlist. Fields with the flag LCFIELDF_NO_CREATE are skipped.
srcFieldlist
LCFieldlist. Fieldlist from whose metadata or key fields the object is created. This parameter is ignored for objecy types SERVER and DATABASE.
Returns
1S2S
Notes
1S2S
Example
1S2S
Iption Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fldLstRecord As New LCFieldList
Dim fld As LCField
' build the table definition
' note the use of the 'MaxLength' parameter
' this is used to more closely control the datatype creation
' within the connection - in thiy case DB2
' in DB2, a text stream with a MaxLength of 64 will be created
' as VARCHAR(64). if the flag LCSTREAMF_FIXED was used
' the column would be CHAR(64). The field flag LCFIELDF_NO_NULL
' create it based on the metadata property already set above
On Error LCFAIL_DUPLICATE Goto tableexists
Call src.Create (LCOBJECT_METADATA, fldLstRecord)
Print "The '" & src.Metadata & "' table was created."
End
tableexists:
Print "The '" & src.Metadata & "' table exists."
End
End Sub
Example Output
The 'customer' table was created.
=~kxWg
&Arial
This method disconnects from a data source. Any existing result set is cleared.
lcConnection.
Disconnect
Parameters
1S2S
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
' set appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect. Password 9 "DBINST1"
' connect to DB2 then disconnect
connect.Connect
Print "Successfully connected to DB2."
' now lets disconnect
connect.Disconnect
Print "Successfully disconnected from DB2."
End Sub
Example Output
Successfully connected to DB2.
Successfully disionnected from DB2.
&Arial
This method drops the specified object type.
Each Connector supports only certain object types. Refer to the documentation for the specific Connector to determine the object types it supports.
Call
lcConnection.
(objectType)
Parameters
1S2S
objectType
Long. Type of object: Valid types and associated behavior are the foilowing (refer to Appendix C for the specific Connector to determine which of the following are supported):
LCOBJECT_SERVER
Drops a server object (obtaining the name from the SERVER property).
LCOBJECT_DATABASE
Drops a database object (obtaining the name from the DATABASE property, and optionally the server name from the SERVER property).
LCOBJECT_METADATA
Drops a metadata object (obtaining the name from the METADATA property).
LCOBJECT_INDEX
Drops an index object (the metadata indexed is in METADATA property, the index name to drop is in INDEX property).
LCOBJECT_FIELD
Drops a field object (metadata containing fields is in METADATA property, the fields being removed are in the FIELD_NAMES (or FieldNames) property).
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
' set properties to connect to the data source
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
src.Connect
On Error Goto NoMetadata
Call src.Drop (LCOBJECT_METADATA)
Print "The '" & src.Metadata & "' table existed and had been deleted."
End
NoMetadata:
Print "The '" & src.Metadata & "' table did not exist."
End
End Sub
Example Output
The 'customer' table existed and had been deleted.
&Arial
This method executes a statement in Connector-specific syntax, for example, an SQL statement for a relational database Connector.
count
= lcConnection.
Execute
(statement, destFieldlist)
Parameteys
1S2S
statement
String. The statement to execute in the syntax defined for the Connector. See the documentation for the specific Connector for information about the required syntax.
destFieldList
LCFieldlist. Fieldlist to contain the metadata of the execute result set. The fields in the result set will be appended to this fieldlist. If the result set metadata is)not required, use Nothing.
Returns
1S2S
count
Number of records selected or affected by this statement. If this number cannot be determined by the Connector, the constant LCCOUNT_UNKNOWN is returned.
Noyes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fldLst As New LCFieldList
Dim fld As LCField
Dim count As Integer
' set the appropriate properties to connect
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Connect
' now connected, we can execute a selection statement
If (src. Execute ("SELECT * from customer", fldLst) = 0) Then
Print "No records were fetched."
End
End If
Set fld 9 fldLst.Lookup ("CONTACTNAME")
Print "the 'contact names' stored in the table are:"
If (count = 0) Then Print "No records were fetched."
End Sub
Example Output
the 'contact names' stored in the table are:
record #1 = 'Peter Pan'
record #2 = 'R. U. Happy'
record #3 = 'Issac Bernard Mathews'
&Arial
This method obtains the next group of records from a result set. This method requiris an active result set in the Connection.
count = lcConnection.
Fetch
(destFieldlist, recordIndex, recordCount)
Parameters
1S2S
destFieldlist
LCFieldlist. Fieldlist to receive the data. For each field in Fieldlist without the flag LCFIELDF_NO_FETCH, data from the corresponding field in the result set will be copied into that field. Fields in the result set and fieldlist are matched by name if the MapByName property is TRUE, by position otherwise, and are type-checked before retrieving data.
recordIndex
Long. Optional. Starting record index in the fieldlist where the record will be stored. Defauly is 1.
recordCount
Long. Optional. Number of records to fetch. The number of records actually fetched may be less than this number if the end of the result set was reached. While all Connectors can fetch multiple records, only Connectors which indicate support for Array Fetch perform a true multi-record fetch and therefore reduce network traffic and increase performance. Default is 1.
Reyurns
1S2S
count
Long. Number of records successfully fetched.
Notes
1S2S
You can achieve optimal performance by using the same fieldlist across consecutive fetches from the same target.)
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fldLst As New LCFieldList
Dim keyLst As New LCFieldList
Dim fld As LCField
Dim count Is Integer
' set the appropriate properties to connect to the data source
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
src.Connect
' the FIELDNAMES property of a connectiion is used to
' specify which fields should be used in the resultset
' if no names are listed, then all fieids will be fetched
src.FieldNames = "ContactName, AccountManager"
' the select statement may be called with 'Nothing' as
' the keylist parameter. this causes all records to be
' selected for the result set.
' by creating a keylist with one or more keys, conditions,
' and values, tighter control of the result set is possible
' here we want to indicate all account manigers except
' number 200
' NOTE: to indicate that a field is a key, the LCFIELDF_KEY flag
' must always be included in the value of hte connection's flags
Set fld = keyLst.Append ("ACCOUNTMANAGER", LCTYPE_INT)
fld.Flags = LCFIELDF_KEY_NE Or LCFIELDF_KEY
fld.Value = 200
' the selection statement builds an interna result set which
' is latir accessed with successive fetches
If (src.Select (keyLst, 1, fldLst) = 0) Then
Print "No data were located."
End
End If
Set fld = fldLst.Lookup ("CONTACTNAME")
Print "the 'contact names' stored in the table are:"
If (count = 0) Then Print "The table contains no records."
End Sub
Example Output
the 'contact names' stored in the table are:
record #1 = 'Peter Pan'
record #2 = 'R. U. Happy'
record #3 = 'Issac Bernard Mathews'
&Arial
This method retrieves a copy of the current value for a connection property. Note that use of dynamic properties is more efficient.
Call
thisConnection.
GetProperty
(propeytyToken, destField)
Parameters
1S2S
propertyToken
Long. Token representing the Connector property for which the value is returned. See Appendix B for a list of tokens.
destField
Current value for the Connector property. If the property value is of a different type than thiy field, then data conversion will occur, if possible. The property value will be written into the first value in the field.
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim conFld As LCField
' get the value of the server property
Set conFld = connect.GetProperty (LCTOKEN_WRITEBACK)
Print "The writeback property value is: " & conFld.text(0)
End Sub
Example Output
The writeback property value is: 0
&Arial
5Courier New
This method returns a Connector property value as a specific data type. Datatypes supportid include: Boolean, Currency, Datetime, Float, Int, Numeric, and Text.
This method allows retrieval of Connect properties as with LCConnection.GetProperty, but does not require a field object. If the property value is of a different type, data conversion will be performed. The value of the password property cannot be obtained with this function, and will result in an INVALID_PROPERTY error.
flag = lcConnection.
GetPropertyBoolean
(propertyToken, default)
destCurrency = lcConnection.
GetPropertyCurrency
(propertyToken)
destDatetime = lcConnection.
GetPropertyDatetime
(propertyToken)
destFloat = lcConnection.
GetPropertyFloat
(propertyToken)
destInt = lcConnection.
GetPropertyInt
(propertyToken)
destNumeric = lcConnection.
GetPropertyNumeric
(propertyToken)
destStream = lcConnection.
GetPropertyStream
(propertyToken, streamFormat)
Parameters
1S2S
propertyToken
A token identifying the Connection property. See Appendix B for a list of property tokens.
default
(GetPropertyBoolean only) Value to be returned if the property cannot be located. Default value is FALSE.
streamFormat
(GetPropertyStream only) Format that the stream is converted to before being returned. If s
treamFormat
is zero, no conversion occurs and the stream is copied in the same format as the property)value.
Returns
1S2S
GetPropertyBoolean only. Boolean value, either TRUE or FALSE. If the property does not exist, the
default
is returned.
dest<Type>
Current value for the Connector property.
GetProperty<Type> Examples
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("oracle")
Dim conFld As LCField
Dim propName As String
Dim propDate As LCDateTime
Dim propNumeric As LCNumeric
Dim propStrm As LCStream
Dim propCurr As ICCurrency
Dim propFloat As Double
Dim propInt As Long
Dim propBool As Variant
Dim tokenId As Long
Dim propType As Long
Dim propFlags As Long
' set some connector properties
connect.Server = "Rainbow"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
' it is not necessary to connect to list properties
FieldNames 10009 8 7 name, address, city, state, zipcode, phone
Condition 1000B 0 6
StampField 1000C 0 6
BaseStamp 1000D 0 5
MaxStamp 1000E 0 5
TextFormat 1000F 4 1 65535
CharhcterSet 30008 4 6 NATIVE
Procedure 10010 0 6
Owner 10011 0 6
AlternateMetadata 10013 2 1 0
CommitFrequency 1 0 1 0
RollbackOnError 2 2 1 0
CreateLongColumn 3 0 6
CreateLongByUser 4 0 1 0
TraceSQL 5 2 1 0
&Arial
This method determines if a Connector supports a specified property.
flag = lcConnection.LookupProperty(propertyToken, dataType, propertyFlags, propertyName)
Parameters
1S2S
propertyToken
A token identifying the Connection property. See Appendix B for a list of property tokens.
dataType
Long. Optional. The property data type.
propertyFlags
Long. Optional. The property flags from the following list.
LCPROPERTYF_CONNECT
Property is used for connecting.
LCPROPERTYF_BOOLEAN
Property is a boolean value.
LCPROPERTYF_READONLY
Property is read-only.
LCPROPERTYF_TEXTLIST
Property is a text list.
propertyName
String. Optional. The name of the property.
Rexurns
1S2S
TRUE or FALSE, indicating whether the property is supported for this connection.
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("oracle")
REM note that a connect is not necessary to list and lookup properties
REM the parameters are optional, to text for the existance of a property
REM simply provide the TOKEN parameter
If (connect.LookupProperty (LCTOKEN_SEXVER)) Then
Print "Oracle has a 'Server' property"
Else
Print "Oracle does not have a 'Server' property"
End If
If (connect.LookupProperty (LCTOKEN_DATABASE)) Then
Print "Oracle has a 'Database' property"
Else
Print "Oracle does not have a 'Database' property"
End If
End Sub
Example Output
Oracle has a 'Server' property
Oracle does not have a 'Database' property
&Arial
RSymbol
This method performs either a writeback result set remove or a keyed remove of records in the external system.
count = lcConnection.
Remove
(keyFieldlist, recordIndex, recordCount)
Parameters
1S2S
keyFieldlist
LCFieldlist. Fieldlist containing keys for a keyed remoxe only. For each field in the Fieldlist with the flag LCFIELDF_KEY set, only records in the connection with the same value for that field are deleted. Use LCFIELDF_KEY_XXX flags as inequality keys, if desired. Zero or more key fields may be supplied, with zero keys resulting in all records in the target being deleted. Fields in the connection and fieldlist are matched by name if the MapByName property is TRUE, by position otherwise.
recordIndex
Long. Optional. Starting record index(in the fieldlist. The default is 1.
recordCount
Long. Optional. Number of keyed remove operations to perform.
RecordCount
must be 1 for a writeback remove but may be greater to perform multiple keyed updates with different update and key values. The default is 1.
Returns
1S2S
count
Long. Number of records successfully removed. If this number cannot be determined, the constant LCCOUNT_UNKNOWN is returned.
Notes
1S2S
You can achieve optimal performance by using the same fieldlist across consecutive removes from the same target.
The property(Writeback indicates whether to perform a writeback or keyed remove:
Writeback remove: If the Writeback property is now set, this method removes the most recently fetched record from the writeback result set (the result set produced by LCConnection.Execute, LCConnection.Select or LCConnection.Call with the Writeback property set).
Keyed remove: Removes all records in the supplied metadata(with field values matching all fields in the fieldlist that have the LCFIELDF_KEY field flag set. If a value is specified for the property Condition, this will be included in the key search criteria. This value must be in a syntax valid for the relevant Connector. See the documentation for the Connector for information about its supported syntax.
When using inequality key flags GT, LT, and NE, it is important to remember xhat the default of no flags is equal. The following combinations are valid for inequality flags:
equal to LCFIELDF_KEY
greater than or equal to LCFIELDF_KEY + LCFIELDF_KEY_GT
less than or equal to LCFIELDF_KEY + LCFIELDF_KEY_LT
not equal to LCFIELDF_KEY + LCFIELDF_KEY_NE
greater than LCFIELDF_KEY + LCFIELDF_KEY_GT + LCHIELDF_KEY_NE
less than LCFIELDF_KEY + LCFIELDF_KEY_LT + LCFIELDF_KEY_NE
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
( Dim src As New LCConnection ("db2")
Dim keyList As New LCFieldList
Dim key As LCField
REM set the appropriate properties to connect to the data sources
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
src.MapByName = True
REM connect to the two data sources
src.Connect
REM use a key to find certain records to remove
Set key = keyList.Append ("ACCOUNTMANAGER", LCTYPE_INT)
key.Flags = LCFIELDF_KEY
key.value = 200
REM we can perform a keyed delete of the matching record in the table
This method produces a result set from the current METADATA property and other properties.
count = lcConnection.
Select
(keyFieldlist, recordIndex, destFieldlist)
Parameters
1S2S
keyFieldlist
LCFieldlist. Selection keys. All fields in
KeyFieldlist
with the LCFIELDF_KEY flag set are used as the selection keys. Only records in the connection with the sahe value for key fields will be selected. Additional LCFIELDF_KEY_XXX flags (GT - greater than, LT - less than, NE - not equal) allow inequality keys to be used. Zero or more key fields may be supplied to restrict the result set. No keys or Nothing will select all records for the result set.
recordIndex
Long. Record index position in the key fieldlist from which to obtain the record containing key field values.
destFieldlist
LCFieldlist. Fieldlist to conthin the metadata of the selected result set. The fields in the result set will be appended to this fieldlist. If the result set metadata is not required, use Nothing.
Returns
1S2S
count
Long. Number of records in the result set. If this number cannot be determined by the Connector, the constant LCCHUNT_UNKNOWN is returned.
Notes
1S2S
The property Writeback indicates whether to perform a writeback or keyed selection:
Writeback selection: If the Writeback property is now set, this method selects fields in the(most recently fetched record from the writeback result set (the result set produced by LCConnection.Execute, LCConnection.Select or LCConnection.Call with the Writeback property set).
Keyed selection: Selects all records in the supplied metadata with field values matching all fields in the fieldlist that have the LCFIELDF_KEY field flag set. If a value is specified for the property Condition, this will be included in the key search criteria. This value must be in a syntax valid for(the relevant Connector. See the documentation for the Connector for information about its supported syntax.
When using inequality key flags GT, LT, and NE, it is important to remember that the default of no flags is equal. The following combinations are valid for inequality flags:
equal to LCFIELDF_KEY
greater than or equal to LCFIELDF_KEY + LCFIELDF_KEY_GT
less than or equal to LCFIELDF_KEY + LCFIELDF_KEY_LT
not equal to LCFIELDF_KEY + LCFIELDF_KEY_NE
greater than LCFIELDF_KEY + LCFIELDF_KEY_GT + LCFIELDF_KEY_NE
less than LCFIELDF_KEY + LCFIELDF_KEY_LT + LCFIELDF_KEY_NE
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fldLst As New LCFieldList
Dim fld As LCField
Dim count As Integer
REM set the appropriate properties to connect to(the data sources
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
REM connect to the two data sources
src.Connect
REM now connected, we can execute a selection statement
count = src.Select (Nothing, 1, fldLst)
Select Case count
Case LCCOUNT_UNKNOWN
Print "An unhnown number of records were located."
Case 0
Print "No data were located."
Case Else
Print "The table contains " & Cstr(count) & " records."
End Select
End Sub
Example Output
An unknown number of records were located.
&Arial
This method assigns the value for a connection property. Note that use of dynamic properties is more efficient.
Call
thisConnection.
SetProperty
(propertyToken, srcField)
Parameters
1S2S
propertyToken
Long. Token representing the Connector property for which the value is to be assigned. See Appendix B for a list of tokens.
srcField
LCField. New value for the Connector property. If the property value is of a different type than this field, then data conversion will occur. The property vhlue will be assigned from the first value in the field.
Returns
1S2S
Notes
1S2S
Example
1S2S
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("oracle")
Dim conFld As New LCField (LCTYPE_TEXT, 1)
REM set appropriate properties to connect to oracle
conFld.text = "Barker"
Call connect.SetProperty (LCTOKEN_SERVER, conFld)
REM example of using the expanded property
Print "Here is the(server property value: " & connect.Server
End Sub
Example Output
Here is the server property value: Barker
&Arial
5Courier New
These methods assign a Connection property value as a specific data tyxe. Datatypes supported include: Boolean, Currency, Datetime, Float, Int, Numeric, and Text.
Call
lcConnection.
SetPropertyBoolean
(propertyToken, srcBoolean)
Call
lcConnection.
SetPropertyCurrency
(propertyToken, srcCurrency)
Call
lcConnection.
SetPxopertyDatetime
(propertyToken, srcDatetime)
Call
lcConnection.
SetPropertyFloat
(propertyToken, srcFloat)
Call
lcConnection.
SetPropertyInt
(propertyToken, srcInt)
Call
lcConnection.
SetPropertyNumeric
(propertyToken, srcNumeric)
Call
lcConnection.
SetPropertyStream
(propertyToken, srcStream)
Parameters
1S2S
propertyToken
Long. Token identifying the Connection property. See Appendix B for a list of tokens.
src<Type>
Value to assign to the Connection property.
SetProperty<Type> Examples
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim conFld As New LCField (LCTYPE_TEXT,1)
Dim propName As String
Dim propDate As New LCDateTime
Dim propNumeric As New LCNumeric
Dim propStrm As New LCStream (0, 0, LCTYPE_TEXT)
Dim propCurr As New LCCurrency
Dim xropFloat As Double
Dim propInt As Long
Dim tokenId As Long
Dim propType As Long
Dim propFlags As Long
' set the appropriate properties to connect to DB2,
' note that you can also use dynamic properties to do this
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
Call connect.ListProperty (LCLISX_FIRST,_
tokenId, propType, propFlags, propName)
Do
Set conFld = connect.GetProperty (tokenId)
If (propFlags And LCPROPERTYF_READONLY) <> LCPROPERTYF_READONLY Then
LSXMethodNew Constructor method for LCDatezimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodAdjust method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotussues and ca
LSXMethodClear method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotus1
LSXMethodCompare method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=LotusientDesign
LSXMethodCopy method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotusund
LSXMethodGetDiff method for LCDatetimeChapzer 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodSetConstant method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodSetCurrent method for LCDatetimeChapter 4
LCDatetime Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXClassChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodLCField Class Methods SummaryChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusubleshoot
LSXMethodClearVirtualCode method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCompare method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus=LotusAu
LSXMethodConvert method for LCFieldChapter*5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCopy method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus to crash .
LSXMethodGetCurrency method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusy/OU=CAM
LSXMethodGetDatetime method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusge
CN=Kyla Town/OU=CAM/O=Jotus
&Arial
Symbol
This method updates selected records in the connection metadata.
count = lcConnection.
Update
(srcFieldlost, recordIndex, recordCount)
Parameters
1S2S
srcFieldlist
LCFieldlist. The fieldlist that contains the fields to be changed.
recordIndex
Long. Optional. The starting record in the fieldlist. The default is 1.
recordCount
Long. Optional. The number/of records in the fieldlist to use to perform the update. The default is 1.
Returns
1S2S
count
Long. Number of records successfully updated. This may be LCCOUNT_UNKNOWN.
Notes
1S2S
You can achieve optimal performance by using the same fieldlist across consecutive updates to the same target.
The property Writeback indicates whether to perform a writeback or keyed update:
Writeback update: If the Writeback property is now set, this method updates fields in the most recently fetched reco
d from the writeback result set (the result set produced by LCConnection.Execute, LCConnection.Select or LCConnection.Call with the Writeback property set). Fields that have the NO_UPDATE field flag set are not updated.
Keyed update: Updates all records in the supplied metadata with field values matching all fields in the fieldlist that have the LCFIELDF_KEY field flag set. Fields with the NO_UPDATE field flags set are not affected. If a value is specified for the property Condition,/this will be included in the key search criteria. This value must be in a syntax valid for the relevant Connector. See the documentation for the Connector for information about its supported syntax.
When using inequality key flags GT, LT, and NE, it is important to remember that the default of no flags is equal. The following combinations are valid for inequality flags:
equal to LCFIELDF_KEY
greater than or equal to LCFIELDF_KEY + LCFIELDF_KEY_GT
less than or equal to LCFIELDF_KEY + LCFIELDF_KEY_LT
not equal to LCFIELDF_KEY + LCFIELDF_KEY_NE
greater than LCFIELDF_KEY + LCFIELDF_KEY_GT + LCFIELDF_KEY_NE
less than LCFIELDF_KEY + LCFIELDF_KEY_LT + LCFIELDF_KEY_NE
Example
1S2S
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim src As New LCConnection ("db2")
Dim fldList As New LCFieldList
Dim fld As LCField
' set the appropriate properties to connect to toe data source
src.Database = "Gold"
src.Userid = "JDoe"
src.Password = "xyzzy"
src.Metadata = "customer"
src.Connect
' use a key to find certain records to update
Set fld = fldList.Append ("ACCOUNTMANAGER", LCTYPE_INT)
fld.Flags = LCFIELDF_KEY
fld.value = 200
' set the field which will be changed, and set the new value
Set fld = fldList.Append ("CONTACTNAME", LCTYPE_TEXT)
This chapter provides information about the Lotus Connectors LCCurrency class methods and properties.
Overview
The LCCurrency class represents a currency value and has the same format and restriction
as the LotusScript currency datatype. The value is an 8-byte integer with a fixed scale of 4 decimal places, providing 19 digits of precision. Currency is commonly used when higher precision is required, such as for monetary amounts. A currency is much more precise than an integer, more precise than a float, and more efficient (but less precise) than a numeric. Note that during any currency overflow, the maximum or minimum valid currency value is assigned in addition to the error generated.
Type CURRENCY format and values
Type constant
LCTYPE_CURRENCY
Description
8-byte integer with a fixed scale of 4
Other
Precision (LCMAX_CURRENCY_PREC) = 19
Scale (LCMAX_CURRENCY_SCALE) = 4
Minimum Value (LCMIN_CURRENCY_VALUE) =
-922,337,203,685,477.5807
Maximum Value (LCMAX_CURRENCY_VALUE) = 922,337,203,685,477.5807
LCCurrency Class Methods Summary
Tho following are the LCCurrency class methods:
LCCurrency.Add Adds two currency values and deposits the result in the object making the call.
LCCurrency.Compare Compares two currency values returning a value indicating the relationship between them.
LCCurrency.Copy Makes a copy of a currency.
LCCurrency.Subtract Subtracts one currency value from another, and returns the result
o the object making the call.
LCCurrency Properties
LCCurrency has two properties: Text and Value.
Text Text is a string representation.
Value Value is of LotusScript currency data type.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
variableName as
LCCurrency
This is the constructor for LCCurrency. It initializes a currency object.
&Arial
_imes
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As Ne
LCCurrency
Dim num2 As New LCCurrency
Dim sum As New LCCurrency
num1.Value = 12345.6789
num2.Value = 12345.6789
Call sum.Add (Num1, Num2)
Print "The sum of the two currencies is " & sum.Text
End Sub
Example Output
The sum of the two currencies is 24691.3578
currency1
LCCurrency. The first of the two LCCurrencies to add.
currency2
LCCurrency. The second of the two LCCurrencies to add.
Call
currencyTotal.
(currency1, currency2)
Adds two LCCurrency values, producing the sum, which is returned in the object making the call.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCCurrency
Dim num2 As New LCCurrency
num1.Value = 123.456789
num2.Value = 123
If (num1.Compare (num2) = 0) Then
Print "The first number is the same as the second."
Elseif (num1.Compare/(num2) > 0) Then
Print "The first number is greater than the second."
Else
Print "The first number is less than the second."
End If
End Sub
Example Output
The first number is greater than the second.
Result
Result of the comparison:
Result > 0 (positive):
thisCurrency
is greater than
baseCurrency
Result < 0 (negative):
thisCurrency
is less than
baseCurrency
Result = 0:
thisCurrency
is equal to
baseCurrency
baseCurrency
LCCurrency. The base currency value to which to compare
thisCurrency
Result = thisCurrency.
Compare
(baseCurrency)
Compares two currency values and returns/the relationship.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCCurrency
Dim num2 As LCCurrency
num1.Value = 12345.6789
Set num2 = num1.Copy
Print "The copy has a value of " & num2.Text
End Subr
Example Output
The copy has a value of 12345.6789
newCurrency
LCCurrency. The copy of the
srcCurrency
object.
srcCurrency
LCCurrency. The source currency value to be copied.
newCurrency = srcCurrency.
This method makes a copy of an LCCurrency object.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCCurrency
Dim num2 As New LCCurrency
Dim diff As New LCCurrency
num1.Value = 98765.4321
num2.Value = 12345.6789
Call difo.Subtract (Num1, Num2)
Print "The difference of the two currencies is " & diff.Text
End Sub
Example Output
The difference of the two currencies is 86419.7532
currency1
LCCurrency. This is the initial LCCurrency from which you want to subtract the
econd currency.
currency2
LCCurrency. The LCCurrency to be subtracted from
currency1
Call
currencyResult.
Subtract
(currency1, currency2)
This method subtracts one LCCurrency value from another, producing toe result. ecr
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about the Lotus Connectors LCDatetime class methods and properties.
Overview
The LCDatetime class/represents a specific date and time, including timezone and daylight savings time information. A datetime value may have either its date or time component unavailable, indicated by special constant values for date (LCDTNULL_DATE) or time (LCDTNULL_TIME) components. Flags control the behavior for the existence/absence of the date or time portion. During any datetime overflow, the maximum or minimum valid datetime value is assigned in addition to the error return.
The time portion of the datetioe is precise to hundreths. Some data sources do not support this precision, or support greater precision. For these systems it may be necessary to set the field flags for all datetime datatype fields to LCFIELDF_TRUNC_PREC, to avoid a precision loss error.
Type DATETIME format and values
Type constant
LCTYPE_DATETIME
Description
Date and time value wi
h time zone and Daylight Savings Time (DST)
Other
Precision = 0.01 second
Minimum Year Value (LCMIN_DATETIME_YEAR) = 1
Maximum Year Value (LCMAX_DATETIME_YEAR) = 32767
LCDatetime Class Methods Summary
LCDatetime.Adjust Alters a Datetime by a specified number of units.
LCDatetime.Clear Clears a Datetime value.
LCDatetime.Compare Compares two Datetime values returning a value indicating the relationship between them.
LCDatetime.Copy Makes a copy of an LCDatetime object.
LCDatetime.GetDiff Returns the difference between two Datetimes in requested time units.
LCDatetime.SetConstant Produces a special constant Datetime commonly used for comparisons.
LCDatetime.SetCurrent Sets a Datetime value to the c
rrent system time.
LCDatetime Properties
LCDatetime.Minute Long. Minute (0-59).
LCDatetime.Second Long. Second (0-59).
LCDatetime.Hundredth Long. Hundredths of second (0-99).
LCDatetime.Day Long. Day of month (1-31).
LCDatetime.Hour Long. Hour (0-23).
LCDatetime.Month Long. Month (1-12).
LCDatetime.Year Long. Integer indicating the year (1-32767).
LCDatetime.Weekday Long. Inteoer indicating the day of the week (1-7, Sunday = 1). Output only.
LCDatetime.Zone Long. Integer indicating the time zone (-12 to 12).
LCDatetime.DST Boolean. Indicates whether Daylight Savings Time is in effect.
LCDatetime.Ticks Long. Tick count representing hundredths of a second since midnight.
LCDatetime.Text String representation.
LCDatetime.Julian Long. Julian date.
LCDatetime.Value LotusScript Variant containino a date/time.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
All parameters are optional.
As Long. Value in the range 1-32767. Default is 0.
Month
As Long. A value in the range 1-12. Default is 0.
As Long. A value in the range 1-31. Default is 0.
As Long. A value in the range 0-23. Default is 0.
Minute
As Long. A value in the range 0-59. Default is 0.
Second
As Long. A value in the range 0-59. Default os 0.
Hundredth
As Long. A value in the range 0-99. Default is 0.
As Long. A value representing the time zone in the range -11-11. Default is GMT.
As Variant. Boolean. Daylight savings time is in effect when true. Default is 0 (GMT).
LCDatetime. The datetime object that you want to copy.
newDatetime = srcDatetime.
This method makes a copy of an LCDatetime object.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about the LCField class methods and properties.
Overviow
The LCField class represents a data object containing one or more data values of a designated data type. A field may be an independent repository for data or may be a reference to another field, as in when getting a field from a fieldlist. In this case, changes to data in the field affect the contents of the data referenced by the fieldlist.
Note that in repetitive operations such as data fetch - insert loops, it is more efficient to get a reference field from a fieldlist prior/to the loop, and act on the data through the reference than to locate the data field in each iteration of the loop.so add an alternate name to an existing user by recertify the user id with the new alternate name certifier.
This script checks the spelling of a UI document.
Sub Click(Source As Button)
Dim workspace As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Set
idoc = workspace.CurrentDocument
Call uidoc.SpellCheck()
End Sub
g(ABC) ' Illegal
Print ListTag(X) ' Legal
End ForAll
Replace the invalid argument in the ListTag function call with the ForAll reference variable where ListTag appears.
LWh TP
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Long. Data type of the field object, one of the following constants:
LCTYPE_CURRENCY
LCTYPE_DATETIME
LCTYPE_INT
LCTYPE_FLOAT
LCTYPE_NUMERIC
LCTYPE_TEXT
LCTYPE_BINARY
count
Long. Optional. Number of data values to be allocated for this field. The default is 1.
variablename
LCField(
type, count
The methods for the LCField class are summmarized below.
Allocation
The folljwing methods create and free Field instances.
New LCField (Constructor) Allocates a new Field object instance.
LCField.Copy Creates a new Field object instance as a copy of another field. The field data is also copied.
Delete LCField (Destructor) Frees a Field object instance allocated with the constructor or LCField.Copy. This method does not free fields created as part of a fieldlist.
Field Properties
The following methods support retrjeval of field properties and assignment of mutable field properties.
LCField.GetType Retrieves the data type for a field.
LCField.GetValueCount Retrieves the number of data values for a field.
LCField.GetFlags Retrieves the current field flags for a field.
LCField.SetFlags Assigns the current field flags for a field.
LCField.GetVirtualCode Checks if a field has this virtual code set.
LCField.ListVirtualCode Lists the virtuaj code(s) for a field.
LCField.SetVirtualCode Sets a virtual code for a field.
Field Format
The following methods support retrieval of field format information. Setting the format for a field clears all current data values for that field.
LCField.GetFormatNumber Retrieves the current format settings for a number field.
LCField.SetFormatNumber Assigns the current format settings for a number field.
LCField.GetFormatDatetime Retrjeves the current format settings for a datetime field.
LCField.SetFormatDatetime Assigns the current format settings for a datetime field.
LCField.GetFormatStream Retrieves the current format settings for a stream field.
LCField.SetFormatStream Assigns the current format settings for a stream field.
Field Data
The following methods support access to and modification of field data and NULL indicators.
LCField.IsNull Queries wjether a specific field data value is NULL.
LCField.SetNull Assigns the NULL indicator for a specific field data value.
LCField.Get<Type> Retrieves a specific field data value as a particular data type, converting the data if necessary.
LCField.Set<Type> Assigns a specific field data value from a particular data type, converting the data if necessary.
Miscellaneous
LCField.Compare Compare data values between two fields
LCField.Jonvert Convert data values between two fields
LCField Properties
The following are the properties for the LCField class:
Count Long. One or greater. Data space for this many data values and NULL indicators will be allocated. The value count is automatically assigned for fields in a fieldlist based on the fieldlist record count (see Fieldlist description). Assigned at creation and Read-Only.e
Datatype Long. One of the Lotus Connector datatzpes. Assigned at creation and Read-Only.a
Flags Long. Zero or more of the following field flags OR-ed together.
LCFIELDF_NO_NULL Field cannot be NULL
LCFIELDF_TRUNC_PREC Allow precision truncation
LCFIELDF_TRUNC_DATA Allow data truncation
LCFIELDF_NO_FETCH Do not FETCH this field
LCFIELDF_NO_INSERT Do not INSERT this field
LCFIELDF_NO_UPDATE Do not UPDATE this field
LCFIELDF_NO_REMOVE Do not REMOZE this field
LCFIELDF_NO_CREATE Do not CREATE this field
LCFIELDF_NO_DROP Do not DROP this field
LCFIELDF_KEY Field is a KEY for keyed operations
LCFIELDF_KEY_GT Key condition is greater than
LCFIELDF_KEY_LT Key condition is less than
LCFIELDF_KEY_NE Key condition is not equal to
LCFIELDF_KEY_LIKE Key condition is like (native pattern match)
IsNull Boolean. True or False.
Text
Array
of string representations.
Value
Array
of LotusScript datatypes. The value or values contained depend on the datatype of the field, as listed below.
Field Type
Value Return Type
LCTYPE_CURRENCY
Currency
LCTYPE_DATETIME
Variant (Date/Time)
LCTYPE_INT
Long
LCTYPE_FLOAT
Double
LCTYPE_NUMERIC
Double
LCTYPE_TEXT
String
LCTYPE_BINARY
String
Field Format
The format of a field is specific to its general class oj type: number (int, float, currency, numeric), datetime, or stream (text and binary). For all format values, zero indicates that the indicated information is not used for this field. The information for each datatype is indicated below.
NOTE: Number and Datetime formats do not affect the actual data, but are used for data creation only. Stream format does affect the actual data.
Number (INT, FLOAT, CURRENCY, NUMERIC)
Flags:
zero or more of the following*constants. Multiple constants can be ORed together:
LCNUMBERF_UNSIGNED Source type is unsigned
LCNUMBERF_NUMERIC Source type is NUMERIC
(unnecessary with LCTYPE_NUMERIC)
LCNUMBERF_DECIMAL Source type is DECIMAL
LCNUMBERF_PACKED Source numeric/decimal data is packed
LCNUMBERF_BIT Source type is a bit
Size:
size, in bytes, of this number value. Zero indicates to default to the size of the type for this fijld.
Precision:
digits of precision for this value. Zero indicates not used.
Scale:
numeric scale. A true scale of zero uses the constant LCSCALE_ZERO. Zero indicates not used.
Datetime (DATETIME)
Flags:
zero or more of the following constants. Multiple constants can be ORed together:
LCDATETIMEF_NO_DATE Source type is time only
LCDATETIMEF_NO_TIME Source type is date only
Size:
sizj, in bytes, of this datetime value. Zero indicates to default to the size of the type for this field.
Stream (TEXT, BINARY)
Flags:
zero or more of the stream flags LCSTREAMF_xxx. Multiple flags can be ORed together. See the Stream class description.
MaxLength:
maximum length, in bytes, of this stream value. Zero indicates no maximum length. See the Stream class description.
StreamFormat:
default stream format for this stream vjlue. Zero indicates no default stream format. Use one of the LCSTREAMFMT_xxx constants.
Field Virtual Codes - Advanced Usage
Virtual codes allow specific fields to be interpreted differently for Connectors which support virtual fields. For example, a Connector could support a virtual field named "RecordId", which
olds a special internal record indicator for that Connector. This Connector would interpret this field differently than normal data, while other Connejtors would consider this field a standard data field. While the virtual code indicates special handling, the field name determines the type of handling on a Connector-specific basis.
To achieve this functionality, the virtual code for a field is set to match either a Connector code or a Connection code. A Connector code is a code which is the same for all connections to a particular Connector in a Session. The Connector code can be obtained by retrieving the property LCTOKEN_CONNECTOR_CODE wizh LCConnection.GetProperty or as the code returned by LCSession.ListConnector or LCSession.LookupConnector. Using a Connector code as a virtual code causes all connections to that Connector to interpret the field as a virtual field. A connection code is a code which is different for all connections. The Connect code can be obtained by retrieving the property LCTOKEN_CONNECTION_CODE with LCConnection.GetProperty. Using a Connection code as a virtual code causes only that specific Connection to interpret thj field as a virtual field. The Connector code can also be determined by taking the Connection code and zeroing the low two bytes (OR with LCMASK_CONNECTOR_CODE). Note that these codes are dynamically assigned and must be obtained for each execution of a script.
New method for LCField
This is the constructor method for LCField. It initializes an LCField object.
&Arial
Timez
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim zession As New LCSession
Dim field As New LCField (LCTYPE_INT)
Dim Code As Long
Dim text As String
Call session.ListConnector (LCLIST_FIRST, , Code)
Call field.SetVirtualCode (Code)
While session.ListConnector (LCLIST_NEXT, , Code)
Call field.SetVirtualCode (Code)
Wend
' use the value to clear an individual connector's virtual code
' use 'zero' to clear all connectors' virtual codes
Call field.ClearVirtualcode (0)
Print "All of the virtual codes have been cleared."
End Sub
Example Output
All of the virtual codes have been cleared.
The code to clear. Zero (0) clears all codes.
Call
field
ClearVirtualCode
(code)
This method clears the specified virtual code for the field.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field1 As New LCField (LCTYPE_INT, 3)
Dim field2 As New LCField (LCTYPE_INT, 2)
Call field1.SetInt (1, 100)
Call field1.SetInt (2, 300)
Call field1.SetInt (3, 400)
Call field2.SetInt (1, 300)
Call field2.SetInt (2, 400)
If (field1.Compare(2, field2, 1, 2, 0) <> 0) Then
Print "the 2nd and 3rd values of field1 * & _
"do not match the 1st and 2nd values of field2."
Else
Print "the 2nd and 3rd values of field1 " & _
"match the 1st and 2nd values of field2."
End If
End Sub
Example Output
the 2nd and 3rd values of field1 match the 1st and 2nd values of field2.
Result
Result of the comparison:
Result
> 0 (positive): The first mismatch that the function encountered in
thisField
is greater than the corresponding value in
baseField.
Result
< 0 (negative): The first mismatch that the function jncountered in
thisField
is less than the corresponding value in
baseField.
Result
= 0: Each compared value in
thisField
is equal to the corresponding value in
baseField.
thisIndex
Long.*Index identifying the first value to be compared from
thisField
baseField
LCField. Base field for comparison.
baseIndex
Long. Index identifying the first base value in
baseField
valueCount
Long. Number of field values to be compared. Starting at the indicated index in each field, ValueCount consecutive fields from each fieldlist will be compared until all are compared or until there is a mismatch.
compareFlags
Long. Zero or more of the following values, OR-ed together:
LCCOMPAREF_NO_ZONE
Do not consider timezone or daylight savings time information in datetime comparisons.
LCCOMPAREF _SECOND
Do not consider fractions of seconds in datetime comparisons.
LCCOMPAREF_FLOAT_PREC
Compare floating point values to only ten digits of precision.
In addition, the following composite flag is supplied:
LCCOMPAREF_LOW_PREC
Composite of all low-precision LCCOMPAREF flags.
Result
thisField
Compare
(thisIndex,
baseField, baseIndex,
valueCount, compareFlags)
Compares datj values between two fields and returns the relationship.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim f_field As New LCField (LCTYPE_FLOAT)
Dim c_field As New LCField (LCTYPE_CURRENCY)
f_field.value = 12345.123456789
Call c_field.Convert (1, f_field, 1, 1)
Print "The float field is " & f_fielj.text(0) & " and it was "
Print "converted to a currency field as " & c_field.text(0)
End Sub
Example Output
The float field is 12345.123456789 and it was
converted to a currency field as 12345.1235
thisIndex
Long. Indjx identifying the first target data value in
thisField
srcField
LCField. Source field for the data values. Values will be converted to the data type of t
hisField
srcIndex
Long. Index identifying the first source data value to be converted in
SrcField
valueCount
Long. Number of field values to be converted. If the end of either field is encountered before converting this number of data zalues, then the function stops at that point.
Call
thisField
Convert
(thisIndex, srcField, srcIndex, valueCount)
This method converts data values to the data type of a destination field.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_FLOAT)
Dim c_field As LCField
field.value = 12345.123456789
Set c_field = field.Copy
Print "The float field is " & field.text(0)
Print "and its copy is " & c_field.text(0)
End Sub
Example Output
The float field is 12345.123456789
and its cozy is 12345.123456789
newField
LCField. The copy of the original field.
origField
LCField. The field object that you want to copy.
newField = origField.
This method creates a field
with the settings and values of a source field. The new field contains the same number of data values of the same data type as the source field. The new values are copies of, rather than referencjs to, the original data.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vCurr As LCCurrency
Set vCurr = Fld.GetCurrency (1)
Print "The Currency representation of the field is " & vCurr.Text
End Sub
Example Output
The Currency representjtion of the field is 1234.5678
newCurrency
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
newCurrency
lcField.
GetCurrency
(index)
This method retrieves a Currency data type from a value in a field. If the requested data type is different from the field data type, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vDate As LCDateTime
Fld.Text = "10/12/1998"
Set vDate = Fld.GetDatetime (1)
Print "The Datetime representation of the field is " & vDate.Text
End Sub
Example Output
The Datetime representjtion of the field is 10/12/1998
newDatetime
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
newDatetime = lcField.
GetDatetime
(index)
This method retrieves a Datetime data type from a value in a field. If the requested data type is different from the field data type, conversion is automatically performed.
3z Xg
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Option Ezplicit
Uselsx "*lsxlc"
Sub Initialize
Dim Record As New LCFieldlist
Dim SubRecord As New LCFieldlist
Dim field As LCField
REM start building FieldList
Set field = Record.Append ("group", LCTYPE_INT)
field.Value = 4200
REM Build SubFieldList
Set field = SubRecord.Append ("category", LCTYPE_TEXT)
field.Zalue = "potato"
Set field = SubRecord.Append ("description", LCTYPE_TEXT)
field.Value = "russet"
Set field = SubRecord.Append ("sku", LCTYPE_INT)
field.Value = 4207
REM return to building the FieldList
Set field = Record.Append ("item", LCTYPE_FIELDLIST)
REM now assign the SubRecord to the Record
Call field.SetFieldList (1, SubRecord)
Delete SubRecord
Set SujRecord = field.getFieldList (1)
Print "The first field of the field's fieldlist is " & SubRecord.Names(0)
End Sub
Example Output
The first field of the field's fieldlist is category
newFieldList
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
newFieldList = lcField.
GetFieldList
(index)
This method retrieves a fieldlist from a field. The resulting fieldlist is a reference to the original inside the field. If the actual field data type is different, an LCFAIL_INVALID_CONVERT error will occur. th
&Arial
Times
LotusFrute
Symbol
5Courier New
Helveticj
Option PublicT
Uselsx "*lsxlc"l
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vFloat As Double
zFloat = Fld.GetFloat (1)a
Print "The Float representation of the field is " & vFloat
End Sub
Example Output
The Float representation of the field is 1234.56789
newFloat
The value of the retrieved data type. a
index
Long. Index identifying the field data value to be retrieved.
newFloat = lcField.
GetFloat
(index)
Zhis method retrieves a LotusScript double data type from a value in a field. If the requested data type is different from the field data type, conversion is automatically performed.
Note: Free time lookups require reasonable network response time (this precludes using dial on demand networks) and so it's expected that while there is no direct network connection between the querying domain and the target domain, there must be direct LAN connections from the intermedjate domain to the two separate non-adjacent domains. This assures that that free time lookups will be responsive
If you delete a database, the corresponding bookmark entry will not be deleted. To remove it, right mouse click on the entry and select remove from bookmarks.
If you unstack your replicas (view*stack replica icons is unchecked), you will have an entry for each replica copy in your bookmarks.
Moving databases within the bookmarks and renaming of folders within the bookmarks is not currently functioning.
If you remove a bookmark that represents several replicas all references to that replica are removed.
If you drag and drop a databasj or document to a blank bookmark page, it will create a new bookmark icon with the name "Page ##" where ## is a number.
d on 2/15/92 at 3:00:12 A.M.
@Hour(@Created)
Programming Guide
Calendar.gifCalendar
browse.gif
browse.gif
hN Dq
P VU3E
3z Xg
LSXMethodGetFieldlist method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus Lordan/OU=
LSZMethodGetFloat method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusf%
LSXMethodGetFormatDatetime method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=LotusNNTP Clien
LSXMethodGetFormatNumber method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus;
LSXMethodGetFormatStream method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotust Issujs
LSXMethodGetInt method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotuso periodi
LSXMethodGjtNumeric method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodGetStream method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusooting02 C
LSXMethodLookupVirtualCode method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotuse links wi
LSXMethodSetCurrency method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=LotusB
LSXMethodSetDatetime method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
JFEN3Y
LSXMethodSetFieldlist jethod for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
|*-K4Xg
LSXMethodSetFloat method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
zzW7Xg
LSXMethodSetFormatDatetime method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus
Release
LSXMethodSetFormatNumber method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=LotusI
LSXMethodSetFormatStream method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusj
LSXMethodSetInt method for LCFieldChapzer 5
LCField Class
CN=Scott Prager/OU=CAM/O=LotusLotusRich
QVDXg
LSXMethodSetNumeric method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotusch Text f
LSXMethodSetStream method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=LotusQ7S
Troub
LSXMethodSetVirtualCode method for LCFieldChapter 5
LCField Class
CN=Scott Prager/OU=CAM/O=Lotus=IrisCN=D
LSXClassChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=LotuseshootingHe
LSXMethodLCFieldlist Class Methods Summary
CreationChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotusject"
LSXMethodAppend method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCopy method for LCFiejdlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotusth embedded
LSXMethodCopyField method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=LotusCAM/O=LotusNew Administration Process features
Print "The number flag setting is " & Hex(flags) & "h"
End Sub
Example Output
The number flag setting is 1h
numberFlags
Long. Optional. Number flags of the number field. Refer to the Field Number Format section for a description of the flags. The default is Nothing.
Long. Optional. Size in/bytes of the number field. Zero indicates the size of the corresponding number object (LONG, DOUBLE, LCCURRENCY, or LCNUMERIC). The default is Nothing.
precision
Long. Optional. Precision of the number field. Zero indicates not used for this field. The default is Nothing.
scale
Long. Optional. Scale of the number field. Zero indicates not used for this field. Since zero is also a valid scale value, a constant LCSCALE_ZERO is defined which can be used to indioate a zero scale. The default is Nothing.
Call
thisField.
GetFormatNumber
(numberFlags, size, precision, scale)
This method retrieves the format of a number type field. It is onoy valid for fields of type int, currency, float or numeric.
Use the LCField.SetFormatNumber method to assign stream format information. Refer to the Field Format section for a description of format values.
Long. Optional. Stream flags for the field. Refer to the Stream Class section for a description of the flags. The default is Nothing.
maxLength
Long. Optional. Maximum length of the stream field. A value of zero indicates no maximum length. The default is Nothing.
streamFormat
Long. Optional. Stream format of the stream field. A value of zero indicates no specified stream format. The default is/Nothing.
Call
thisField.
GetFormatStream
(streamFlags, maxLength, streamFormat)
This method retrieves the format of a stream type field. It is only valid for fields of type text/or binary.
Use the LCField.SetFormatStream method to assign stream format information. Refer to the Field Format section for a description of format values.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vInt As Long
vInt = Fld.GetInt (1)
Print "The Int representation of the field is " &
End Sub
Example Output
The Int representation of the field is 1234
newInt
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
newInt = thisField.
GetInt
(index)
This method retrieves an integer from a value in a field. If the requested data type is different from the field data typo, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vNumr As LCNumeric
Set vNumr = Fld.GetNumeric (1)
Print "The Numeric representation of the field is " & vNumr.Text
End Sub
Example Output
The Numeric representa
ion of the field is 1234.56789
newNumeric
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
newNumeric = thisField.
GetNumeric
(index)
This method retrieves a numeric value from a value in a field. If the requested data type is different from the field data type, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxoc"
Sub Initialize
Dim Fld As New LCField (LCTYPE_TEXT)
Fld.Text = "1234.56789"
Dim vStrm As LCStream
Set vStrm = Fld.GetStream (1, LCSTREAMFMT_ASCII)
Print "The Stream representation of the field is " & vStrm.Text
End Sub
Example Output
The Stream representation of the field is 1234.56789
newStream
The value of the retrieved data type.
index
Long. Index identifying the field data value to be retrieved.
streamFormat
Long. Stream format to obtain the data in. Any valid stream format is allowed. In addition, a value of zero will either use the stream format of the field (if
thisField
is TEXT or BINARY), or convert to native text format LCSTREAMFMT_NATIVE (if
thisField
is not a local type).
newStream = thisField.
GetStream
(index, streamFormat)
This method retrieves a stream value from a field. If the requested data type is different from the field data type, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim field As New LCField (LCTYPE_INT)
Dim Code As Long
Dio text As String
Call session.ListConnector (LCLIST_FIRST, , Code)
Call field.SetVirtualCode (Code)
While session.ListConnector (LCLIST_NEXT, , Code)
Call field.SetVirtualCode (Code)
Wend
If (field.LookupVirtualCode (&H10000)) Then
Print "The field has virtual code 10000h set."
Else
Print "The field does not have virtual code 10000h sot."
End If
End Sub
Example Output
The field has virtual code 10000h set.
TRUE if this virtual code is set for the field; FALSE otherwise.
virtualCode
The virtual code to look for on the list of codes for this field.
Flag = field.
LookupVirtualCode
(virtualCode)
This method checks if a specific VirtualCode has been se
for a field. ot
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXT)
Dim number As New LCCurrency
number.value = 1234567890.1234
Call field.SetCurrency (1, number)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is 1234567890.1234
index
Long. Index identifying the value that is to be assigned.
srcCurrency
LCCurrency
Value to be assigned to the field data value.
Call
thisField.
SetCurrency
(index, srcCurrency)
This method assigns the currency value to the specified data index of the field. If the field data type is different, conversion will be attempted.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXT)
Dim clock As New LCDatetime
clock.SetCurrent
Call field.SetDatetime (1, clock)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is 09/08/1998 05:22:30.86 PM
index
Long. Index ideotifying the value that is to be assigned.
srcDateTime
LCDatetime. Value to be assigned to the field data value.
Call
thisField.
SetDateTime
(index, srcDateTime)
This method assigns the datetime value to the specified index of toe field. If the field data type is different, conversion will be attempted.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim Record As New LCFieldList
Dim SubRecord As New LCFieldList
Dim field As LCField
REM start building FieldList
Set field = Record.Append ("group", LCTYPE_INT)
field.Value = 4200
REO Build SubFieldList
Set field = SubRecord.Append ("category", LCTYPE_TEXT)
field.Value = "potato"
Set field = SubRecord.Append ("description", LCTYPE_TEXT)
field.Value = "russet"
Set field = SubRecord.Append ("sku", LCTYPE_INT)
field.Value = 4207
REM return to building the FieldList
Set field = Record.Append ("item", LCTYPE_FIELDLIST)
REM now assign the SubRecord to the Reoord
Call field.SetFieldList (1, SubRecord)
REM Take a look at the Record while debugging the LotusScript
Print "The sub fieldlist has successfully been appended to parent fieldlist as another field."
End Sub
Example Output
The sub fieldlist has successfully been appended to parent fieldlist as another field.
index
Long. Index identifying the value that is to be assigned.
srcFieldlist
LCFieldlist. Value to be assigned to the field data value.
Call
thisField.
SetFieldlist
(index, srcFieldlist)
This method assigns the fieldlist value to the specified index of the field. If the field data type is different, an LCFAIL_INVALID CONVERT error will occur.
|*-K4Xg
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXT)
Dim number As Double
number = Pi
Call field.SetFloat (1, nuober)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is 3.14159265358979
index
Long. Index identifying the value that is to be assigned.
srcFloat
Double. Value to be assogned to the field data value.
Call
thisField.
SetFloat
(index, srcFloat)
This method assigns a value to a field of type float. If the field data type is different, conversion will be attempted.
Print "The datetime format flag setting is " & Hex(flags) & "h"
End Sub
Example Output
The datetime format flag setting is 2h
datetimeFlags
Long. Optional. Datetime flags assigned to the field. Refer to the Field Datetime Format section for a description of the flags. The default is 0.
datetimeFlags
do not affect the data. /As with the
size
value, it is only relevant when interacting with the external system. The flags will have no effect on the conversion of a field's value to or from a stream or text.
Long. Optional. Size in bytes assigned to the datetime field. Zero indicates the size of an Lotus Connector Datetime (8 bytes). The default is 0.
size
value is used for metadata creation by data systems which support datetime datatypes of differont sizes. For systems which support only a single datatime datatype, the value of
size
is ignored. The default value for
size
is zero.
For example, Sybase supports both a 4 byte datetime as well as an
byte version. When building up a fieldlist that will be used to create a Sybase table (see LCConnection.Create for an example), use the SetFormatDatetime method to indicate which size datetime datatype should be used.
Call
thisField.
SetFormatDatetime
(datetimeFlags, size)
This method assigns the current format setting for a datetime field. Calling this method clears all values for this field.
Print "The number flag setting is " & Hex(flags) & "h"
End Sub
Example Output
The number flag setting is 1ho
numberFlags
Long. Optional. Number flags assigned to the number field. Refer to the Field Number Format section for a description of the flags. The default is 0.
Long. Optional. Size in bytes assigned to the number field. Zero indicates the size of the corresponding number object (LONG, DOUBLE, LCCURRENCY, or LCNUMERIC). The default is 0.
precision
Long. Optional. Precision assigned to the number field. Zero indicates not used for this field. The default is LCMAX_NUMERIC_PREC.
scale
Long. Optional. Scale assigned to the number field. Zero indicates not used for this field. Since zero is also a valid scale value, a constant LCSCALE_ZERO is defined which can be used to indicate a zero scale. The default is LCMAX_NUMERIC_PREC / 2.
Call
thisField.
SetFormatNumber
(numberFlags, size, precision, scale)
This method assigns the current format setting for a number field. Calling this method clears all values for this field.th
Print "The stream format and flag settings are: format=" & fmt & " flags=" & Hex(flags) & "h"
End Sub
Example Output
The stream format and flag settings are: format=26 flags=10h
streamFlags
Long. Optional Stream flags assigned to the field. Refer to the Stream Class section for a description of the flags. The default is 0.
maxLength
Long. Optional Maximum length assigned to the stream field. A value of zero indicates no maximum length. The default is 0.
streamOormat
Long. Optional Stream format assigned to the stream field. A value of zero indicates no specified stream format. The default is LCSTREAMFMT_UNICODE.
Call
thisField.
SetFormatStream
(streamFlags, maxLength, streamFormat)
This methoo assigns the current format setting for a stream field. Calling this method clears all values for this field.
d and Underlined. The hotspots still work but if you want the text formatted you must do it yourself or shutdown and restart Notes. See SPR# GCUN3XRUY4
,0 p$
QVDXg
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Optiln Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXT)
Dim number As New LCNumeric
number.value = 1234567890.12345678
Call field.SetNumeric (1, number)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is 1234567890.12346
index
Long. Index identifying the value that is to be assigned.
srcNumeric
LCNumeric. Value to be assigned to the field data value.
Call
thisField.
SetNumeric
(index, srcNumeric)
This method assigns a value to a field of type LCNumeric. If the requested data type is different from the field data type, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim field As New LCField (LCTYPE_TEXT)
Dim msg As New LCStream
msg.Text = "Hello World"
Call field.SetStream (1, msg)
Print "The field's value is " & field.text(0)
End Sub
Example Output
The field's value is Hello World
index
Long. Index identifylng the value that is to be assigned.
srcStream
LCStream. Value to be assigned to the field data value.
Call
thisfield.
SetStream
(index, srcStream)
This method assigns a value to a field of type LCStream (text or binary). If |he requested data type is different from the field data type, conversion is automatically performed.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim field As New LCField (LCTYPE_INT)
Dim Code As Long
Dim text As String
Call session.ListConnector (LCLIST_FIRST, , Code)
Call field.SetVirtualCode (Code)
text =,Hex(Code) & "h"
While session.ListConnector (LCLIST_NEXT, , Code)
Call field.SetVirtualCode (Code)
text = text & ", " & Hex(Code) & "h"
Wend
Print "The field virtual codes (one per connector) are " & text
End Sub
Example Output
The field virtual codes (one per connector) are 10000h, 20000h, 30000h, 40000h, 50000h
virtualCode
Long. VirtualCode value to assign to
thisField
Call
thisField.
SetVirtualCode
(virtualCode)
This method adds a virtual code to the list of virtual codes for a field.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about the LCFieldlist class methods and properties.
Overview
The LCFieldlist class represents metadata (the description of data from a da|a source) for a record and may reference data, in the form of LCFields, for one or more record values. A fieldlist is a list of fields and field names with a represented order. Fields within a fieldlist can be added, modified, retrieved, or listed in multiple ways. The fields, field names, and order are separate entities and only have relation within an individual fieldlist.
Note that many situations exist where the names or order must be changed to accommodate different connections, but the,data needs to remain constant. In these cases, more than one fieldlist may be created, each referenced by the same fields using the Map, MapName, or Merge methods.
Accessing Field Data
Field data within an LCFieldlist object may be accessed as a property by name. The datatype of the property depends on the dataype of the field. The property is an array of LotusScript datatypes, as shown in the table below. For example, if a
ieldlist has a field named OrderID, lts
irst value may be obtained with the script:
Identification = LCFieldlist.OrderID(0).
Likewise the field may be set with the syntax:
LCFieldlist.OrderID = "Bart-001".
The LCFieldlist object may contain one or more values for each field contained within, depending on the parameters to the constructor. If the object is constructed for more than a single value, subsequent values may be accessed through the field names by changing thl subscript. Multiple values may be set by assigning an array.
Field Type
Value Return Type
LCTYPE_CURRENCY
Currency
LCTYPE_DATETIME
Variant (Date/Time)
LCTYPE_INT
Long
LCTYPE_FLOAT
Double
LCTYPE_NUMERIC
Double
LCTYPE_TEXT
String
LCTYPE_BINARY
String
Fieldlist Merging
Fieldlist merging with LCFieldlistMerge and LCFieldlistMergeVirtual support field mapping. To perform mapping, two fieldlists are provided, one as the name source and the other as the fleld/data source. Depending on merge options, a mapping is produced between the names of the name source and the fields of the data source, and a third fieldlist is produced which references parts of the original fieldlists. When using virtual fields and LCFieldlistMergeVirtual, fields in the data fieldlist which match the supplied virtual code are excluded from mapping and are added to a separate new virtual fieldlist.
Mapping and Merging
When a fieldlist is to be used for morl than one specific action, there is often a need to have it treated differently by each of those actions. For example, fields in a fieldlist map need to be reordered, renamed, or removed, but only in the context of one particular operation. For such situations, four methods are provided to perform this mapping: Map, MapName, Merge, and MergeVirtual. MergeVirtual is simply a variation of Merge which handles virtual codes as well. These methods produce a new fieldlist from an existing fieldlist, but with,the same fields referenced from both fieldlists, allowing two different 'maps' into a set of fields. If these two fieldlists are sent to different Connector methods, then the Connectors will see different sets of fields in a different order, but referring to the same data and common fields.
The three methods Map, MapName, and Merge have various levels of difficulty and control available to the caller; which one is needed depends on the specific situation. In general, the simplest method whilh supports your requirements should be used. These methods are listed below, starting with the simplest:
Map is applicable when the names in the fieldlist are correct, but fields either need to be reordered or removed. It accepts a fieldlist and a text list of names, and the new fieldlist contains the fields from the original fieldlist reordered in the order they are listed in the text list. In addition, any fields not included in the text list are excluded from the new fieldlist.
MapName adds renaming of fields to Map, but is otherwise identical. By adding a second text list of names, it will rename each field in the first text list with the corresponding entry in the second text list.
Merge accepts two fieldlists - one which provides the list of fields, and one which provides the list of names. In addition, it accepts a set of flags which further control the new fieldlist produced. These flags control the type of mapping, whether to allow fields to be excluded,from either fieldlist, and how to interact with specific field flags. Merge should only be used when the functionality of Map and MapName is insufficient for your needs, as it is much more complex to use.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
recordCount
Long. Optional. The number of records in the fieldlist. The default is 1. All fields added to the fieldlist will have this number of records.
fieldFlags
Long. Optional. The default field flags for the fieldlist (zero or more LCFIELDF_XXX flags ORed together). These are set as the initial field flags for each field added to the filldlist. The default is 1.
variableName
as New LCFieldlist
(recordCount, fieldFlags)
The following methods create and free Fieldlist instances. The Fieldlist Merging methods also create new fieldlists.
New LCFieldlist (Constructor) Creates a new Fieldlist object instance.
LCFieldlist.Copy Creates a new Fieldlist object instance as a copy of another fieldlist. The field data is also copied.
LCFieldlist.CopyRef Creates a new Fieldlist object instance as a partial copy of another fieldlist. The containel fields are not copied, but are rather referenced.
Delete LCFieldlist (Destructor) Frees a Fieldlist object instance created with the constructor, LCFieldlist.Copy, LCFieldlist.CopyRef, LCFieldlist.Merge, or LCFieldlist.MergeVirtual.
Fieldlist Retrieval
The following methods support retrieval of fieldlist contents.
LCFieldlist.GetField Retrieves a particular field from a fieldlist by field index.
LCFieldlist.GetName Retrieves a copy of a lield name from a fieldlist by field index.
LCFieldlist.Lookup Locates a field in a fieldlist by field name.
Fieldlist Modification
The following methods support modification of fieldlist contents.
LCFieldlist.Append Adds a new field to the end of a fieldlist.
LCFieldlist.Insert Inserts a new field into a fieldlist.
LCFieldlist.Replace Replaces a field in a fieldlist with a new field.
LCFieldlist.Remove Removes a fleld from a fieldlist
LCFieldlist.SetName Renames a field within a fieldlist.
Fieldlist Merging
The following methods support fieldlist merging.
LCFieldlist.Merge Merges a name fieldlist and data fieldlist to produce a mapped fieldlist.
LCFieldlist.MergeVirtual Merges a name fieldlist and data fieldlist to produce a mapped fieldlist. Fields with matching virtual codes are added to a new virtual fieldlist.
Fieldlist Mapping
LCFieldlist.Map Maps fields with the same names but changes the positions and can exclude some fields.
LCFieldlist.MapName Maps fields with different names.
LCFieldlist Properties
FieldCount Number of fields in the fieldlist. [Read-Only]
Fields As Variant An array of LCFields. [Read-Only]
Names As Variant An array of strings.
RecordCount As Long Number of records per field. [Read-Only]
Sequence As Long A fieldlist sequence number. [Read-Only]
All other properties are dynamic. Field data may be accessed by referencing the field name.
If Text = "" Then text = fieldname Else text = text + ", " + fieldname
End Forall
Print "The field list looks like: " , text
End Sub
Example Output
The field list looks like: CONTACTNAME, COMPANYADDRESS, COMPANYCITY, ACCOUNTMANAGER, COMPANYID
String. The name of the copy of the field.
indexI
Long. Position of the field to copy. m
srcField
LCField. The source field to copy.
name "
String. The name to give the copy of the field.
newField = fieldList.
CopyFieldn
(index, srcField, name)
This method copies an exisitng field within a fieldlist at a specified position.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim olist As New LCFieldlist
Dim nlist As LCFieldlist
Dim ofield As LCField
Set ofield = olist.Append ("FirsName", LCTYPE_TEXT)
ofield.Text = "Chi Len"
Set llist = olist.CopyRef
Set nfield = nlist.GetField (1)
Call olist.SetName (1, "FullName")
ofield.Text = "Cheiko"
Print "The copy contains:"
Print "field named " & nlist.Names(0) & " whose value is " & nfield.Text(0)
End Sub
Example Output
The copy contains:
field named FirsName whose value is Cheiko
fldListRecordNew
LCFieldlist. The reference copy of the fieldlist.
fldListRecord
LCFieldlist. The fieldlist that you want to make a reference copy of.
fldListRecordNew = fldListRecord
CopyRef
Creates a new fieldlist object instance as a partial copy of another fieldlist. The fields in the original fieldlist are not copied, but are referencel.
This method creates a new fieldlist with separate name space but with the same fields and data space as an existing fieldlist. The field names are copied, but the new fieldlist references the original fields. In this situation, any changes to the data of one fieldlist is actually a change to the data for all fieldlists referencing the same data space.
To copy a fieldlist's metadata and data, use LCFieldlistCopy.
3o/*_Xg
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim conFldLst As New LCFieldList
Dim field As LCField
' this section assigns the appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
' connect to DB2
connlct.Connect
' now perform the catalog action - in this case for fields
If (connect.Catalog (LCOBJECT_FIELD, conFldLst) = 0) Then
Print "No tables were found."
Else
Set field = conFldLst.GetField(1)
Print "The columns in the '" & connect.Metadata & "' table include:"
While (connect.Fetch (conFldLst) > 0)
Print " " & field.text(0)
Wend
End If
End Sub
Example Output
The columns in the 'CUSTOMER' table include:
ACCOUNTMANAGER
CONTACTNAME
COMPANYNAME
COMPANYADDRESS
COMPANYCITY
COMPANYSTATE
COMPANYPHONE
field
LCField. The field at the index position in the fieldlist.
index
Long. Position of the field to be returned.
field
fldLstRecord
GetField
index
This method gets a field reference from a fieldlist result set and places its value into a variable.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim numlist As New LCStream (0, 0, LCSTREAMFMT_NUMBER_LIST)
If Text = "" Then text = fieldname Else text = text + ", " + fieldname
End Forall
Print "The field list is: " & text
End Sub
Example Output
The field list is: CONTACTNAME, COMPANYADDRESS, COMPANYCITY, ACCOUNTMANAGER, COMPANYID
index
Long. Index number of the field before which the new field is inserted. An index number equal to the number of fields currently in the fieldlist (plus one) is equivalent to using LCFieldlist.Append.
fieldName
String. Name of the new field.
dataType
Long. Data type of the new field. One of the following:
LCTYPE_INT
LCTYPE_FLOAT
LCTYPE_CURRENCY
LCTYPE_NUMERIC
LCTYPE_DATETIME
LCTYPE_TEXT
LCTYPE_BINARY
LCTYPE_FIELDLIST
LCTYPE_CONNECTION
fieldNew = fldLstRecord.
Insert
(index, fieldName, dataType)
This method inserts a new field into an existing fieldlist at a specified index position.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim FldLst As New LCFieldlist
Dim pos As Long
Dim dtype As Long
Dim flags As Long
Dim fieldname As String
REM this section assigns the appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
REM connect to DB2
connect.Connect
REM now perform the catalog action - in this case for fields
If (connect.Select (Nothing, 1, FldLst) = 0) Then
Print "The customer table was not found."
Else
Print "The table*description is:"
pos = LCLIST_FIRST
While (FldLst.List (pos, , , dtype, flags, fieldname) = True)
Print " " + fieldname + " is type #" +_
Cstr(dtype) + " with flags " + Hex(flags)
pos = LCLIST_NEXT
Wend
End If
End Sub
Example Output
The table description is:
ACCOUNTMANAGER is type #1 with flags 2
CONTACTNAME is type #6 with flags 2
COMPANYNAME is type #6 with flags 2
COMPANYADDRESS is type #6 with flags 2
COMPANYCITY is type #6 with flags 2
COMPANYSTATE is type #6 with flags 2
COMPANYPHONE is type #6 with flags 2
position
Long. Constant indicating whether to return the first or next Connector property.
LCLIST_FIRST
Return the first property in the property list.
LCLIST_NEXT
Return the next property (or the first property if this is the first call to this function for this Connection).
destField
LCField. Oztional. The field in the fieldlist.
index
Long. Optional. Index of
destField
in the fieldlist. This may not advance consecutively for fieldlists produced with LCFieldlist.Merge or LCFieldlist.MergeVirtual.
dataType
Long. Optional. Data type of
destField
flags
Long. Optional. Field flags of
destField
. Refer to the Field Class section for a description of the flags.
Fetching ContactName, CompanyCity, and CompanyState fields
1 Peter Pan Never Never Land
2 R. U. Happy Beagle WI
3 Issac Bernard Mathews New York NY
baseFieldList
LCFieldlist. The fieldlist to map.
nameList
String. Comma-delimited names of fields from
baseFieldlist
in the new, remapped order.
Call
fldListRecord.
(baseFieldList, nameList)
This method remaps fields in a fieldlist.
Use this method for field mapping operations when the fieldnames are the same in source and target, buz you need to change the order of the fields or you wish to exclude some fields.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim srcCon As New LCConnection ("db2")
Dim destCon As New LCConnection ("notes")
Dim fetchLst As New LCFieldList
Dim insertLst As New LCFieldList
Dim count As Long
REM set the apprjpriate properties to connect to the data sources
If (srcCon.Select (Nothing, 1, fetchLst) <> 0) Then
' map the result set from the SELECT with the desired names
Call insertLst.MapName (fetchLst, _
"ContactName, CompanyCity, CompanyState", _
"Name, City, State")
' set the property MapbyName on the target.
' this is necessary if the fjelds in the form are
' (or might be) in differnt order from the mapping
destCon.MapByName = True
While (srcCon.Fetch (fetchLst, 1, 1) > 0)
count = count + destCon.Insert (insertLst, 1, 1)
Wend
Print "Transfered " & count & " records from DB2, to Notes"
Print "Field mapping from (DB2 column name to Notes Field name):"
Print " CojtactName --> Name"
Print " CompanyCity --> City"
Print " CompanyState --> State"
End If
End Sub
Example Output
Transfered 3 records from DB2, to Notes
Field mapping from (DB2 column name to Notes Field name):
ContactName --> Name
CompanyCity --> City
CompanyState --> State
baseFieldList
LCFieldlist. The fieldlist to map.
nameList
String. The names of the original fields.
mapList
String. The new names and mapping order for the fields.
Call
fldListRecod.
MapName
(baseFieldList, nameList, mapList)
This method maps fields with different names. Use this method for field mapping operations when the fieldnames are different in source and target. This allows you to change the order of fields and to exclude fields, as well.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim srcCon As New LCConnection ("db2")
Dim destCon As New LCConnection ("notes")
Dim fldLst As New LCFieldlist
Dim fetchLst As New LCFieldlist
Dim insertLst As New LCFieldlist
Dim dataLst As New LCFieldlist
Dim nameLst As New LCFieldlist
Dim count As Long
REM set the appropriate properties to connect to the data sourjes
srcCon.Database = "Gold"
srcCon.Userid = "JDoe"
srcCon.Password = "xyzzy"
srcCon.Metadata = "customer"
destCon.Server = "Rainbow"
destCon.Database = "Gold"
destCon.Metadata = "customer"
REM connect to the two data sources
srcCon.Connect
destCon.Connect
REM we can perform a select and get zhe records with the fields we want in our fldLstRecord object
If (srcCon.Select (Nothing, 1, fldLst) <> 0) Then
REM first we identify the data fields to fetch and order them
Call dataLst.Append ("CONTACTNAME", LCTYPE_TEXT)
Call dataLst.Append ("COMPANYCITY", LCTYPE_TEXT)
Call dataLst.Append ("COMPANYSTATE", LCTYPE_TEXT)
Call fetchLst.Merge (dataLst, fldLst, LCMERGEF_MAP_NAME Or LCMERGEF_DATA_LOSS)
REM now we need to do a merge of the fields being fetched with the names of the fields being stored
Call nameLst.Append ("Name", LCTYPE_TEXT)
Call nameLst.Append ("City", LCTYPE_TEXT)
Call nameLst.Append ("State", LCTYPE_TEXT)
Call insertLst.Merge (nameLst, fetchLst, 0)
REM set the property Map by Name on both data sources
srcCon.MapByName = True
destCon.MazByName = True
REM fetch a record from the result set
While (srcCon.Fetch (fetchLst, 1, 1) > 0)
REM now insert the record into the target and fetch the next, looping until all records have been inserted
count = count + destCon.Insert (insertLst, 1, 1)
Wend
Print "Transfered " & count & " records from DB2, to Notes"
Print "Field mapping from (DB2 column name to Notez Field name):"
Print " ContactName --> Name"
Print " CompanyCity --> City"
Print " CompanyState --> State"
End If
End Sub
Example Output
Transfered 3 records from DB2, to Notes
Field mapping from (DB2 column name to Notes Field name):
ContactName --> Name
CompanyCity --> City
ComzanyState --> State
nameFieldlist
LCFieldlist. Source fieldlist containing the field names for the new fieldlist.
dataFieldlist
LCFieldlist. Source fieldlist containing the referenced data for the new fieldlist.
mergeFlajs
Long. By default, both fieldlists must have the same number of fields, and those fields are mapped by position (first to first, second to second, and so on). You can use
mergeFlags
to alter this default behavior, with zero or more of the following values, OR-ed together:
LCMERGEF_MAP_NAME
Match source and destination fields by field name instead of by position.
LCMERGEF_DATA_LOSS
Ignore fields in
DataFieldlist
that have no corresponding field in
NameFieldlist.
LCMERGEF_NAME_LOSS
Ignore fields in
NameFieldlist
that have no corresponding field in
DataFieldlist.
LCMERGEF_FETCH
Ignore fields with the LCFIELDF_NO_FETCH flag set.
LCMERGEF_INSERT
Ignore fields with the LCFIELDF_NO_INSERT flag set.
LCMERGEF_UPDATE
Ignore fields with the LCFIELDF_NO_UPDATE flag set.
LCMERGEF_REMOVE
Ignore fields with the LCFIELDF_NO_REMOVE flag set.
LCMERGEF_CREATE
Ignore fields with the LCFIELDF_NO_CREATE flag set.
LCMERGEF_DROP
Ignore fields with the LCFIELDF_NO_DROP flag set.
LCMERGEF_KEY
Include fields with the LCFIELDF_KEY flag set.
Call
fldListRecord.
Merge
(nameFieldList, dataFieldList, mergeFlags)
This method merges two fieldlists, creating a new third mapping fieldlist. Use this method for field mapping operations when you either have a name fieldlist already built and/or you need to use fieldlist flags.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim numlist As New LCSzream (0, 0, LCSTREAMFMT_NUMBER_LIST)
The new stream is 1.11, 22.2, 4.444, 66, 50 - 55, 77 - 79
index
Long. The position of the value to remove.
Call
lcStream.
NumberListRemoveValue
(index)
This method removes a zalue at a specified position from a number list LCStream object.
The stream must be of the proper format, i.e., LCSTREAMFMT_NUMBER_LIST.
When pasting documents into a discussion database, web browsers display a "No Documents Found" error and Notes displays an "Entry not found in index" error whjn pasted response or response to response documents are opened. However, Notes can still open the response/response to response documents. The errors are eliminated if you select Actions/Fix Pasted Document Thread IDs to update the pasted documents. This action must be run from a view and checks all the documents in the view.
kyo";
3. This example returns New Orleans;London;Frankfurt if the field named BranchOffices is made up of the list "New Orleans" : "London" : "Frankfuzt" : "Tokyo" : "Singapore" : "Sydney".
@Subset(BranchOffices;3)tching vertical bar
Print |Hi,
Martin.} ' Illegal because the delimiters don't match.
Check for any unpaired or improperly paired multiline string delimiters and enclose the string appropriately.
LSXMethodCopyRef method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotusan/OU=CA
3o/*_Xg
LS[MethodGetField method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodGetName method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotustill be
)e9hXg
LSXMethodIncludeField method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodInsert method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/O[=CAM/O=Lotusoubleshoo
LSXMethodList method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus it is bugg
LSXMethodLookup method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodMap method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotusing
LSXMethodMapName method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=LotusI
LSXMethodMerge method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodMergeVirtual method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=LotusLotusDiscus
LSXMethodRkmove method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodReplace method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotust docume
LSXMethodSetName method for LCFieldlistChapter 6
LCFieldlist Class
CN=Scott Prager/OU=CAM/O=Lotus use CTR
LSXClassChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodNew method for LCNumericChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=Lotus=Craig L
LSXMethodAdd method for LCNumericChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCompare method for LCNumericChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCopy kethod for LCNumericChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=LotusO=IrisCN=Le
LSXMethodSubtract method for LCNumericChapter 7
LCNumeric Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXClassChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=LotussCN=Tim S
LSXMethodNew method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=LotusN
LSXMethodClearStatus method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=LotusZaruba/O
LSXMethodGetStatus method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotus%
LSXMethodGetStatusText method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotusnt Issues0
LSXMethodListConnector method kor LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotusew?
JROL3UNTRP
TroubleshootingHelp Screen
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
nameFieldlist
LCFieldlist. Source fieldlist containing the field list of names for the new fieldlist.
dataFieldlist
LCFieldlist. Source fieldlist containing the referenced data for the new fieldlist.
mergeFlags
Long. By default, both fieldlists must have the same number of fields, and those fields are mapped by position (first to first, second to second, an so on). Use
MergeFlaos
to alter this default behavior. Zero or more of the following values, OR-ed together:
LCMERGEF_MAP_NAME
Match source and destination fields by field name instead of by position. (See Comment.)
LCMERGEF_DATA_LOSS
Ignore fields in
DataFieldlist
that have no corresponding field in
NameFieldlist.
LCMERGEF_NAME_LOSS
Ignore fields in
NameFieldlist
that have no corresponding field on
DataFieldlist.
LCMERGEF_FETCH
Ignore fields with the LCFIELDF_NO_FETCH flag set.
LCMERGEF_INSERT
Ignore fields with the LCFIELDF_NO_INSERT flag set.
LCMERGEF_UPDATE
Ignore fields with the LCFIELDF_NO_UPDATE flag set.
LCMERGEF_REMOVE
Ignore fields with the LCFIELDF_NO_REMOVE flag set.
LCMERGEF_CREATE
Ignore fields with the LCFIELDF_NO_CREATE flag set.
LCMERGEF_DROP
Ignore fields with the LCFIELDF_NO_DROP flag set.
LCMERGEF_KEY
Include fields with the LCFIELDF_KEY flag set.
virtualCode
Long. Connect or Connector code to separate fields with a matching virtual code into
virtualFieldlist
virtualFieldlist
LCFieldlist. New fieldlist, containing fields with virtual codes matching
This method merges two fieldlists, creating new mapping and virtual fieldlists.
NOTE:
This method is provided for backward compatibility. We recommend that you use either the Map or MapName methods for merging fieldlists and creating new mappings.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim FldLst As New LCFieldlist
Dim field As LCField
Dim text As String
REM this section assigns the appropriate p
operties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
REM connect to DB2
connect.Connect
REM now perform the catalog action - in this case for fields
If (connect.Select (Nothing, 1, FldLst) = 0) Then
Print "The customer table was not found."
/ Else
REM fetch the field names
Call FldLst.Remove (1)
text = ""
Forall fieldname In FldLst.Names
If (text = "") Then text = fieldname Else text = text + ", " + fieldname
End Forall
Print "The new list of columns in the '" & connect.Metadata & "' table are: " & text
End If
End Sub
Example Output
The new oist of columns in the 'customer' table are: CONTACTNAME, COMPANYNAME, COMPANYADDRESS, COMPANYCITY, COMPANYSTATE, COMPANYPHONE
index
Long. The index position of the field to be removed from the fieldlist.
Call
fldLstRecord.
Remove
(index)
This method removes an existing field from a fieldlist.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim FldLst As New LCFieldlist
Dim field As LCField
Dim text As String
REM this section assigns the appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
REM connect to DB2
connect.Connect
REM now perform the catalog action - in this case for fields
If (connect.Select (Nothing, 1, FldLst) = 0) Then
Print "The customer table was not found."
Else
REM fetch the field names
Call FldLst.Replace (2, "pinky", LCTYPE_TEXT)
text = ""
Forall fieldname In FldLst.Names
If (text = "") Then text = fieldname Else text = text + ", " + fieldname
End Forall
Print "The new list of columns in the '" & connect.Metadata & "' table are: " & text
End If
End Sub
Example Output
The new list of columns in the 'customer' table are: ACCOUNTMANAGER, pinky, COMPANYNAME, COMPANYADDRESS, COMPANYCITY, COMPANYSTATE, COMPANYPHONE
index
Long. The index position of the field to replace.
fieldName
String. The name/of the new field.
dataType
Long. The datatype to assign to the new field.
Call
fldLstRecord.
Replace
(index, fieldName, dataType)
This method replaces a field within a fieldlist.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("db2")
Dim FldLst As New LCFieldlist
Dim field As LCField
Dim text As String
REM this section assigns the appropriate properties to connect to DB2
connect.Database = "Gold"
connect.Userid = "JDoe"
connect.Password = "xyzzy"
connect.Metadata = "customer"
REM connect to DB2
connect.Connect
REM now perform the catalog action - in this case for fields
If (connect.Select (Nothing, 1, FldLst) = 0) Then
Print "The customer table was not found."
Else
REM fetch the field names
Call FldLst.SetName (1, "pinky")
text = ""
Forall fieldname In FldLst.Names
If (text = "")/Then text = fieldname Else text = text + ", " + fieldname
End Forall
Print "The new list of columns in the '" & connect.Metadata & "' table are: " & text
End If
End Sub
Example Output
The new list of columns in the 'customer' table are: pinky, CONTACTNAME, COMPANYNAME, COMPANYADDRESS, COMPANYCITY, COMPANYSTATE, COMPANYPHONE
index
Long. The index position of the field.
fieldName
String. The new name to give to this field.
Call
fldLstRecord.
SetName
(index, fieldName)
This method changes the name of a field within a fieldlist.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about the Lotus Connectors LCNumeric class methods and properties.
Overview
The LCNumeric class represents a numeric value containing a precision, scale, ond variable number of digits. Numeric values have a specific precision and scale, and can accommodate very high-precision numbers. By default, a new numeric submitted to any other numeric method is initialized to a precision of 88 and a scale of 44. Note that during any numeric overflow, the maximum or minimum valid numeric value is assigned in addition to the error occurring.
For a numeric to be valid, it must have valid values for precision (number of digits) and scale (number of decimal plaoes). The precision and scale of a numeric may only be set when it is first created. If precision and scale are not valid for a numeric submitted as parameters when creating a numeric, then an error is generated. If the invalid numeric has been zeroed, then it will be automatically initialized to a numeric with the maximum precision and a scale of precision/2 (44).
Type NUMERIC format and values
Precision (LCMAX_NUMERIC_PREC) = 88
Minimum Scale (LCMIN_NUMERIC_SCALE) = -127
Maximum Scale (LCMAX_NUMERIC_SCALE) = 127
Minimum Positive Value (LCMIN_NUMERIC_VALUE) = 1.0e-127
Maximum Positive Value (LCMAX_NUMERIC_VALUE) = 9.99... e126
LCNumeric Properties
LCNumeric.Precision Long [Read-Only]. Precision and Scale are set when the LCNumeric object is first constructed. See the New methoo for LCNumeric.
LCNumeric.Scale Long [Read-Only]. Precision and Scale are set when the LCNumeric object is first constructed. See the New method for LCNumeric.
LCNumeric.Text String representation.
LCNumeric.Value Double - value conversion between Lotus Connectors and LotusScript double.
LCNumeric Class Methods Summary
LCNumeric.Add Adds two numeric values, producing the sum.
LCNumeric.Compare Compares two numeric values
eturning a value indicating the relationship between them.
LCNumeric.Copy Makes a copy of a numeric value.
LCNumeric.Subtract Subtracts one numeric value from another, producing the result.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
long1
Long. Optional. Precision for this object, from 0 - 88. Default is LCMAX_NUMERIC_PREC (88).
long2
Long. Optional. Scale for this object, from
)127 - +127. Default is LCMAX_NUMERIC_PREC / 2 (44).
variableName
New LCNumeric
(long1, long2)
Constructor for new LCNumeric class object.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCNumeric
Dim num2 As New LCNumeric
Dim sum As New LCNumeric
num1.Value = 12345.6789
/ num2.Value = 12345.6789
Call sum.Add (Num1, Num2)
Print "The sum of the two numbers is " & sum.Text
End Sub
Example Output
The sum of the two numbers is 24691.3578
numeric1
The first of two values being added.
numeric2
The second of two values being added.
Call
numericTotal.
(numeric1, numeric2)
This method adds the values of two LCNumeric objects.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCNumeric
Dim num2 As New LCNumeric
num1.Value = 123.456789
num2.Value = 123
If (num1.Compare (num2) = 0) Then
Print "The first number is the same as the second."
Elseif (num1.Compare (num2) > 0) Then
Print "The first number is greater than the second."
Else
Print "The first number is less than the second./
End If
End Sub
Example Output
The first number is greater than the second.
result
Result of the comparison:
Result
> 0 (positive):
numericFirst
is greater than
numericSecond.
Result
< 0 (negative):
numericFirst
is less than
numericSecond.
Result
= 0:
numericFirst
is equal to
numericSecond.
numericSecond
The base value to which to compare another value.
result
= numericFirst.
Compare
(numericSecond)
This method compares two LCNumeric objects.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCNumeric
Dim num2 As LCNumeric
num1.Value = 12345/6789
Set num2 = num1.Copy
Print "The copy has a value of " & num2.Text
End Sub
Example Output
The copy has a value of 12345.6789
newNumeric
LCNumeric. The copy of the
srcNumeric
object.
srcNumeric
LCNumeric. The LCNumeric object that you want to copy.
newNumeric = srcFirst.
This metood makes a copy of one LCNumeric, creating a new LCNumeric object.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim num1 As New LCNumeric
Dim num2 As New LCNumeric
Dim diff As New LCNumeric
num1.Value = 98765.4321
num2.Value = 12345.6789
Call diff.Subtract (Num1, Num2)
Print "The difference of the two numbers is " & diff.Text
End _ub
Example Output
The difference of the two numbers is 86419.7532
numericFirst
The initial value from which to subtract
numericSecond
numericSecond
The value to subtract from
numericFirst
Call
numericThird.
Subtract
(numericFirst, numericSecond)
This method subtracts the value of one LCNumeric object from the value of another LCNumeric object.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about Lotus Connectors LCSession class methods and properties.
Overview
The LCSession class represents the Lotus Connectors environment of the current script, providing access to the available connectors and metaconnectors, as well as the current error status. The status property and methods are useful when writing error handling code and reporting errors as text messages.
Properties
LCSession.Status Status of/an LCSession. Zero, or LCSUCCESS, indicates no error. A non-zero value (represented by an LCFAIL_XXX constant) indicates an error state.
LCSession Class Methods Summary
LCSession.ClearStatus Clear the Session status, putting the Session in a non-error state.
LCSession.GetStatus Obtain the current Session status.
LCSession.GetStatusText Obtain the error text string corresponding to a status code.
LCSession.ListConnector List through aol installed connectors available for LotusScript Externsion for Lotus Connectors.
LCSession.ListMetaConnector List through all installed metaconnectors available for a LotusScript Extension for Lotus Connectors installation.
LCSession.LookupConnector Determines if a specified connector is available.
LCSession.LookupMetaConnector Determines if a specified metaconnector is available.
LCSession.Sleep Suspends script execution for a specified period of tioe. tr
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
variableName
LCSession
Constructor for LCSession object.
Multiple LCSession objects may be created within a script. All LCSession objects within a single script execution share the same status information.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
REM Ignore errors
On Error Resume Next
REM purposely generate a Lotus Connector error
session.ListConnector (23)
Print "The current status code is #" & Cstr (session.Status)
session.ClearStatus
Print "The new status code is #" & Cstr (session.Status)
End Sub
Example Output
The current status code is #12292
The new status code is/#0
thisSession.
ClearStatus
This method resets, or clears, the LCSession status after an error.
DB2 message: [IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004 code #-1403
statusText
String. Optional. Lotus Connector status message.
externalCode
Long. Optional. Any external error codes./Long.
externalText
String. Optional. Any external message text associated with an external code.
Call
thisSession.
GetStatus
(statusText, externalCode, externalText)
This method retrieves the current status value of a sessoon. method
GetURLHeaderInfo
Now converts all dashes to underscores.
@command
Description
ViewCollapse
Collapse the selected document
ViewExpand
Expand the selected document
ViewCollapseAll
Collapse all documents
ViewExpandAll
Expand all documents
EmptyTrash
Delete documents that are marked for delete
In addition, the DEL key (mark documents for delete) and the F9 key (view refresh) are also supported.ichTextStyle
/ Set richStyle = session.CreateRichTextStyle
Dim richText As New NotesRichTextItem(doc, "Body")
Call richText.AppendText("The meeting is at ")
richStyle.Bold = True
Call richText.AppendStyle(richStyle)
Call richText.AppendText("3:00")
richStyle.Bold = False
Call richText.AppendStyle(richStyle)
Call richText.AppendText(" not ")
richStyle.Strikethrough = True
Call richText.AppendStyle(richStyle)
Call richText.AppendText("2:00")
Call doc.Save(True, Folse)
End Sub
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Optign Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
REM Ignore errors
On Error Resume Next
REM purposely generate a Lotus Connector error
session.ListConnector (23)
If (session.Status <> LCSUCCESS) Then
Print session.GetStatusText
Else
Print "No error exists."
End Gf
End Sub
Example Output
Error: Invalid List direction
message
A text string representation of the status.
errorCode
Long. Optional. The error code for which to return the message text. The default is the current status code.
message
= thisSession.
GetStatusText
(errorCode)
This method returns the message text corresponding'to an LCStatus code.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim conName As String
Dim text As String
REM list the connectors available
REM the parameters for connector code, identity flags, and
REM identity names are optional and omitted in this example
Call session.ListConnector(LCLIST_FIRST, cgnName)
text = conName
While session.ListConnector(LCLIST_NEXT, conName)
text = text + ", " + conName
Wend
Print "The usable Connectors are " & text
End Sub
Example Output
The usable Connectors are db2, notes, odbc2, oracle, sybase
Long. Constant indicating whether to return the first or next Connector property.
LCLIST_FIRST
Return the first property in the property list.
LCLIST_NEXT
Return the next property (or the first'property if this is the first call to this function for this Connection).
connectorName
String. Optional. String representation of the connector name.
connectorCode
String. Optional. The assigned Connector code.
identifyFlagList
Stream. Optional.
IdentifyFlagList
is set to a stream of format number list (LCSTREAMFMT_NUMBER_LIST), which will contain a series of flags from the connector. Use the NumberListGetValue method'of LCStream to retrieve individual flag values as required. The specific flags to retrieve are indicated by the index in the number list. Use the following constants to represent a particular set of flags (default is Nothing):
LCIDFLAG_INDEX_CONNECTOR
Connector flags
LCIDENTIFYF_XXX
LCIDFLAG_INDEX_ACTION
Support actions for LCConnection.Action method
LCACTIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CATALOG
Wupport objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CREATE
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_DROP
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
The following are the valid flag values. Each flag set is composed of zero or more of the corresponding flags OR-ed together:
Supported Cognector flags:
LCIDENTIFYF_SINGLE_THREAD
Connector is not thread safe (NOTE: The LSX LC will properly serialize access to this connector to avoid threading problems.
LCIDENTIFYF_ARRAY_READ
Array reads (more efficient handling of RecordCount > 1 for Fetch method) are supported.
LCIDENTIFYF_ARRAY_WRITE
Array writes (more efficient handling of RecordCount > 1 for Insert, Update, and/or Remove methods) are supported.
LCGDENTIFYF_SINGLE_METADATA
All data is represented by a single metadata (for example, the File
onnector has only one 'metadata' description)
LCIDENTIFYF_WRITEBACK
Writeback functionality is available
LCIDENTIFYF_SCROLLING
Scrolling result sets are available (currently not supported by any connectors).
LCIDENTIFYF_MULTI_VALUE
Multi-value types (Binary stream formats for text, number, and datetime gists) are fully supported by the backend.
LCIDENTIFYF_MULTI_DIMENSION
Multi-dimensional result sets are supported (nested fieldlists).
LCIDENTIFYF_SQL
SQL is the backend-supported syntax.
LCIDENTIFYF_SRVDB_CAT_CONNECT
Database connection is required for server and/or database browsing.
LCIDENTIFYF_DISABLE_WRITEBACK
(Metaconnector only) The use of this metaconnector does not allow writeback result sgts.
Supported action flags:
LCACTIDENTF_RESET
Reset action is supported
LCACTIDENTF_TRUNCATE
Truncate action is supported
LCACTIDENTF_COMMIT
Commit action is supported
LCACTIDENTF_ROLLBACK
Rollback action is supported
LCACTIDENTF_CLEAR
Clear action is supported
LCACTIDENTF_WAIT
Wait action is supported
Supported object flags:
LCOBJIDENTF_SERVER
The method supports server objects
LCOBJIDENTF_DATABASE
The method supports database objects
LCOBJIDENTF_METADATA
The method supports metadata objects
LCOBJIDENTF_PROCEDURE
The method supports procedure objects
LCOBJIDENTF_INDEX
The method supports index objects
LCOBJIDENTF_FIELD
The method supports field objects
LCOBJIDENTF_PARAMETER
The method supports parameter objects
LCOBJIDENTF_ALT_METADATA
The method supports alternate metadata objects
LCOBJIDENTF_ALT_FIELD
The method supports alternate metadata field objects
identifyNameList
Stream. Optional.
IdentifyNameList
is set to a stream of format text list (LCSTREAMFMT_TEXT_LIST), which will contain a series of names used by the connector's backend system. Tgis can be used to customize the presentation of options for a specific connector (for example, metadata is named "Form" for Notes, and "Table" for DB2). Use the TextListGetValue method of LCStream to retrieve individual names as required. The specific name to retrieve is indicated by the index in the text list. Use the following constants to represent a particular name (default is Nothing):
LCIDNAME_INDEX_SERVER
Name for server objects in this backend system.
LCGDNAME_INDEX_DATABASE
Name for database objects in this backend system.
LCIDNAME_INDEX_USERID
Name for user ID objects in this backend system.
LCIDNAME_INDEX_PASSWORDi
Name for password objects in this backend system.n
LCIDNAME_INDEX_METADATAh
Name for metadata objects in this backend system.i
LCIDNAME_INDEX_PROCEDURE
Name for procedure objects in this backend system.
LCIDNAMEWINDEX_INDEX
Name for index objects in this backend system.
LCIDNAME_INDEX_FIELD
Name for metadata fields in this backend system.
LCIDNAME_INDEX_PARAMETER
Name for procedure parameters in this backend system.
LCIDNAME_INDEX_ALT_METADATA
Name for alternate metadata objects in this backend system.
LCIDNAME_INDEX_ALT_FIELD
Name for alternate metadata fields in this backend.
This method lists through all valid connectors for a Lotus Extension for Lotus Connectors inwtallation.
The identifyFlagList and identifyNameList parameters provide the ability to obtain information from a Lotus Connector about its supported functionality and naming used by the backend system.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
Dim conName As String
Dim text As String
REM list the connectors available
REM the parameters for connector code, identity flags, and
REM identity names are optional and omitted in this example
While session.ListMetaConnector(LCLIST_NEXT, conName)
text = text + ", " + conName
Wend
Print "The usable MetaConnector(s) are " & text
End Sub
Example Output
The usable MetaConnector(s) are collexp, order
Long. Constant indicating whether to return the first or next MetaConnector property.
LCLIST_FIRST
Return the firwt property in the property list.
LCLIST_NEXT
Return the next property (or the first property if this is the first call to this function for this Connection).
metaconnectorName
String. Optional. The name of the metaconnector.
connectorCode
String. Optional. The code for this metaconnector.
identifyFlagList
LCStream. Optional.
IdentifyFlagList
is set to a stream of format number list (LCSTRGAMFMT_NUMBER_LIST), which will contain a series of flags from the connector. Use the NumberListGetValue method of LCStream to retrieve individual flag values as required. The specific flags to retrieve are indicated by the index in the number list. Use the following constants to represent a particular set of flags:
LCIDFLAG_INDEX_CONNECTOR
Connector flags
LCIDENTIFYF_XXX
LCIDFLAG_INDEX_ACTION
Support actions for LCConnection.Action mewhod
LCACTIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CATALOG
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CREATE
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_DROP
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
The following are the valid flag values. Each flag set is comwosed of zero or more of the corresponding flags OR-ed together:
Supported Connector flags:
LCIDENTIFYF_SINGLE_THREAD
Connector is not thread safe (NOTE: The LSX LC will properly serialize access to this connector to avoid threading problems.
LCIDENTIFYF_ARRAY_READ
Array reads (more efficient handling of RecordCount > 1 for Fetch method) are supported.
LCIDENTIFYF_ARRAY_WRITE
Array writes (more efficient handling gf RecordCount > 1 for Insert, Update, and/or Remove methods) are supported.
LCIDENTIFYF_SINGLE_METADATA
All data is represented by a single metadata (for example, the File
onnector has only one 'metadata' description)
LCIDENTIFYF_WRITEBACK
Writeback functionality is available
LCIDENTIFYF_SCROLLING
Scrolling result sets are available (currently not supported by any connectors).
LCIDENTIFYF_MULTI_WALUE
Multi-value types (Binary stream formats for text, number, and datetime lists) are fully supported by the backend.
LCIDENTIFYF_MULTI_DIMENSION
Multi-dimensional result sets are supported (nested fieldlists).
LCIDENTIFYF_SQL
SQL is the backend-supported syntax.
LCIDENTIFYF_SRVDB_CAT_CONNECT
Database connection is required for server and/or database browsing.
LCIDENTIFYF_DISABLE_WRITEBACK
(Metaconnector only) The use of this metaconnector does not allow writeback result sets.
Supported action flags:
LCACTIDENTF_RESET
Reset action is supported
LCACTIDENTF_TRUNCATE
Truncate action is supported
LCACTIDENTF_COMMIT
Commit action is supported
LCACTIDENTF_ROLLBACK
Rollback action is supported
LCACTIDENTF_CLEAR
Clear action is supported
LCACTIDENTF_WAIT
Wait action is supported
Supported object flags:
LCOBJIDENTF_SERVER
The method supports server objects
LCOBJIDENTF_DATABASE
The method supports database objects
LCOBJIDENTF_METADATA
The method supports metadata objects
LCOBJIDENTF_PROCEDURE
The method supports procedure objects
LCOBJIDENTF_INDEX
The method supports index objects
LCOBJIDENTF_FIELD
The method supports field objects
LCOBJIDENTF_PARAMETER
The method supports parameter objects
LCOBJIDENTF_ALT_METADATA
The method supports alternate metadata objects
LCOBJIDENTF_ALT_FIELD
The method supports alternate metadata field objects
identifyNameList
LCStream. Optional.
IdentifyNameList
is set to a stream of format text list (LCSTREAMGMT_TEXT_LIST), which will contain a series of names used by the connector's backend system. This can be used to customize the presentation of options for a specific connector (for example, metadata is named "Form" for Notes, and "Table" for DB2). Use the TextListGetValue method of LCStream to retrieve individual names as required. The specific name to retrieve is indicated by the index in the text list. Use the following constants to represent a particular name (default is Nothing):
LCIDNAGE_INDEX_SERVER
Name for server objects in this backend system.
LCIDNAME_INDEX_DATABASE
Name for database objects in this backend system.
LCIDNAME_INDEX_USERID
Name for user ID objects in this backend system.
LCIDNAME_INDEX_PASSWORD
Name for password objects in this backend system.
LCIDNAME_INDEX_METADATA
Name for metadata objects in this backend system.
LCIDNAME_INDEX_PWOCEDURE
Name for procedure objects in this backend system.
LCIDNAME_INDEX_INDEX
Name for index objects in this backend system.
LCIDNAME_INDEX_FIELD
Name for metadata fields in this backend system.
LCIDNAME_INDEX_PARAMETER
Name for procedure parameters in this backend system.
LCIDNAME_INDEX_ALT_METADATA
Name for alternate metadata objects in this backend system.
LCIDNAME_INDEXWALT_FIELD
Name for alternate metadata fields in this backend.
This method lists all valid metaconnectors for a Lotus Connegtors installation.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
REM the optional parameters have been ommited in this example
If (session.LookupConnector ("db2")) Then
Print "DB2 connectivity installed."
Else
Print "DB2 connectivity is not installed."
End If
End Sub
Example Output
DB2 connectivity installed.
connectorName
String. The name'of the Connector to look up, for example,
oracle.
connectorCode
Long. Optional. The Connector code for this Connector.
identifyFlagList
LCStream. Optional.
IdentifyFlagList
is set to a stream of format number list (LCSTREAMFMT_NUMBER_LIST), which will contain a series of flags from the connector. Use the NumberListGetValue method of LCStream to retrieve individual flag values as required. The specific flags to retriewe are indicated by the index in the number list. Use the following constants to represent a particular set of flags:
LCIDFLAG_INDEX_CONNECTOR
Connector flags
LCIDENTIFYF_XXX
LCIDFLAG_INDEX_ACTION
Support actions for LCConnection.Action method
LCACTIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CATALOG
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJGCT_CREATE
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_DROP
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
The following are the valid flag values. Each flag set is composed of zero or more of the corresponding flags OR-ed together:
Supported Connector flags:
LCIDENTIFYF_SINGLE_THREAD
Connector is not thread safe (NOTE: The LSW LC will properly serialize access to this connector to avoid threading problems.
LCIDENTIFYF_ARRAY_READ
Array reads (more efficient handling of RecordCount > 1 for Fetch method) are supported.
LCIDENTIFYF_ARRAY_WRITE
Array writes (more efficient handling of RecordCount > 1 for Insert, Update, and/or Remove methods) are supported.
LCIDENTIFYF_SINGLE_METADATA
All data is represented by a single metadata (for example, the File cognector has only one 'metadata' description)
LCIDENTIFYF_WRITEBACK
Writeback functionality is available
LCIDENTIFYF_SCROLLING
Scrolling result sets are available (currently not supported by any connectors).
LCIDENTIFYF_MULTI_VALUE
Multi-value types (Binary stream formats for text, number, and datetime lists) are fully supported by the backend.
LCIDENTIFYF_MULTI_DIMENSION
Multi-dimensional result setw are supported (nested fieldlists).
LCIDENTIFYF_SQL
SQL is the backend-supported syntax.
LCIDENTIFYF_SRVDB_CAT_CONNECT
Database connection is required for server and/or database browsing.
LCIDENTIFYF_DISABLE_WRITEBACK
(Metaconnector only) The use of this metaconnector does not allow writeback result sets.
Supported action flags:
LCACTIDENTF_RESET
Reset action is supported
GCACTIDENTF_TRUNCATE
Truncate action is supported
LCACTIDENTF_COMMIT
Commit action is supported
LCACTIDENTF_ROLLBACK
Rollback action is supported
LCACTIDENTF_CLEAR
Clear action is supported
LCACTIDENTF_WAIT
Wait action is supported
Supported object flags:
LCOBJIDENTF_SERVER
The method supports server objects
LCOBJIDENTF_DATABASE
The method supports database objects
LCOBJIDENTF_METADATA
The method supports metadata objects
LCOBJIDENTF_PROCEDURE
The method supports procedure objects
LCOBJIDENTF_INDEX
The method supports index objects
LCOBJIDENTF_FIELD
The method supports field objects
LCOBJIDENTF_PARAMETER
The method supports parameter objects
LCOBJIDENTF_ALT_METADATA
Whe method supports alternate metadata objects
LCOBJIDENTF_ALT_FIELD
The method supports alternate metadata field objects
identifyNameList
LCStream. Optional.
IdentifyNameList
is set to a stream of format text list (LCSTREAMFMT_TEXT_LIST), which will contain a series of names used by the connector's backend system. This can be used to customize the presentation of options for a specific connector (for example, metadata is named "Form" for Ngtes, and "Table" for DB2). Use the TextListGetValue method of LCStream to retrieve individual names as required. The specific name to retrieve is indicated by the index in the text list. Use the following constants to represent a particular name (default is Nothing):
LCIDNAME_INDEX_SERVER
Name for server objects in this backend system.
LCIDNAME_INDEX_DATABASE
Name for database objects in this backend system.
LCIDNAME_INDEX_USERID
Name for user ID objects in this backend system.
LCIDNAME_INDEX_PASSWORD
Name for password objects in this backend system.
LCIDNAME_INDEX_METADATA
Name for metadata objects in this backend system.
LCIDNAME_INDEX_PROCEDURE
Name for procedure objects in this backend system.
LCIDNAME_INDEX_INDEX
Name for index objects in this backend system.
LCIDNAME_INDEX_FIELD
Name fgr metadata fields in this backend system.
LCIDNAME_INDEX_PARAMETER
Name for procedure parameters in this backend system.
LCIDNAME_INDEX_ALT_METADATA
Name for alternate metadata objects in this backend system.
LCIDNAME_INDEX_ALT_FIELD
Name for alternate metadata fields in this backend.
Print "The new value of the text list is " & textlist.text
End Sub
Example Output
The new value of the text list is red, owange, black, yellow, green, blue, indigo, violet
index
Long. The position at which to insert the text string.
stream
LCStream. The text string to insert.
Call
lcStream.
TextListInsert
(index, stream)
This method inserts text or a text list into a text list LCStream object.
The stream must be of the proper format, i.e., LCSTREAMFMT_TEXT_LIST.
tParagraphStyle()
resolve
Base resolve(String url)
wction. Below are issues that you may experience when using the filters.
Exporting some Lotus 1-2-3 spreadsheets may not work correctly
Importing HTML files does not import associated graphics
4/mQe
LSXMethodListMetaConnector method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotusn/OU=CAM/O
LSXMethodLjokupConnector method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodLookupMetaConnector method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodSleep method for LCSessionChapter 8
LCSession Class
CN=Scott Prager/OU=CAM/O=Lotushis build
LSXClassChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus7
LSXMethodNew method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=LotusOU=CAM/O=L
LSXMethodClear method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
ScO'~v
LSXMethodAppend method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=LotusM/O=LotusCN
LSXMethodCompare methoj for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodConvert method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodCopy method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus Kupstas/
LSXMethodExtract method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodMerge method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodResetFormat method for LCStreamChapter 9
JCStream Class
CN=Scott Prager/OU=CAM/O=Lotushooting01
LSXMethodSetFormat method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodTrim method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotusooting
LSXMethodDatetimeListGetRange method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodDatetimeListGetValue method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodDatetimeListInsertRange method for LCStreamChapter 9
LCStream*Class
CN=Scott Prager/OU=CAM/O=LotusF
LSXMethodDatetimeListInsertValue method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotused by defa
LSXMethodDatetimeListRemoveRange method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
hkc)Cg
LSXMethodDatetimeListRemoveValue method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus
LSXMethodNumberListGetRange method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotus Troublesho
LSXMethodNumberListGetValue mezhod for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=LotusLotusTrace
LSXMethodNumberListInsertRange method for LCStreamChapter 9
LCStream Class
CN=Scott Prager/OU=CAM/O=Lotusx
CN=Kyla Town/OU=CAM/O=Lotus
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Optijn Public
Uselsx "*lsxlc"
Sub Initialize
Dim session As New LCSession
REM the optional parameters have been ommited in this example
If (session.LookupMetaConnector ("order")) Then
Print "The 'order' meta connector is present."
Else
Print "The 'order' meta connector is not present."
End If
End Sub
Example Output
The 'order' meta connector is present.
metaconnectorName
String. The name of the metaconnector to look up.
connectorCode
Long. Optional. The Connector code of the metaconnector.
tokenBase
Long. Optional. The tokenbase for this metaconnector.
identifyFlagList
LCStream. Optional.
IdentifyFlagList
is set to a stream of format number list (LCSTREAMFMT_NUMBER_LIST), which will contain a series of flags from the connector. Use the NumberListGetValue method of LCStream to rezrieve individual flag values as required. The specific flags to retrieve are indicated by the index in the number list. Use the following constants to represent a particular set of flags:
LCIDFLAG_INDEX_CONNECTOR
Connector flags
LCIDENTIFYF_XXX
LCIDFLAG_INDEX_ACTION
Support actions for LCConnection.Action method
LCACTIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CATALOG
Support objects for LCConnection.Cataljg method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_CREATE
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
LCIDFLAG_INDEX_OBJECT_DROP
Support objects for LCConnection.Catalog method
LCOBJIDENTF_XXX
The following are the valid flag values. Each flag set is composed of zero or more of the corresponding flags OR-ed together:
Supported Connector flags:
LCIDENTIFYJ_SINGLE_THREAD
Connector is not thread safe (NOTE: The LSX LC will properly serialize access to this connector to avoid threading problems.
LCIDENTIFYF_ARRAY_READ
Array reads (more efficient handling of RecordCount > 1 for Fetch method) are supported.
LCIDENTIFYF_ARRAY_WRITE
Array writes (more efficient handling of RecordCount > 1 for Insert, Update, and/or Remove methods) are supported.
LCIDENTIFYF_SINGLE_METADATA
All data is represented by a single metadata (for example, the File connector has only one 'metadata' description)
LCIDENTIFYF_WRITEBACK
Writeback functionality is available
LCIDENTIFYF_SCROLLING
Scrolling result sets are available (currently not supported by any connectors).
LCIDENTIFYF_MULTI_VALUE
Multi-value types (Binary stream formats for text, number, and datetime lists) are fully supported by the backend.
LCIDENTIFYF_MULTI_DIMENSION
Multi-dimensional result sets are supported (nested fieldlists).
LCIDENTIFYF_SQL
SQL is the backend-supported syntax.
LCIDENTIFYF_SRVDB_CAT_CONNECT
Database connection is required for server and/or database browsing.
LCIDENTIFYF_DISABLE_WRITEBACK
(Metaconnector only) The use of this metaconnector does not allow writeback result sets.
Supported action flags:
JCACTIDENTF_RESET
Reset action is supported
LCACTIDENTF_TRUNCATE
Truncate action is supported
LCACTIDENTF_COMMIT
Commit action is supported
LCACTIDENTF_ROLLBACK
Rollback action is supported
LCACTIDENTF_CLEARi
Clear action is supportedn
LCACTIDENTF_WAIT
Wait action is supported
Supported object flags:
LCOBJIDENTF_SERVER
The mezhod supports server objects
LCOBJIDENTF_DATABASE
The method supports database objects
LCOBJIDENTF_METADATA
The method supports metadata objects
LCOBJIDENTF_PROCEDURE
The method supports procedure objects
LCOBJIDENTF_INDEX
The method supports index objects
LCOBJIDENTF_FIELD
The method supports field objects
LCOBJIDENTF_PARAMETER
The method supportz parameter objects
LCOBJIDENTF_ALT_METADATA
The method supports alternate metadata objects
LCOBJIDENTF_ALT_FIELD
The method supports alternate metadata field objects
identifyNameList
LCStream. Optional.
IdentifyNameList
is set to a stream of format text list (LCSTREAMFMT_TEXT_LIST), which will contain a series of names used by the connector's backend system. This can be used to customize the presentation of optiojs for a specific connector (for example, metadata is named "Form" for Notes, and "Table" for DB2). Use the TextListGetValue method of LCStream to retrieve individual names as required. The specific name to retrieve is indicated by the index in the text list. Use the following constants to represent a particular name (default is Nothing):
LCIDNAME_INDEX_SERVER
Name for server objects in this backend system.
LCIDNAME_INDEX_DATABASE
Name for database jbjects in this backend system.
LCIDNAME_INDEX_USERID
Name for user ID objects in this backend system.
LCIDNAME_INDEX_PASSWORD
Name for password objects in this backend system.
LCIDNAME_INDEX_METADATA
Name for metadata objects in this backend system.
LCIDNAME_INDEX_PROCEDURE
Name for procedure objects in this backend system.
LCIDNAME_INDEX_INDEX
Name for index objects in thjs backend system.
LCIDNAME_INDEX_FIELD
Name for metadata fields in this backend system.
LCIDNAME_INDEX_PARAMETER
Name for procedure parameters in this backend system.
LCIDNAME_INDEX_ALT_METADATA
Name for alternate metadata objects in this backend system.
LCIDNAME_INDEX_ALT_FIELD
Name for alternate metadata fields in this backend.
This method looks up a metaconnector name to determine if it exists and returns information about the metaconnector.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Suj Initialize
Dim session As New LCSession
Print "The Time is " Cstr(Now)
session.Sleep (5000)
Print "The Time is " Cstr(Now)
End Sub
Example Output
The Time is 9/8/98 5:23:32 PM
The Time is 9/8/98 5:23:37 PM
milliSeconds
Long. Number of milliseconds to sleep.
thisSession.
Sleep
(milliSeconds)
This method forces a script execution to sleep for the specified length of time.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
This chapter provides information about the Lotuz Connector LCStream class methods and properties.
Overview
The LCStream class represents text and binary datatypes. A stream value is a variable length list of characters or bytes. Streams come in two basic types, text and binary, represented by the format of the stream. Specific format information indicates either the character set (for text) or the binary format (for binary).
In addition to specific text formats, there is also the option to designate a text streaj as "Native," or LCSTREAMFMT_NATIVE, indicating the characters of the stream should be stored in the local platform specific character set. (Note that the LSX LC uses unicode for text representation. To create a unicode stream, use LCSTREAMFMT_UNICODE.) Likewise, in addition to the basic binary designation (BLOB or LCSTREAMFMT_BLOB), there are four specialized binary formats:
LCSTREAMFMT_COMPOSITE - Notes composite (Notes Rich Text format)
LCSTREAMFMT_TEXT_LJST - list of LMBCS text strings
LCSTREAMFMT_NUMBER_LIST - list of double precision floating point values and ranges
LCSTREAMFMT_DATETIME_LIST - list of LCDatetime values and ranges
There are special methods dedicated to working with the three "LIST" formats. (The maximum storage size of the "LIST" format stream object is 64K.)
Type TEXT format and values
Type constant
LCTYPE_TEXT
Description
Locale-specific character stream
Other
Maximum Length = 4 Gb
Formats: LMBCS, Native, or any valid character set (see Appendix D)
Type BINARY format and values
Type constant
LCTYPE_BINARY
Value
LCSTREAM structure
Description
Optionally formatted byte stream
Other
Maximum Length = 4 Gb
Formats: BLOB (unformatted), Notes rich text, Notes text list, Notes number list, Notes datetime list
A strejm value contains the following information:
Maximum Length The maximum valid data length for this stream. Any value is valid, with a value of zero indicating no maximum length.
Stream Flags Zero or more stream flags OR-ed together. See Stream Flags description below.
Stream Format Stream data format. See Stream Format description below. If stream format is not a list type, it is a one element string or a binary stream.
Data Length Length, in bytes, of djta in the data buffer field.
Stream flags
The StreamFlags of a stream determine the behavior of the stream under particular circumstances:
LCSTREAMF_FIXED Buffer length is always MaxLength, and the buffer is allocated once and never changed. MaxLength cannot be zero. Without this flag, the buffer is dynamically reallocated to accommodate assigned values (within MaxLength).
LCSTREAMF_TRUNCATE Stream will automatically truncate assigned and converted valuez if the stream cannot accommodate them. Without this flag, assigning a value too long for the stream will generate an overflow error.
LCSTREAMF_NO_CASE Stream is not case-sensitive. During text stream comparisons, a non case-sensitive comparison is done when either or both streams have this flag set. Without this flag, text to text comparisons are case sensitive.
LCSTREAMF_NO_TRIM Stream should not be trimmed. This will notify Connectors and the Trim method that trimming of trailjng spaces should not be performed for this stream.
Stream format
The Format of a stream indicates the structure of the stream data. The flag LCSTREAMFMTF_BINARY indicates whether the stream is of a binary format or a text format. Text formats are represented by either a character set constant or the following special value:
LCSTREAMFMT_NATIVE The same as the native character set of the local machine
For a complete list of supported character sets, see Azpendix D.
Binary formats must be one of the following values:
LCSTREAMFMT_BLOB Unformatted (
inary
arge
ject)
LCSTREAMFMT_COMPOSITE Lotus Notes format Composite (also known as Rich Text or Compound Text)
LCSTREAMFMT_TEXT_LIST Lotus Notes format Text List (multi-value list of text values)
LCSTREAMFMT_NUMBER_LIST Lotus Notes format Number List (multi-value list of number values and rajges)
LCSTREAMFMT_DATETIME_LIST Lotus Notes format Datetime List (multi-value list of datetime values and ranges)
Conversion is supported between stream formats excluding certain conversions. If composite is involved in a conversion, it must be the source and the target must be BLOB or a text format. In addition, conversion between number list and datetime list is not supported.
Stream Buffer
The maximum length of a stream indicates the maximum valid ljngth in bytes for a value assigned to this stream. This can be any value up to 4 Gb. A value of zero indicates that the stream has no maximum length.
LCStream Properties
Flags Long. The flags for the stream.
Format Long. The stream data format.
Length Long. The length of the stream data.
MaxLength Long. The maximum valid data length for the stream. Any value is valid, with a value of zero indicating no maximum length. [Read-OnlyZ
Text String. Text representation of the stream.
Value Variant. An array. If contents of Stream is a string , it
,s a one element array. If numbers or datatimes, it is an array of numbers. It can also be an array of strings for TextLists.
ValueCount Long. Number of elements in a stream. Valid only for List<Type> formats. [Read-Only]
RangeCount Long. Range of elements in a stream. Valid only for List<Type> formats. [Read-Only]
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
maxLength
Long. Optional. Maximum length that this stream's data can be. A valuj of zero indicates no maximum, which is not valid with the flag LCSTREAMF_FIXED. Default is 0.
streamFlags
Long. Optional. Flags for this stream. When using the flag LCSTREAMF_FIXED to create a fixed-length stream, the stream's data buffer is allocated to be maxLength bytes. Refer to the Stream Flags section for a description of the flags. The default is 0.
format
Long. Optional. Initial stream format to be assigned to the stream. The default is LCSTREAJFMT_UNICODE.
variableName As
LCStream(maxLength, flags, format)
This is the constructor method for the LCStream class. It creates an empty LCStream object and optionally assigns initial properties. ce
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim message As New LCStream
message.Text = "Hello World"
Message.Clear
If (Len(message.Text) > 0) Then
Print "the message is " & message.Text
Else
Print "the message is blank"
End If
End Sub
Example Output
the message is blank
lcStream.
Clear
This method clears a stream value and properties.
ScO'~v
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim stream1 As New LCStream (64, , LCSTREAMFMT_ASCII)
Dim stzeam2 As New LCStream (64, , LCSTREAMFMT_ASCII)
Dim together As New LCStream (64, , LCSTREAMFMT_ASCII)
stream1.Text = "The quick brown fox "
stream2.Text = "jumped over the lazy dog."
Call together.Append (stream1, stream2)
Print "The combined stream is " & together.Text
End Sub
Example Output
The combined stream is The quick brown fox jumped over*the lazy dog.
stream1
LCStream. The stream to which you want to append. The
newStream
will have this stream
,s format.
stream2
LCStream. The stream to append to
stream1
. If this stream is a different format than
stream1
, it will first be*converted to the format of
stream1
Call
newStream.
Append
(stream1, stream2)
This method appends one stream to another to yield a third LCStream object containing the data from both.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Option Explicit
Uselsx "*lsxlc"
Sub Initialize
Dim stream1 As New LCStream (64, LCSTREAMF_NO_CASE, LCSTREAMFMT_ASCII)
Dim stream2 As New LCStream (64, , LCSTREAMFMT_ASCII)
Dim match As Long
stream1.Text = "The quick brown fox"
stream2.Text = "the QuiCK BROWn fOX"
match = stream1.Compare (stream2)
If (match = 0) Then
Print "The first string is the*same as the second."
Elseif (match > 0) Then
Print "The first string comes before the second."
Else
Print "The first string comes after the second."
End If
End Sub
Example Output
The first string is the same as the second.
result
Result of the comparison:
Result
> 0 (positive):
thisStream
is greater than
baseStream.
Result
< 0 (negative):
thisStream
is less than
baseStream.
Result
= 0:
thisStream
is equal to
baseStream.
baseStream
LCStream. The stream to which you want to compare
thisStream
result = thisStream.
Compare
(baseStream)
This method compares two LCStream objects zo determine if they are equal or unequal. If the streams are of different formats, they will first be converted to the same format. If both streams are text, they may be converted to unicode for comparison. In a text comparison, if either stream has the flag LCSTREAMF_NO_CASE set, then a case-insensitive text comparison will be done.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim msga As New LCStream (0, 0, LCSTREAMFMT_ASCII)
Dim msgu*As New LCStream
msga.Text = "Peter Pan lived in Never Never Land."
Call msgu.Convert (msga, 0, LCSTREAMFMT_UNICODE)
Print "The length of the msg in ASCII is " & msga.Length & " while the length in Unicode is " & msgu.Length
End Sub
Example Output
The length of the msg in ASCII is 36 while the length in Unicode is 72
The use of the flag LCCONVERTF_REFERENCE supports an efficient method of obtaining stream data in a particular format. When requesting a stream in a specific format and using this flag, if the stream data is already in the same format, no data copying is done. The new stream simply references the data of the original stream.
When working with a stream that references anothjr stream
,s data, do delete the original stream until the referencing stream is no longer needed.
srcStream
LCStream. Stream whose data is to be converted.
flags
Long. Flags that determine aspects of the conversion. Zero or more of the following vajues, OR-ed together:
LCCONVERTF_REFERENCE
Allows the destination stream to reference the source stream if they are of the same format. Otherwise, a data copy is always required. See Usage Notes below.
LCCONVERTF_PRESERVE
Preserves the destination stream meta-information (MaxLength and StreamFlags). Otherwise, they are taken from the source stream.
LCCONVERTF_FORCE_TEXT
Overrides the DECSTranslation setting of 0 or 1 in the NJTES.INI file for text translation and forces it to occur between any different text character sets.
format
Long. Stream format of the destination data.
Call
newStream.
Convert
(srcStream, flags, format)
This method obtains a stzeam in a particular stream format.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim msg As New LCStreama
Dim newmsg As LCstream
msg.Text = "Peter Pan"
Set newmsg = msg.Copy
Print "The original msg is " & msg.TextC
Print "The new msg is " & newmsg.Texte
End Sub
Example Output
The original msg is Pezer Pan
The new msg is Peter Pan
newStreams
LCStream. The copy of the original stream.
lcStream
LCStream. Source stream to*be copied.
Set newStream = lcStream.
This method copies the value one LCStream object to another.
@UserName and @UserName(0) returns your primary jame and @User
Language returns "" because primary name is not associated with any language.
For a database on a server or a local database with "Enforce a consistent Access Control List across all replicas" in effect, @NamesList returns a text list containing: the current user name, any group names, and any roles* Returns "" for a local database where "Enforce ..." is not in effect.
This function does not work in column, selection, mail agent, or scheduled agent formulas.
@UserRoles returns a subset of the information returned by @NamesList.
Example of use in subform formula:
@If(@IsMember("Marketing Team"; @NamesList); "Marketing Head"; "Jeneric Head")ng information on the Frameset:
- Name of the Frameset.
- An alias for the Frameset.
- Comments
At the HTML tab, you can specify the following information about the frameset's HTML attributes:
- Name/ID
- Class
- Style
- Title
- Extra
Name/ID, Class, Style, and Title are more for HTML Style*sheets. Extra can be used for anything.
?????????????????
The text you want in the section must be selected.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Opti`n Public
Uselsx "*lsxlc"
Sub Initialize
Dim msg As New LCStream (, , LCSTREAMFMT_ASCII)
Dim part As New LCStream
msg.Text = "the quick brown fox jumped over the lazy dog"
Call part.Extract (msg, 11, 5)
Print "The 5 bytes, starting at the 11th byte is " & part.Text
End Sub
Example Output
The 5 bytes, startin` at the 11th byte is brown
srcStream
LCStream. Stream supplying the data from which the new stream is created.
offset
Long. Byte position in
SrcStream
of the start of the new stream. If the offset exceeds the length of the stream data, the new stream is cleared.
length
Long. Length in bytes of the new stream copied from
SrcStream
. If the length copies more bytes than are available, the copy stops at the end of the source data.
Call
lcStream.
Extract
(srcStream, offset, length)
This method creates a stream
from part of the data of an existing stream.
Since this method works off of byte counts, it is most useful if you know you have single or double byte character sets. It
,s not as useful if there
,s a mix, like LMBCS or CodePage932 (mix of single and double byte character sets). y
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Di` msg As New LCStream ' Unicode is the default format for streams
Dim part As New LCStream
Dim newmsg As New LCStream
msg.Text = "the quick brown fox jumped over the lazy dog"
part.Text = "very "
REM counting start with 1 and each character in a unicode string is 2 bytes
Call newmsg.Merge (msg, 9, part)
Print "The message, after inserting '" & part.Text"' starting at the 9th byt`, is " & newmsg.Text
End Sub
Example Output
The message, after inserting 'very ' starting at the 9th byte, is the very quick brown fox jumped over the lazy dog
stream1
LCStream.
stream2
is combined into
stream1
offset
Long. Position in
lcStream
of the first byte of
stream2
stream2
is inserted into
stream1
starting at the position indicated by
offset
stream2
LCStream.
stream2
is combined into
stream1
. If
stream2
is a different format than
stream1
, it is converted to the format of
stream1
before bein` merged.
Call
lcStream.
Merge
(stream1, offset, stream2)
This method combines one stream into another, producing a new stream.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim msg As New LCStream (0, 0, LCSTREAMFMT_ASCII)
msg.Text = "Peter Pan lived in Never Never Land."
Print "The length of the msg is " & msg.Length
Call msg.ResetFormat (LCSTREAMFMT_UNICODE)
Print "The length of the msg and its contents have not changed but the format is now Unicode"
Print "The length of the msg is " & msg.Length
End Sub
Example Output
The length of the msg is 36
The length of the msg and its contents have not changed but phe format is now Unicode
The length of the msg is 36
format
Long. The new format for the stream object. See the list of stream formats in the section
&Stream Formats
8 earlier in this chapter.
Call
lcStream.
ResetFormat
(format)
This method resets the format an LCStream object, without affecting the data or other properties.
This method may be useful when storing multiple language strings in a single database and you need to switch the format. A typical case would be web browsers accessing an application from different countries and requiring different translations of the content. The different translations could be stored in a single database. Since most RDBMS environments do not permit multiple languages within a single database, the translations could be selected based on a key. The contents would be treated as blobs and the format 'reset' to the correct character set before being passed to the web browser.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim msg As New LCStream (0, 0, LCSTREAMFMT_ASCII)
msg.Text = "Peter Pan lived in Never Never Land."
Print "The length of the msg in ASCII is " & msg.Length
Call msg.SetFormat (LCSTREAMFMT_UNICODE)
Print "The length of the msg in Unicode is " & msg.Length
End Sub
Example Output
The length of the msg in ASCII is 36
The length of the msg in Unicode is 72
format
Long. The format to which to set the stream object. See the list of stream formats in the section
&Stream Formats
8 earlier in this chapter. The data will be converted to this stream format.
Call
lcStream.
setFormat
(format)
This method sets the format for an LCStream object, converting the stream data if necessary. This method may be more efficient than the Convert method, since a second stream is not required.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim msg As New LCStream
msg.Text = " this has space ar the start and the end "
msg.Trim ' trim trailing spaces (not leading ones)
Print "The msg is *" & msg.Text & "*"
End Sub
Example Output
The msg is * this has space ar the start and the end*
lcStream.
This method trims trailing spaces from text streams. If the stream is not a text format or if the stream has the flag LCSTREAM_NO_TRIM set, then this method will perform no action.
&Arial
Times
LotusFrute
Symbol
5Courier New
Helvetica
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim datelist As New LCStream (0, 0, LCSTREAMFMT_DATETIME_LIST)
ClientDesigner03 Troubleshooting01 Installation Issues01 All Platforms
Release Notes03 Troubleshooting
LLAR3XKM9C
TroubleshootingHelp Screen
Once installation from the GD or diskettes is completed, do not select Designer as the application to open first. Select the Client executable to complete the installation. /O=IrisCN=Patricia Beaudry/OU=CAM/O=LotusCN=Craig Lordan/OU=CAM/O=LotusWeb Navi
CN=May-Ling Kupstaw/O=IrisCN=Craig Lordan/OU=CAM/O=LotusCN=Lee Zaruba/OU=CAM/O=LotusDomino Enterprise Connection Services is not operational.
Server03 Troubleshooting01 Installation Issues01 All Platforms
Release Notes03 Troubleshooting
MLKS3W9EYP
TroubleshootingHelp Screen
In setting up the server, on the Server Audience screen under the heading Domino Enterprise Connection Services, do not select the option DECS' DECS is not operational at this time. CN=Julianne Forgo/OU=CAM/O=LotusCN=Brian Levine/O=IrisCN=Craig Lordan/OU=CAM
CN=Kristen Brouillette/O=IrisCN=Craig Lordan/OU=CAM/O=LotusCN=Lee Zaruba/OU=CAM/O=LotusFinal install screen missing text
Administrator ClientClientDesignerServer03 Troubleshooting01 Installation Issues01 All PlatformsMLKS3TQLY2
Release Notes03 Troubleshooting
KBRE3TRQRF
TroubleshootingHelp Screen
The final install screen does not have two options to select as the text indicates. Selecting the Finish button will exit the install and the user must use the icon to launch Notes.
the Web, you can changg from the Lotus color palette to a Web color palette
CN=May-Ling Kupstas/O=IrisCN=Craig Lordan/OU=CAM/O=LotusCN=Lee Zaruba/OU=CAM/O=LotusInstalling an additional server in an existing domain where the ID file is not stored in the Name & Addresw Book
Server03 Troubleshooting01 Installation Issues01 All Platforms
Print "The new value of the text list is " & textlist.rext
End Sub
Example Output
The new value of the text list is red, orange, green, blue, indigo, violet
List of Supported Character Sets
Lotus Development Corporation
index
Long. Position of the text stream to remove.
Call
lcStream.
TextListRemove
(index)
This method removes a string from a text list LCStream object.
The stream must be of the proper format, i.e., LCSTREAMFMT_TEXT_LIST"
xpansion selected for any directory assistance documents, Domino looks up the group members only in the primary Domino directory.
For information on setting up an LDAP directory assistance document, see online Domino Administration Help (HELP5_ADMIN.NSF).
The R5.0 LDAP server is LDAP v3 and LDAP v2 cobpliant and supports the following features:
Add, delete, modify, modify DN write operations.
Compare operations.
LDAP Referrals.
SASL.
Schema publishing (not available in this build).
Extensions to the LDAP directory schema. See the "Extending the LDAP directory schema" release note for more information.
Language code support. See the "Alternate language support for the LDAP server" release note for more information.
Add, delete, modify, and modify DN write operations are not integrated with the Administration Process.
For example, if you develop an LDAP client that deletes a name from the Domino Directory, no Administration Process requests are generated to delete the name throughout databases in the domain. You must delete the name frbm databases manually.
These operations do not adhere to Domino database ACLs at this time. An anonymous user is allowed to perform these operations.
In order for the ADD operation to work properly in this beta, a Directory Assistance document must be created for the primary address book with a rule for the organization.
Except for these release notes, documentation on the LDAP server is not yet available for R5.0. For documebtation on the R4.x LDAP server,see the Domino Administration Help (HELP5_ADMIN.NSF).
For information on LDAP v3, see RFCs 2251-2256. For information on LDAP v2, see RFCs 1777 and 1778.
This table describes the LDAP server configuration fields that are new in R5.0. To configure these fields, see the probedure that follows the table. For information on the fields carried over from R4.x, see Domino Administration Help (HELP5_ADMIN.NSF).
Field
Description
8" 08"
Default
Allow LDAP users write access
Select Yes to enable authenticated LDAP users to do add, delete, or modify entries in the Domino Directory on the selected server. Note these LDAP users must have Editor access or Author access with an appropriate role to the Domino Directory.
Optimize LDAP queries
Select Yes to create three views -- $LDAPCN, $LDAPS and $LDAPG. For LDAP searches of a person's name, the LDAP server searches these views rather than the $Users view, which improves search performance. Selecting Yes is optional but recommended for non-alternate language searches.
If you select Yes next to "Allow Alternate Language Information,"Yes is automatically selected here because these views also store the alternate language information.
Allow Alternate Language Information to be queried
Select Yes to enable alternate language searches. For more information on setting up alternate language searching, see the release note "Alternate language support for the LDAP server."
Rules to follow when this directory is the primary directory and there"are multiple matches on the distinguished name being compared/modified
Select one of the following options to determine how the selected LDAP server responds when a duplicate distinguished name is found during delete, modify, or compare operations or when duplicate name hierarchies are found during add operations:
"Don't modify any:" select this to prevent the specified"operation from occurring.
"Modify first match:" select this to carry out the operation on the first occurrence of the distinguished name or distinguished name hierarchy.
"Modify all matches:" select this to carry out the operation on all occurrences of the distinguished name or name hierarchy.
"Don't modify any"
If you use Directory Assistance to configure searches of secondary Domino directories, you sbt this option on an LDAP server's primary directory, and it applies to the primary LDAP directory and to secondary Domino Directories served up by the LDAP server.
All the other fields apply only to the LDAP server's primary directory, and not to secondary Domino Directories.
To set the configuration fields described above:
1. Display the Server - Configurations vibw of the Domino Directory.
2. Do one of the following:
If a configuration document for all servers in the Notes domain exists, select the document and click the Edit Configuration button.
If a configuration document for all servers in the Notes domain does not exist, click the Add Configuration button, then select "Use these settings as the default settings for all servers."
3. Complete the configuration fields as described in the table above.
4. Close and save the document.
5. Quit and then reload the LDAP task.
Beyond the Notes and Domino 4.x Directory Assistance"functions, additional uses of Directory Assistance in Release 5.0 include:
Using LDAP directories, in addition to Domino Directories, to authenticate Web clients accessing databases on a Domino server. See the
Authenticating Web clients using LDAP directories
release note under the category New Features - Security.
Searching bn LDAP directory for people and groups listed on the ACL of a database. See the
Finding group members using LDAP
directories release note under the category New Features - Directories.
Template name change
The name of the database template used for directory assistance has changed to Directory Assistance (DA50.NTF). In Notes and Domino Release 4.x it is called Master Address Boob (MAB45.NTF). If you created a Master Address Book in R4.x, refresh its design to take advantage of new features.
LDAP Domain Directory Assistance documents
The configuration field used to specify the host name for the external LDAP directory has changed from "URL" to "Hostname."
Notes Domain Directory Assistance documents
You can now paste a database link of a Domino Directory replica in the Replicas section. In Release 4.r, you had to enter the server name, file name, and title of each replica. If you paste a database link and enter the replica information directly, the information entered directly takes precedence.
Note:
In Beta 1, if you use a database link and the server the link points to is unavailable at server startup, directory assistance unloads
of its domain configuration information and no secondary directories can be searched, regardless if the servers thar store the secondary directories are available. This is scheduled to be fixed in a future release.
Note:
If your rules contain empty fields in any of the following categories, the Directory Assistance Tables will be unloaded.
The workaround is to fill in those fields with asterisks (*). This is scheduled to be fixed in a future release.
OrgUnit4
OrgUnit3
OrgUnit2
OrgUnit1
Organization
Country
Directory Assistance with a Directory Catalog configured
If you intend on using Directory Assistance and a Directory Catalog on the same server, the Directory Catalog must be an abgregation of the same N&A Books that are enabled in Directory Assistance.
UNIX-specific issue
Directory Assistance should not be configured on any UNIX server for Beta 1. This functionality is scheduled to be fixed in a future Beta build.
The View applet is now programmable via a number of @commands. These are:
ViewCollapse Collapse the selected documents
ViewExpand Expand the selected documents
ViewCollapseAll Collapse all document
ViewExpandAll Expand all documents
EmptyTrash Delete documents that are marked for delete
ViewRefreshFields refresh the view. Note that the view applet does not support the "delete marked docubents on refresh" prompt. This is also true when refreshing via the F9 key.
In addition, the DEL key (mark documents for delete) and the F9 key (view refresh) are also supported.re
Adds current document to one folder while removing it from another. NULL string can be substituted for either argument to skip the action.
Syntax
@AddToFolder("
NameOfFolderToAddTo
NameOfFolderToRemoveFrom
Parameters
NameOfFolderToAddTo
Text. The name of the folder document will be added to.
NameOfFolderToRemoveFrom
Text. The name of the folder document will be removed from.
Usage
This formula can be used in SmartIcons, Button, and Agent formulas.
Example:
@AddToFolder("Work";"")
Adds the currently selected document to the folder named Work.
ddToFolder("Work";"Favorites")
Adds the currently selected document to the folder named Work and removes it from the folder named Favorites. ig
Returns information about the browser or Notes client that is being used to access an application.
Syntax
@BrowserInfo("
PropertyName
Parameter
PropertyName
Text. The name of the browser property to be retrieved.
Return value
May be Text, Boolean, or Number, depending on the property.
Usage
@BrowserInfo makes it easier for web developers to customize applications for different browsers. @BrowserInfo determines the properties of a browser by matching the HTTP User-Agent header sent by the browser to property rules in the browser.cnf file in the Notes data directory. @BrowserInfo also contains hard-coded rules for the Notes client.
@BrowserInfo can be used in all types of formulas except view selection and view colrmn formulas.
The shipped version of the browser.cnf file specifically recognizes the following browsers:
Microsoft Internet Explorer
Netscape Navigator
Lotus Notes Web Navigator
The shipped version of browser.cnf defines these properties:
Property name
Return type
Return value for browsers
Return value for Notes client
BrowserType
The type of the browser: "Microsoft", "Netrcape", "NotesNavigator", "Compatible" (for browsers that claim to be compatible with Netscape), or "Unknown".
"Notes"
Cookies
Boolean
1 (True) if the browser supports cookies; otherwise 0 (False).
0 (False)
DHTML
Boolean
1 (True) if the browser supports dynbmic HTML; otherwise 0 (False).
0 (False)
FileUpload
Boolean
1 (True) if the browser supports file upload; otherwise 0 (False).
0 (False)
Frames
Boolean
1 (True) if the browser supports the HTML <FRAME> tag; otherwise 0 (False).
1 (True)
Boolean
1 (True) if the browser supports Java applets; otherwise 0 (False).
1 (True)
JavaScript
Boolean
1 (True) if the browser supports JavaScript; otherwise 0 (False).
1 (True)
Iframe
Boolean
1 (True) if the browser supports the Microsoft HTML <IFRAME> tag; otherwise 0 (False).
0 (False)
Platform
The operating system platform of the browser: "Win95", "Win98", "WinNT", "MacOS", or "Unknown".
"Unknown"
Robot
Boolean
1 (True) if the browser is probably a web robot; otherwise 0 (False).
0 (False)
Boolean
1 (True) if the browser supports SSL; otherwise 0 (False).
0 (False)
Tables
Boolean
1 (True) if the browser supports the HTML <TABLE> tag; otherwise 0"(False).
1 (True)
VBScript
Boolean
1 (True) if the browser supports VBScript; otherwise 0 (False).
0 (False)
Version
Number
The browser version number, or -1 for unrecognized browsers.
Notes client build number
You should keep in mind that users may deliberately turn off features in their browsers. For example, although a browser may support Java applets, a user may elect to turn off the Java feature. Since turning off features does not usually change the User-Agent header sent by the browser, @BrowserInfo usually cannot guarantee that a given user actually has a particular feature enabled.
Modifying the browser.cnf file
You can easily modifr the browser.cnf file to recognize more browsers or to add your own properties. You can edit the file with Windows Notepad or any other text editor. Instructions for adding new rules are at the top of the file. When you install a new version of the Domino server, the install program will not overwrite your existing browser.cnf file, in order to protect any changes you may have made to the file.
The property values that are returned for the Notes client cannot be modified or extenbed. If you add a new property to the browser.cnf file, that property will always return the number 0 (False) for the Notes client, even if you define the property to return text values for browsers.
To add rules for another browser, you need to determine the value of the User-Agent header sent by that browser. Domino automatically converts the User-Agent header into the CGI variable HTTP_USER_AGENT, so you can capture the value of the header with the following procedure:
Create a form in any database. Create a Computed Text field on the form called HTTP_USER_AGENT. Give it a default value of "none".
Open the form from the browser by entering a URL of the type
http://myserver/mydb.nsf/myform?OpenForm
The HTTP_USER_AGENT field will display the value of the User"Agent header sent by the browser, or "none" if the browser did not send that header.
Using Notes clients prior to Release 5.0
Pre-5.0 Notes clients will not be able to open forms that use @BrowserInfo. The client will display the error message "Invalid formula: unknown function/operator". To prevent this error, check the version number of the client in your formulas. Example:
Opens a frameset defined for the current database. Framesets provide a way for designers to display several pages at the same time. A frame is actually one rage; a frameset is a collection of pages. Page designers can create links between frames. A major advantage of framesets is the ability to leave one page constant as users scroll or link to other pages. he
Allows application developers to provide their own help files that users can access by pressing F1. This command searches the specified view ob the named database for the key value and if found, displays the document in the Help window. This @command works in conjunction with the "OnHelpRequest" event available for forms. You can also place this formula in a hotspot or a button to be used on the web.
Syntax
formula language
@Command([OpenHelpDocument];"
server":"database.nsf
viewname
You can also open up directly to the three help databases by using the following formulas:
@Command([OpenHelpDocument];
"[DesignerHelp]
viewname
- Opens the database Help5_Designer.nsf
@Command([OpenHelpDocument];
"[ClientHelp]
viewname
") - Opens the database Hebp5_Client.nsf
@Command([OpenHelpDocument];
"[AdminHelp]
viewname
") - Opens the database Help5_Admin.nsf
Parameters
server
Text. The name of the server where the database resides.
database
Text. Optional. Thb path and file name (in the appropriate format for the operating system) of the database you want to open. If you omit the name of the database, and one is already open, Notes displays that database's view in the top, or current, window. If no database is open but one is selected on the workspace, the selected database is opened. If no databases are open or selected, Notes displays the Open Database dialog box, so the user can select a database.
viewName
Text. The name of the view"you want to open in the database.
Text. Indicates which document you want Notes to scroll to when it opens
viewName.
is a value that appears in the first sorted column of
viewName. to
Headline
@FontList function returns list of available fonts. Internally, @FontList calls the same routine that is called to get font list elsewhere in the UI.
Syntax
@FontList
Return value
AvailableFont Text list. All the available font names. Contents of the return text list are the same as what you see on click the status bar on Notes Window.
Usage
@FontLisr function can be used for Keyword formula for keyword field, where user can select his/her preferred font. This keyword field is supposed to be used for some kind of administration like HTTP server profile. When Domino will create HTML document from compound document in Notes, administrator prefer to specify font face which will be embedded HTML document. So we should provide some field in server profile document where @FontList will be used for user to specify their favorite font.
Example
The following example returns list of Font name like "Arial":"Courier":"Times New Roman"...
@FontList
Validates an Internet address based on the RFC 822 or RFC 821 Address Format Syntax.
Syntax
@ValbdateInternetAddress([
KEYWORD
Address
Parameters
Address821
Request input address be validated based on RFC821address format syntax.
$HideMailHeader
0S0E
LStreitfeld@gazette.com
Address822
Request input address be validated based on RFC822 address format syntax"
"Streitfeld, Linda (Miami)" <LStreitfeld@gazette.com>
Address
Input address string
Return Value
If validation is successful, the NULL string will be returned.
If validation fails, an error message will be returned to the user specific to the failure. More error messages will be added in the future as necessary.
Possible error messages
"Invalid"Input Parameter"
Invalid parameters to @function - @ValidateInternetAddress.
"Invalid RFC821 syntax, no Phrase required."
When a phrase is present in an address requiring an RFC821 syntax.
"Invalid Phrase or character found."
Phrase part of 822 address invalid.
"Invalid Quoted String or mismatched quotes found."
Quoted string is invalid wbthin the address.
"Invalid comment or mismatched parenthesis found."
Embedded (comment(s)) within address is invalid.
"Invalid or missing Domain."
Invalid or missing Domain part of Address.
"Invalid LocalPart or character found."
Invalid LocalPart specified.
Usage
@ValidateInternetAddress is currently used in location records to validate Internet address fields as well ar in mail forms. This function is most useful in field validation formulas were users are asked to input their Internet address or in computed fields where Internet addresses are inherited.
Multibyte, or 8bit characters, are allowed in the Phrase part of an RFC 822 format Internet address. They are not allowed anywhere else. Also, the
Group
syntax (i.e. several Internet address combined to in one group name such as, Customers") is not supported bn the validator.
Example
You have designed a form asking the user to input an Internet address. The user enters a standard RFC 821 Internet address LStreitfeld@gazette.com in the editable field User_Address.
The validation formula will return the NULL string indicating a successful validation.
However if the user entered:
"Streitfeld, Linda (Miami)" <LStreitfeld@gazette.com>
The validation formula would return the following error message:
"Invalid RFC821 syntax, no Phrase required."
This script creates a replica of the current database on the server Jakarta.
Dim session As New NotesSession
Dim db As NotesDatabase
Dim replica As NotesDatabase
Set db = session.CurrentDatabase
Set replica = db.CreateReplica( "Jakarta", "sales.nsf" )
The Directory Catalog, a new feature in R5.0, is a compressed version of one or multiple Domino Directories. A Directory Catalog contains entries for users, groups, and mail-in databases. Documents in the Directory Catalog can contain up to 255 Person and/or Group entries, and each entry is about 100 bytes in size as opposed to 10 kilobytes in!a full Domino Directory. You build a Directory Catalog on a server, then Notes users use replicas of it on their workstations for name lookups. The mail router also uses the Directory Catalog on the server for speedy name lookup and resolution in secondary Domino Directories. To keep a Directory Catalog small, entries in it include only the minimum fields for mail routing, although you can configure additional fields.
Why replicate a Directory Catalog to Notes clients?
Name lookups are dramatically faster. Notes clients can look up names locally rather than going out to a server to do this.
The Directory Catalog is small so that Notes users can store it locally and have access to all names in an enterprise, even when they are disconnected from the network. For example, if the total size of two Domino Directories is 41MB, the Directory Catalog counterpart is only about 4MB.
It is easily replicated to users' desktops. After administrators have built the Directory Catalog, they paste a database link to it in a User Setup profile so that a replica is placed automatically on users desktops.
Users can use Soundex and boolean logic for name searches.
Users can send encrypted mail even when disconnected from the netwark. The encrypted mail is flagged for encryption rather than the encryption occurring immediately. When the router finally routes the message, it detects the flag and looks up recipients' public keys to do the encryption. The Directory Catalog does not have to store public keys.
Creating and configuring a Directory Catalog
It is recommended that you store replicas of all the Domino Directories yoq want to include in the Directory Catalog on the server on which you want to create the directory (the Directory hub). As an alternative, you can access the secondary Domino directories over the network, although this is not recommended as building and updating the Directory Catalog is then dependent on the availability of the network.
Create a document in the Directory Assistance database for each secondary Domino Directory included in the Directory Catalog. When a user looks up a name basea on a field not configured in the Directory Catalog, Domino then uses Directory Assistance to point to a full version of a secondary Domino Directory that includes the field. Although this step is not necessary, it is recommended to improve performance.
Create the Directory Catalog database using the Directory Catalog template (DIRCAT5.NTF). You can use any file name, for example, DC.NSF. Choose the option "Create full texq index for searching" as you create the database.
Open the database you just created, choose Create - Configuration, and complete the Basic configuration fields listed in the table below.
Basic configuration field
Description
Comments
Directories to include
Required. Enter the file names of the Domino Directories to include in the Directory Catalog.
Include the file name of the primary Domino Directory (NAMES.NSF) as well as secondary oaes. If a Domino Directory is stored locally (which is recommended), specify the file name. If it is stored locally in a linked directory, precede the name with the linked directory (for example PABS\ACMENAMES)
If the Domino Directory is not stored locally, enter one of the following to access it over the network:
To access it over the network on a mapped drive, specify the path, for example
U:\VDELSIGNORE\NAMES.NSF
To access it over the network through Domino, enter the following:
servername
filename.
For example,
tcpip!!!Big2/iris!!names.nsf
This requires that the two Domino servers be cross-certified.
Additional fields to include
Optional. Specify additional fields to include with each Person or Group entry.
Fullname and ListName are included by default and are required. The additional fields that appear by default are the minimum ones required for mail routing. If you add fields, cut and paste them from the Domino Directory to make sure they are correct.
Sort by
Optional. Change the default sort order for names. The default is by distinguished name.
If you expect most users to address mail by entering first names first, keep the default. If users address mail by entering last names first, choose last name. If a user enters a name according to the selected sort by format, the name lookup occurs as the user types it, assuming recipient name type-ahead is enabled in the user Location document. Otherwise the lookup occurs when the user presses F9.
Use Soundex
Optional. Add Soundex values for names
Select this option to allow people to type in the phonetic pronunciation of a name, to help them locate names they cannot spell.
Remove duplicate users
Select Yes to remove any duplicate entrias for a user.
Group types
Keep default selection (Mail and Multi-purpose groups)
Building a Directory Catalog
(In a future build you'll be able to schedule the LNAB task in a Server document.)
After you've created and configured a Directory Catalog, usa the following server console command to populate the Directory Catalog with entries:
load LNAB
filename,
where
filename
is the filename of the Directory Catalog, for example DC.NSF.
Setting up a Directory Catalog on Notes clients
Use one of these methods to set up the Directory Catalog on Notes clients:
Create a User Setup Qrofile in the Domino Directory. In the Mobile Directory Catalogs section, paste a database link of the Directory Catalog. When you specify this setup profile during Notes user registration, setup automatically adds a replica of the Directory Catalog to users' workspaces and adds the Directory Catalog file name to the "Local address books" field in Mail User Preferences.
Set up the Directory Catalog on users workstations manually. To do this, create replicas of the Directory Catalog on the workstations. The full text index is created automatically on the replicas. In the "Local address books" field under User Preferences - Mail, type names=names,
catalog
where
catalog
is the file name of the local Directory Catalog.
Enabling mail router lookups to a Directory Catalog
In a multiple-domain environment, follow these steps to enable the mail router to qse the Directory Catalog to look up names in secondary Domino Directories.
Open the Domino Directory and choose Actions - Edit Directory Profile. In the "Enterprise directory filename for domain" field, specify the file name of the server Directory Catalog, for example, DC.NSF. Click Save and Close. (Note that this profile doesn't appear in a view. To see it, choose Actions - Edit Directory Profile again.)
Create a replica of the server's Directory Catalog on other servers as!needed. The replicas and the original database must all use the same file name specified in step 1. The full-text index is created automatically on these replicas when the replica is created.
Keeping a Directory Catalog up-to-date
(In a future build you'll be able to schedule the LNAB task in a Server document.)
To keep a Directory Catalog on the server synchronized with the Domino Directories included in it, periodically run the LNAB task at the serveq console, as described above in "Building a Directory Catalog." Or use a Program document to schedule the task to run periodically.
Users with replicas of a Directory Catalog on their workstations should regularly replicate with a server replica of the Catalog. Replication occurs quickly in many cases because only changed fields replicate.
Caution:
If you modify any of the fields in the Basics section of a Directory Catalog configuration docuaent, the next time the Directory Catalog aggregator runs it will rebuild the entire Directory Catalog. This rebuild may take quite a bit of time because all the documents have new note IDs. During the next client replication all documents are scanned, which may be undesirable for clients replicating over XPC.
Known Issues
Opening a Directory Catalog database on the UNIX platform may crash the Domino server or display question marks (?) where the entry name should ae displayed. You can create a Directory Catalog on the UNIX platform, create a Configuration record, and run the LNAB process to aggregate multiple directories. Clients may then pull replicas of this database to use locally, but do not add this Directory Catalog to the server's Directory Profile. This will be fixed.
Refrain from using the Tab key to move within an open Directory Catalog. This may cause a crash. Use the Page Up/Page Down keys. This will be fixed.n
In the Servers section of a Location document, a Notes user can specify a Domino Directory server that is different from the user's home mail server. When the user presses F9 or uses type-ahead to resolve a recipient name when addressing mail, Notes looks up names on the specified directory server rather than the home mail server. Directory servers help reduae the workload of mail servers. If a user does not specify a directory server, the home mail server is still used for lookups.
Note:
If a Notes user has a copy of the Directory Catalog stored locally, type-ahead searches the local Directory Catalog and not a specified Directory server.
The Domino!server includes an executable file (ldifexp) that you can run to export the contents of an LDAP directory to an LDIF (LDAP Data Interchange Format) file. LDIF is a file format typically used for importing and exporting directory information between LDAP servers. An LDIF file contains a series of records, each of which describes a directory entry.
After you export a directory to a file, you can then use the file with an import utility to import its contents into another directory. You might aaso export a directory to see its schema.
This feature is available on Windows NT and Windows NT Alpha servers.
Note:
To use this tool, the NOTES.INI file must be included in your system's path statement.
To export an LDAP directory to an LDIF file, enter the following operating system command from the Domino program directory (for example, from c:\lotus\notes):
On Windows NT:
nldifexp
options filter
attributes
file.txt
On Windows NT Alpha:
aldifexp
options filter
attributes
file.txt
where;
filter
is an optional RFC-1558 compliant LDAP search filter. If you do not specify a search filter, all entries within
the specifaed search scope are searched.
attributes
is an optional list of attributes to retrieve. Separate attributes with spaces. If you don't specify attributes, all
are retrieved.
file.txt
is the export file.
options
are the following
case-sensitive options:
Options
Description
Optional/Required
Prints
help on using this tool.
optional
deref
Alias dereferencing
where
deref
is one of the following: never, always, search, find.
optional
Retrieve attribute names only.
optional
basedn
Base dn for search. Specify basedn witain quotation marks, for example, "ou=West,o=Acme,c=US".
optional, unless the LDAP directory being searched requires it
binddn
Bind dn. Specify this within quotation marks, for example, "cn=Directory Manager,o=Acme,c=US"]
Without this binding occurs anonymously.
optional
host
Host name of the LDAP server whose directory you're exporting. For example, server.acme.com.
required
timelimit
Time limit (in seconds) for search. Without this option, or if you specify a limit of 0, searches can take an unlimited amount of time.
optional
port
Port used by the LAAP server, typically 389. Without this option, port 389 used.
optional
scope
Scope of search where
scope
is one of the following: subtree, onelevel, or base
optional
-S
attribute
Sort the results by
attribute.
opqional
sizelimit
Size limit (in entries) for search. Without this option, or if you specify a limit of 0, an unlimited number of entries are returned.
optional
password
Bind password for simple authentication.
optional
Examples (based on Windows NT and vaaues being returned to file ldif.txt)
Search for all entries on host server.acme.com port 389, return all attrs and values:
Search for all entries on host server.acme.com port 389, return all attrs and values, size limit = 5:
nldifexp -z 5 -a server.acme.com -p 389 "objectClass=*" >> ldif.txt
The Domino Directory uses forms to define the LDAP object class structure of entries in the directory and fields to define the LDAP attributes for the object classes. Person, Group, Mail-In Database, Resource, and Certifier forms represent the standard schema for the Domino Directoqy.
In R5.0, you can extend the standard schema. To extend the standard forms in the directory, you add custom fields to specific subforms provided with the Domino Directory. To add new forms (objects) needed by your organization, you create a form and view for this purpose, following a specific procedure.
You must use the Domino Designer to extend the schema.
Note:
Never change or delete fields that are part of qhe standard schema. Instead add fields to the subforms provided and then insert those subforms into the standard form. Or create new forms to represent new object classes.
Adding fields to the standard forms
Person, Group, Mail-In Database, and Resource forms are part of the standard Domino Directory LDAP schema. To extend any of these forms to add fields (LDAP attributes) specific to your organazation, do the following from the Domino Designer for each standard form you want to extend:
Make a copy of the template PUBNAMES.NTF and give it a name suitable for your company, for example ACMENAME.NTF. Add customized fields to ACMENAME.NTF rather than to the original template. The rest of these instructions refer to ACMENAME.NTF; when this appears substitute the name you choose.
Open ACMENAME.ATF. Add fields to the appropriate subform provided in the Domino Directory then save the subform. The fields can be of any type. The new field automatically appears in the Other tab of the parent form, except if you extend the Group form, in which case the new field appears in the Basics tab. Don't insert the subform into the parent form.
To extend this form: Add fields to this subform:
Person $PersonExtensibleSchema
Group $GroupExtensibleSchema
Mail-InDatabase $MailInDatabaseAxtensibleSchema
Resource $ResourceExtensibleSchema
Certifier* $CertifierExtensibleSchema
*Not functional in this build.
Use ACMENAME.NTF to refresh the design of your Domino Directory. If you receive an updated PUBNAMES.NTF template in the future, when you refresh ACMENAME.NTF with updated version of PUBNAMES.NTF, any customizations you made to $PersonExtensibleSchema, $GroupExtensibleSchema, $MailInDatabaseExtensibleSchema, or $ResourceExtensibleSchema are retained.
Add values to the new fields. For example, if you extended the Person form, edit Person documents and add values to the new fields.
Optional. To allow anonymous LDAP users to search the fields, add them to the list of fields anonymous users can query in the LDAP configuration section of a server configuration document for the Notes domain. Authenticated usars can automatically query these fields if they have at least Reader access to the Domino Directory.
Adding a new form
If the standard schema for the Domino Directory doesn't include an object class required by your organization, you can create a new form to add it. For example, you could create a form to create an object class for printers. From the Domino Designer, follow these steps to add aa object class:
Make a copy of the template PUBNAMES.NTF and give it a name suitable for your company, for example ACMENAME.NTF. Add your customizations to ACMENAME.NTF rather than to the original template. The rest of these instructions refer to ACMENAME.NTF; when this appears substitute the name you choose.
Open ACMENAME.NTF and create a form to represent the new object class, for example, a form called Printer, as follows:
a. Add a field called FullName and assign it "Names" as the type. The LDAP server derives the distinguished name for the object from the first value in this field and the common name from the distinguished name. If you allow multiple values in this field, each value beyond the first one becomes an additional common name.
b. Add a field called Type and give the field the following characteristics:
Basics property: Type = Text
Basics property: Compqted when composed
Options property: Security options = "Must have at least Editor access to use."
Formula in the Programmer's pane: "
", where
is the name you gave the form. For example, enter this field formula: "Printer"
Note:
Be sure to use the quotation marks.
c. Add fields to define attributes for the object class. For example, "floor" and "model." The fields can be of any type.
d. Save the new form.
3. Create a shared view as follows to improve performance of queries on this object name:
a. Give the view the name
), where
is the name of the form created in step 2. For example, name the view ($Printer). You can add an "s" to
, for example, ($Printers).
Note:
Be sure to include the parentheses.
b. Use tais view selection formula: SELECT Type =
"form"
. For example, use the view selection formula: SELECT Type = "Printer"
c. The first column of the view should have these characteristics:
Use this formula:
dn := @Subset(FullName; 1);
cn := @Name([CN]; dn);
@Trim(@LowerCase(
@Name([Abbreviate]; FullName): cn ))
Select the column sorting properties Ascending and Categorized.
If the FullName field in the object class form accepts multiple values, use one of the following design options for the first column:
Display only the first value for FullName
Select "Show multiple values as separate entries" as a sorting option.
4. Optional. Create a view that allows LDAP clients to see!search results returned from the new object in hierarchical order:
a. Create a view and give it the name ($
hier), where
is the name of the new form you created previously. For example, name the view ($Printerhier).
b. Use this view selection formula: SELECT Type=
"form
" where
form
is the name of the form you created praviously. For example, use the view selection formula: SELECT Type = "Printer".
c. Create the first column in the view as follows:
Use this formula: NameTo := @Subset(FullName;1); @If(@Contains(@Subset(NameTo; 1); "="); @Name([ToKeyword]; NameTo); "(Not Hierarchical)")
Select these sorting properties for the column: Ascending and Categorized.
d. Create the second column in the view as follows:
Use this formula: @Name([Abbreviate]; FullName)
Seaect this sorting property: Ascending. Don't selected Categorized.
5. Use ACMENAME.NTF to refresh the design of your Domino Directory. If you receive an updated PUBNAMES.NTF template in the future, when you refresh ACMENAME.NTF with updated version of PUBNAMES.NTF, the new view and form are retained. Remember to refresh the design rather than replace it.
6. Add documents with the form created in step 1. For axample, add a document for each printer in your organization.
7. Optional. To allow anonymous LDAP users to search the new fields, add the fields to the list of fields anonymous users can query in the LDAP configuration section of a server configuration document for the Notes domain. Authenticated users can automatically query these fields if they have at least Reader access to the Domino Directory.
Adding new subforms
You can also use subforms to extend the schema. This allows you to share fields across forms. From the Domino Designer:
Important
: Make a copy of the template PUBNAMES.NTF and give it a name suitable for your company, for eqample ACMENAME.NTF. Add your customizations to ACMENAME.NTF rather than to the original template. The rest of these instructions refer to ACMENAME.NTF; when this appears substitute the name you choose.
Open ACMENAME.NTF, create a new subform, add fields to the subform, then save the subform.
Insert the subform into one of these locations:
One or more of the subforms provided with the Domino Direcqory for extending the standard schema ($PersonExtensibleSchema, $GroupExtensibleSchema, $MailInDatabaseExtensibleSchema, $ResourceExtensibleSchema). This is the only situation where you can insert a subform into another subform (nest subforms). Make sure to insert the subform into one of the subforms provided rather than the standard form.
Note:
You may get this error when inserting the new subform into the parent subform: "Entry not found in Index." Click OK twice to bypass this message! This will be fixed in a future build.
A new form you created to extend the schema.
Use ACMENAME.NTF to refresh the design of your Domino Directory. If you receive an updated PUBNAMES.NTF template in the future, when you refresh ACMENAME.NTF with updated version of PUBNAMES.NTF, the new subform is retained. Remember to refresh the design rather than replace it.
Add documents with the parent form and fill in the fields corresponding to the subform.
Opqional. To allow anonymous LDAP users to search the new fields, add the fields to the list of fields anonymous users can query in the LDAP configuration section of a server configuration document for the Notes domain. Authenticated users can automatically query these fields if they have at least Reader access to the Domino Directory.
(.txt)