Contents

• Title and Copyright Information
• Preface
• 1 What’s New in This Release
  • What’s New in Siebel VB Language Reference Guide, Siebel CRM 19.1 Update
  • What’s New in Siebel VB Language Reference, Siebel 2018
• 2 About Siebel Visual Basic
  • About Siebel Visual Basic
  • Overview of Siebel Visual Basic
    • Siebel VB and Unicode
    • Typographic Conventions That This Book Uses
  • About Functions and Methods
  • Siebel VB and Other Versions of Visual Basic Programming Languages
    • Differences Between Siebel VB and Earlier Versions of Visual Basic
      • Line Numbers and Labels
      • Subroutines and Modularity
      • How Declaring a Variable Affects Variable Scope
      • Data Types
      • Financial Methods
      • Date and Time Methods
      • Methods to Access Other Applications
      • Environment Control
    • Differences Between Siebel VB and Visual Basic
      • Boolean Data Type
      • User Interface and Control Objects
• 3 Using Siebel VB
  • Using Siebel VB
    • Guidelines for Using Siebel VB
      • Pass Values Through Reference
        • Passing a Value Through a Reference
        • Passing a Value Through a Variable
      • Give Each Argument a Name
        • Format That You Can Use to Name an Argument
        • Naming an Argument With More Complex Formats
        • Where You Can Name an Argument
      • Other Guidelines
  • About Data Types
    • Overview of Data Types
    • Arrays
      • Dynamic Arrays
    • Numeric Data Types That Siebel VB Uses
    • Records
    • Strings
    • Variants
    • Type Characters
    • How Siebel VB Converts Data Types
      • Numeric Conversion
      • String Conversion
      • Variant Conversion
    • Comments
  • About Expressions
    • Numeric Operators
    • String Operators
    • Comparison Operators
    • Logical Operators
  • About Object Handling
    • Example of Declaring an Object As a Siebel CRM Object Type
    • Creating an Object Variable to Access an Object
    • Using Methods and Properties to Manipulate an Object
  • Declaring Procedures and Variables
    • Declaring a Procedure
      • Specifying the Data Type
      • Sequence Determines How You Must Declare Code
      • Calling External DLL Code
  • Declaring Variables
    • Determining Variable Scope
    • Specifying the Type When You Declare a Variable
    • Declaring an Array Variable
    • Declaring a Number Variable
    • Declaring a Record Variable
    • Declaring a String Variable
    • Declaring a Variant Variable
    • Declaring an Object Variable
    • Caution About Declaring Multiple Variables on One Line
    • Shared Keyword Allows Backward Compatibility
  • About Formatting Strings
    • Numeric Formats
      • Predefined Numeric Formats
      • Custom Numeric Formats
      • Scaling Numbers
      • Inserting Characters In Number Formats
      • Scientific Notation Formats
      • Using Sections In a Numeric Format
    • Date and Time Formats
      • Predefined Date and Time Formats
      • Custom Date Formats
      • Specifying Individual Parts of a Custom Date Format
      • Using a 12 Hour Format
    • Other Formatting Options
      • Changing Formatting Sequence
      • Changing Case
      • Handling Spaces That Occur in the Input String
  • About Error Handling
    • Overview of Error Handling
    • Handling Errors That Siebel VB Returns
      • Using the Body of the Code to Handle Siebel VB Errors
      • Using an Error Handler to Handle Siebel VB Errors
    • Handling Custom Errors
      • Using the Body of the Code to Handle Custom Errors
      • Using a Label to Handle Custom Errors
    • Handling Errors That a Siebel VB Method Returns
    • Error Code and Error Text for Siebel VB Errors
• 4 Methods Reference for Siebel VB
  • Methods Reference for Siebel VB
  • Overview of Siebel VB Language Reference
    • Usage of the Dollar Sign
    • Methods, Functions, and Statements Described in Siebel Object Interfaces Reference
  • Disk and Directory Control Methods
    • Change Directory Method
    • Change Drive Method
    • Create Directory Method
    • Get Current Directory Method
    • Remove Directory Method
  • File Control Methods
    • Close All Files Method
    • Close File Method
    • Copy File Method
    • Delete File Method
    • Get File Attributes Method
    • Get File Date Method
    • Get File Length Method
    • Get File Length 2 Method
    • Get File Mode Method
    • Get File Names Method
    • Get Free File Number Method
    • Lock File Method
    • Open File Method
    • Rename File Method
    • Set File Attributes Method
    • Unlock File Method
  • File Input and Output Methods
    • End of File Method
    • Get Characters From File Method
    • Get File Contents Method
    • Get File Offset Method
    • Get File Position Method
    • Get Line From File Method
    • Parse File Contents Method
    • Print Spaces Method
    • Print Data to File Method
    • Set File Position Method
    • Set File Width Method
    • Set Print Position Method
    • Write Data to File Method
    • Write Variable to File Method
  • Code Setup and Control Methods
    • Call Application Method
    • Call Subroutine Method
    • Create Subroutine Method
    • Create Function Method
    • Declare Custom Data Type Method
    • Declare Procedure Method
    • Declare Symbolic Constant Method
    • Get Environment Setting Method
    • Remove Object Method
    • Send Keystrokes Method
    • Use Clipboard Methods
  • Code Control Statements
    • Do Loop Statement
    • Exit Statement
    • For Next Statement
    • Go To Statement
    • If Then Else Statement
    • Go To Label Statement
    • Me Statement
    • Rem Statement
    • Select Case Statement
    • Stop Statement
    • While Wend Statement
  • Variable Manipulation Methods
    • Assign Expression to Variable Statement
    • Declare Variable Statement
    • Declare Global Variable Statement
    • Declare Static Variable Statement
    • Modify Variable Statement
    • Force Explicit Declaration Statement
    • Get Variant Type Method
    • Set Variable Data Type Statement
    • Set Variant Variable to Null Method
  • String Methods
    • Compare Strings Method
    • Compare Strings Operator
    • Convert Number to String Method
    • Convert String to Lowercase Method
    • Convert String to Uppercase Method
    • Copy String Method
    • Get a String of Spaces Method
    • Get ANSI String Method
    • Get First Number From String Method
    • Get Left String Method
    • Get Repeated Character String Method
    • Get Right String Method
    • Get String Length Method
    • Get Substring Method
    • Get Substring Position Method
    • Remove Spaces From String Method
    • Replace String Method
    • Right-Justify String Method
    • Set String Comparison Method
    • Set String Format Method
    • Trim Spaces From String Method
    • Trim Trailing Spaces From String Method
  • Array Methods
    • Declare Array Method
    • Erase Array Method
    • Get Array Lower Boundary Method
    • Get Array Upper Boundary Method
    • Set Array Lower Boundary Method
  • Mathematical Methods
    • Overview of Mathematical Methods
    • How Some Math Methods Handle the Data Type
    • Trigonometric Methods
    • Exponential Method
    • Get Absolute Value Method
    • Get ANSI Integer Method
    • Get Arctangent Method
    • Get Cosine Method
    • Get Hexadecimal Method
    • Get Integer Method
    • Get Rounded Integer Method
    • Get Logarithm Method
    • Get Octal Method
    • Get Number Sign Method
    • Get Random Number Method
    • Get Sine Method
    • Get Square Root Method
    • Get Tangent Method
    • Randomize Method
  • Date and Time Methods
    • Convert Number to Date Method
    • Convert Serial Number to Date Method
    • Convert String to Date Method
    • Convert String to Time Method
    • Extract Day From Date-Time Value Method
    • Extract Hour From Date-Time Value Method
    • Extract Minute From Date-Time Value Method
    • Extract Month From Date-Time Value Method
    • Extract Second From Date-Time Value Method
    • Extract Weekday From Date-Time Value Method
    • Extract Year From Date-Time Value Method
    • Get Current Date Method
    • Get Current Date and Time Method
    • Get Current Time Method
    • Get Current Seconds Method
    • Get Serial Time Method
    • Set Date Method
    • Set Time Method
  • ODBC Methods
    • Overview of ODBC Methods
    • ODBC Close Connection Method
    • ODBC Get Errors Method
    • ODBC Get Query Results Method
    • ODBC Get Schema Method
    • ODBC Open Connection Method
    • ODBC Run Query Method
    • ODBC Run Query and Get Results Method
    • ODBC Save Results to File Method
  • Object Querying Methods
    • Compare Object Expressions Operator
    • Is Expression a Date Method
    • Is Object Of Class Method
    • Is Optional Argument Missing Method
    • Is Variable Null Method
    • Is Variable Numeric Method
    • Is Variable Set Method
  • Financial Methods
    • Overview of Financial Methods
      • Arguments You Can Use with Financial Methods
      • How Some Financial Methods Use the Rate Argument
    • Calculate Future Value Method
    • Calculate Interest Method
    • Calculate Interest Rate Method
    • Calculate Internal Rate of Return Method
    • Calculate Net Present Value Method
    • Calculate Payment Method
    • Calculate Principal Method
    • Calculate Present Value Method
  • Conversion Methods
    • Argument That You Can Use with Conversion Methods
    • Convert Expression to Currency Method
    • Convert Expression to Double-Precision Method
    • Convert Expression to Integer Method
    • Convert Expression to Long Method
    • Convert Expression to Single-Precision Method
    • Convert Expression to String Method
    • Convert Expression to Variant Method
  • COM Methods
    • Assign COM Object Statement
    • COM Object Class
    • Create COM Object Method
    • Get COM Object Method
    • Initialize COM Object Method
  • Error Handling Methods
    • Get Error Code Method
    • Get Error Code Line Method
    • Get Error Message Method
    • On Error Method
    • Resume Statement
    • Set Error Code Method
    • Simulate Error Method
• 5 Quick Reference for Siebel VB Methods
  • Quick Reference for Siebel VB Methods
  • Disk and Directory Control Quick Reference
  • File Control Quick Reference
  • File Input and Output Quick Reference
  • Code Setup and Control Quick Reference
  • Code Control Statements Quick Reference
  • Variable Manipulation Quick Reference
  • Strings Quick Reference
  • Arrays Quick Reference
  • Math Operations Quick Reference
  • Date and Time Quick Reference
  • ODBC Quick Reference
  • Object Querying Quick Reference
  • Financials Quick Reference
  • Conversions Quick Reference
  • COM Object Quick Reference
  • Error Handling Quick Reference