Home
IBM Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Lotus® Connectors
Lotus® Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
LSX for Lotus® Connectors
LotusScrip Extensions for Lotus® Connectors (LC LSX) enhances the power of Notes® by extending its scripting to data outside of Notes through the use of Lotus Connectors. 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 specific system.
Chapter 5 LCField Class
This chapter provides information about the LCField class methods and properties.
SetFormatStream Method for LCField
This method assigns the current format setting for a stream field. Calling this method clears all values for this field.

IBM Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
- Application Design
  Welcome to the Application Design section of Domino® Designer Help.
- Domino® Designer templates
  The templates described in the following table are available with Domino® Designer and are specifically intended for use by application developers.
- Importing to and exporting from views
- Developing applications using MAPI
  Domino® Designer Release 6 and later supports the messaging application program interface (MAPI), which allows mail integration between Domino and a MAPI-compliant messaging application, such as Microsoft™ Outlook, Microsoft Office applications, or user-written C++ programs.
- Features to avoid using in Web applications
  Developers creating applications specifically for the Web, or for the dual purpose of serving Notes® and Web clients, should review the following tables for features that are not supported on the Web.
- URL commands for Web applications
  You have a variety of options for programming a Web site. You can directly manipulate objects such as documents or views in an application using Domino® URL commands. Adding Domino URL commands as HTML in forms gives users shortcuts for navigating databases and performing other tasks quickly.
- Application Management
  Welcome to the Application Management section of Domino® Designer Help.
- Composite Applications - Design and Management
  Composite applications are a key element in a service-oriented architecture (SOA) and contextual collaboration strategy. The ability to create and edit composite applications lets you easily integrate different types of components and technologies.
- DB2® Access views
  Domino® Designer includes two types of design elements to assist you in managing data contained in DB2® enabled Notes® databases:
- Programming Overview and User Interface
  This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
- Formula Language
  This section documents the formula language.
- LotusScript® Language
  Welcome to the LotusScript® Language section of Domino® Designer Help.
- LotusScript/COM/OLE Classes
- Java/CORBA Classes
  This section documents the Java/CORBA classes.
- Lotus® Connectors
  Lotus® Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
  - Lotus® Connectors and Connectivity Guide
  - LSX for Lotus® Connectors
    LotusScrip Extensions for Lotus® Connectors (LC LSX) enhances the power of Notes® by extending its scripting to data outside of Notes through the use of Lotus Connectors. 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 specific system.
    - Chapter 1 Introduction
      This chapter provides an introduction to the LotusScript® Extension for Lotus® Connectors (LC LSX) and explains the organization of this manual.
    - Chapter 2 LCConnection Class
      This chapter provides information about the LCConnection class methods and properties.
    - Chapter 3 LCCurrency Class
      This chapter provides information about the LCCurrency class methods and properties.
    - Chapter 4 LCDatetime Class
      This chapter provides information about the LCDatetime class methods and properties.
    - Chapter 5 LCField Class
      This chapter provides information about the LCField class methods and properties.
      - LCField class overview
        The LCField class represents a data object containing one or more data values of a designated data type. Most of the methods in the LCField class have an "index" argument, specifying which of the potentially multiple values in the field to operate on. Index values start at 1.
      - Syntax for LEI Scripted Activities - 1
        When writing LotusScript® Extensions (LC LSX) scripts for LEI Scripted activities, you must specify Dim LCSession as a named session (this becomes the default log document name). LCConnections must also be dimensioned as existing, named IBM® Lotus Enterprise Integrator® (LEI) connection documents.
      - LCField Class Methods and Properties Summary
        The methods for the LCField class are summarized as follows.
      - New Method for LCField
        This is the constructor method for LCField. It initializes an LCField object.
      - ClearVirtualCode Method for LCField
        This method clears the specified virtual code for the field. Virtual codes flag fields as special system properties recognized by different systems. Refer to the connector documentation for specific codes supported by each connection.
      - Compare Method for LCField
        This method compares data values between two fields and returns the relationship.
      - Convert Method for LCField
        This method converts data values to the data type of a destination field.
      - Copy Method for LCField
        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 references to, the original data.
      - GetCurrency Method for LCField
        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. If conversion is not possible, error LCFAIL_INVALID_CONVERT occurs.
      - GetDatetime Method for LCField
        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. If conversion is not possible, error LCFAIL_INVALID_CONVERT occurs.
      - GetFieldlist Method for LCField
        This method retrieves a fieldlist from a field. The resulting fieldlist is a reference to the original inside the field. If the field doesn't contain an LCFieldlist as its value, an LCFAIL_INVALID_CONVERT error will occur.
      - GetFloat Method for LCField
        This 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.
      - GetFormatDatetime Method for LCField
        This method retrieves the format of a Datetime type field. It is only valid for fields of type Datetime.
      - GetFormatNumber Method for LCField
        This method retrieves the format of a number type field. It is only valid for fields of type int, currency, float or numeric.
      - GetFormatStream Method for LCField
        This method retrieves the format of a stream type field. It is only valid for fields of type text or binary.
      - GetInt Method for LCField
        This method retrieves an integer from a value in a field. If the requested data type is different from the field data type, conversion is automatically performed. If conversion is not possible, error LCFAIL_INVALID_CONVERT occurs.
      - GetNumeric Method for LCField
        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. If conversion is not possible, error LCFAIL_INVALID_CONVERT occurs.
      - GetStream Method for LCField
        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. If conversion is not possible, error LCFAIL_INVALID_CONVERT occurs.
      - IsNull Method for LCField
        This method returns true or false depending on whether the specified field data is NULL. A field may potentially contain multiple values, some of which are null and others not.
      - LookupVirtualCode Method for LCField
        This method checks if a specific VirtualCode has been set for a field. Virtual codes flag fields as special system properties recognized by different systems. Refer to the connector documentation for specific codes supported by each connection.
      - SetCurrency Method for LCField
        This method sets a field value to a supplied LCCurrency value. If the field is not of a Currency data type, Notes® will attempt to convert the supplied value to the data type of the field. If conversion fails, error LCFAIL_INVALID_CONVERT will occur.
      - SetDatetime Method for LCField
        This method sets a field value to a supplied LCDatetime value. If the field is not of a datetime data type, Notes® will attempt to convert the supplied value to the data type of the field. If conversion fails, error LCFAIL_INVALID_CONVERT will occur. Datetimes can only be converted to Stream data types.
      - SetFieldlist Method for LCField
        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.
      - SetFloat Method for LCField
        This method assigns a value to a field of type float. If the field data type is different, conversion will be attempted. If conversion fails, error LCFAIL_INVALID_CONVERT will occur.
      - SetFormatDatetime Method for LCField
        This method changes the format setting for a datetime field. Calling this method clears all values for this field. The field must be of a datetime type, or error LCFAIL_TYPE_MISMATCH will occur.
      - SetFormatNumber Method for LCField
        This method assigns the current format setting for a number field. Calling this method clears all values for this field.
      - SetFormatStream Method for LCField
        This method assigns the current format setting for a stream field. Calling this method clears all values for this field.
      - SetInt Method for LCField
        This method sets the value of the field to a specified long integer value. If the field is not of type LCTYPE_INT, Notes® tries to convert the value to the field's type. If this fails, error LCFAIL_INVALID_CONVERT will occur.
      - SetNull Method for LCField
        This method sets the value of the field to the special value NULL. This value is recognized by relational databases as representing an empty field (as opposed to a field that contains a zero-length string, for instance).
      - SetNumeric Method for LCField
        This method sets the value of the field to a specified LCNumeric value. If the field is not of type LCTYPE_NUMERIC, Notes® tries to convert the value to the field's type. If this fails, error LCFAIL_INVALID_CONVERT will occur.
      - SetStream Method for LCField
        This method sets the value of the field to a specified LCStream value (text or binary). If the field is not of type LCTYPE_STREAM, or is of that type but uses a format that does not match the supplied value (text as opposed to binary, for instance), Notes® tries to convert the value to the field's type. If this fails, error LCFAIL_INVALID_CONVERT will occur.
      - SetVirtualCode Method for LCField
        This method adds a virtual code to the list of virtual codes for a field. Virtual codes flag fields as special system properties recognized by different systems. Refer to the connector documentation for specific codes supported by each connection.
    - Chapter 6 LCFieldlist Class
      This chapter provides information about the LCFieldlist class methods and properties.
    - Chapter 7 LCNumeric Class
      This chapter provides information about the LCNumeric class methods and properties.
    - Chapter 8 LCSession Class
      This chapter provides information about LCSession class methods and properties.
    - Chapter 9 LCStream Class
      This chapter provides information about the LCStream class methods and properties.
    - Appendix A Error Messages
      This appendix provides information about error messages.
    - Appendix B Connector Property Tokens
      This appendix provides information about the property tokens used in the LotusScript® Extensions (LC LSX).
    - Appendix C Connector Properties
      This chapter provides information about connector properties. These properties are used when creating connections using the Lotus® Connector LotusScript® Extensions.
    - Appendix D Character Sets
      This appendix provides information about character sets, including character set translation, character sort order, and a list of the character sets supported by the Lotus® Connector LotusScript® Extensions (LC LSX).
    - Appendix E Additional Scripting Capability for LEI
      This appendix provides information about additional methods and properties provided for IBM® Lotus Enterprise Integrator® (LEI) with the LCSession class that expand on the IBM Lotus® Connector LotusScript® Extensions (LC LSX).
  - Accessing external databases through LS:DO
    LS:DO has been in maintenance mode since R5. Developers are advised not to use it. Developers should use the Lotus® Connector LSX for (LCLSX) when accessing external data sources.
- Javadoc™ for Domino® Designer related APIs
  As part of providing additional Java™ reference documentation, Domino® Designer ships with a help plugin that contains Javadoc™ for additional Domino Designer related APIs.
- Accessibility and keyboard shortcuts
  Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.

SetFormatStream Method for LCField

This method assigns the current format setting for a stream field. Calling this method clears all values for this field.

Defined In

LCField

Syntax

Call thisField.SetFormatStream (streamFlags, maxLength, streamFormat)

Parameters


Parameter	Description
streamFlags	Long. Optional. Stream flags assigned to the field. In this chapter refer "LCField Class Methods and Properties Summary", under "Stream" for a description of the flags. The default is 0.
maxLength	Long, >= 0. Optional. Maximum length assigned to the stream field. A value of zero indicates no maximum length. The default is 0.
streamFormat	Long. Optional. Stream format assigned to the stream field. This may be either a character set selection from Appendix D or one of several special formats listed in the "LCStream Class" Chapter, in the "Stream Format" section . A value of zero indicates no specified stream format. The default is LCSTREAMFMT_UNICODE.

Example

Option Public
Uselsx "*lsxlc"  
Sub Initialize
  Dim field As New LCField (LCTYPE_BINARY)
  Dim fmt As Long
  Dim flags As Long
  Call field.SetFormatStream (LCSTREAMF_NO_CASE, 256, LCSTREAMFMT_BIG5)
  Call field.GetFormatStream (flags, , fmt)
  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