Microsoft Dexterity Help 11.0

• Dexterity Help
• What’s new in Dexterity 11.0?
  • Dexterity
  • SanScript
  • Function Libraries
• Building Applications
  • Overview
    • The Dexterity System
      • What is a Dexterity application?
      • The application dictionary
      • Dexterity
      • The runtime engine
      • The DEX.DIC dictionary
      • Dexterity Utilities
    • Tools and Features
      • Tools
      • Features
      • Integration capability
    • Application Development
      • Application types
      • Basic development process
      • Interface design
      • Database development
      • Report generation
      • Scripting
  • Basics
    • Getting Started with Dexterity
      • Components
      • Launching Dexterity
    • The Dexterity Interface
      • The main menu
      • The toolbar
      • The menu bar
      • Windows
      • Standard buttons
  • Building an Application
    • Data Types
      • Data type elements
      • Static values
      • Control types
        • Boolean
        • Button drop list
        • Check Box
        • Combo Box
        • Composite
        • Currency
        • Currency (variable)
        • Date
        • Drop-down list
        • Horizontal list box
        • Integer
        • List box
        • List view
        • Long integer
        • Multi-select list box
        • Non-native list box
        • Picture
        • Progress indicator
        • Push button
        • Radio button
        • Radio group
        • Reference
        • String
        • Text
        • Time
        • Tiny integer
        • Tree view
        • Visual switch
      • Using data types
      • Procedure: Creating data types
    • Formats
      • Format elements
      • Format string
      • The Multiple Format Selector
      • Procedure: Creating formats
    • Global Fields
      • Field elements
      • Using global fields
      • Array fields
      • Procedure: Creating global fields
    • Tables
      • Table concepts
      • Table elements
      • Table fields
      • Keys
      • Key options
      • Segment options
      • SQL Auto Procedure Disable Options
      • Table options
      • Temporary tables
      • Table locations
      • Table groups
      • Procedure: Creating tables
    • Forms
      • Form overview
      • Form elements
      • Procedure: Creating forms
    • Windows
      • Window elements
      • Creating a window layout
      • The Toolbox
      • The layout area
      • The layout grid
      • Adding fields to a window layout
      • The Properties window
      • Window properties
      • Field properties
      • Drawn object properties
      • Previewing a window
      • Tab sequence
      • Adding pictures
      • Linking fields to prompts
      • Positioning the window
      • Resizing windows
      • Setting required fields
      • System color support - automatic
      • System color support - customizable
      • Custom color support
      • Procedure: Creating windows
    • Using Test Mode
      • Starting and stopping test mode
      • Test mode tools
      • Script lookup in test mode
      • Limitations
  • Navigation
    • Main Menu
      • The main window
      • The menu bar
    • Form-based Menus
      • Menu types
      • Menu elements
      • Cascading menus
      • Default menu set
      • Using menus
      • Application-level menus and sanScript
      • Displaying form-level menus
      • Procedure: Creating form-based menus
    • Commands
      • Command elements
      • Using commands
      • Controlling command access
      • Built-in commands
      • Procedure: Creating a command
    • Command-based Menus
      • Implementing command-based menus
      • Sample menu script
      • Automatic menu clean-up
    • Context Menus
      • Using context menus
      • Displaying a context menu
      • Context menus and macros
    • Toolbars
      • Implementing toolbars
      • Sample toolbar script
      • Re-creating toolbar arrangement
      • Automatic toolbar clean-up
  • Additional Resources
    • Messages
      • Messages overview
      • Messages examples
      • Using product names
      • Procedure: Creating messages
    • Pictures and Native Pictures
      • Pictures
      • Procedure: Adding a picture to the picture library
      • Procedure: Using a picture from the picture library
      • Native pictures
      • Procedure: Creating native pictures
      • Procedure: Synchronizing native pictures
    • Constants
      • Global constants
      • Procedure: Creating global constants
      • Form-level constants
      • Procedure: Creating form-level constants
      • Predefined constants
      • Constant examples
    • Global Variables
      • Gobal variables overview
      • Global variables example
      • Procedure: Creating global variables
    • Strings
      • Strings overview
      • Procedure: Modifying a string
    • Libraries
      • Library types
      • Procedure: Adding a library reference
      • Creating a resource library
    • Icons
      • Icon elements
      • Procedure: Creating an icon resource
    • Table Groups
      • Using table groups
      • Procedure: Defining a table group
    • Virtual Tables
      • Virtual table concepts
      • Virtual table elements
      • Member table relationships
      • Virtual tables and SQL views
      • Using virtual tables
      • Procedure: Creating a virtual table
  • Working with Dictionaries
    • Resource Explorer
      • Resource Explorer window
      • Resource Explorer toolbar
      • Explorer menu
    • Worksets
      • Creating worksets
      • Adding resources to a workset
      • Viewing worksets
      • Removing resources from a workset
      • Deleting worksets
    • Search and Replace
      • Resource Find window
      • Procedure: Using Find
      • Procedure: Using Replace
    • Importing and Exporting
      • Textual representation of resources
      • Importing
      • Exporting
  • Reports
    • Report Writer Overview
      • Reports and the Report Writer
      • Report types
      • The Dexterity Report Writer and the Runtime Report Writer
      • Planning a report
    • Table relationships
      • Table relationship overview
      • Types of table relationships
      • Defining a table relationship
    • Report Definition
      • Report elements
      • Report options
      • Printing a report definition
    • Report Layout
      • Creating a report layout
      • Layout sections
      • The Toolbox
      • Adding fields to a report layout
      • The Properties window
      • Report properties
      • Field properties
      • Drawn object properties
      • Report field characteristics
      • Applying drawing options
      • Viewing your report
    • Sorting
      • Using a main table key
      • Creating a sorting definition
    • Restrictions
      • Defining report restrictions
      • Restriction functions
    • Calculated Fields
      • Creating a calculated field
      • Operators
      • Fields tab
      • Constants tab
      • Functions tab
      • System-defined functions
      • User-defined functions
      • Evaluation order
    • Additional Headers and Footers
      • Overview of headers and footers
      • The order of the headers and footers
      • Creating additional headers or footers
      • Group overview
      • Sorting for groups
      • Group headers
      • Group footers
      • Counting items in a group
      • Counting groups
      • Totaling and subtotaling
    • Legends
      • Creating legends
      • Legends example
    • Modifying Fields
      • Field visibility
      • Field formatting
      • Changing display types
      • Display type summary
    • Using Reports in Applications
      • Running reports
      • Exporting data to a file
      • Using temporary tables
      • Mail connectivity
  • SQL Database Manager
    • Data Sources
      • Installing Microsoft SQL Server
      • Overview of data sources
      • Configuring ODBC data sources
    • Logins and Connections
      • Logins
      • Connections
    • Cursors
      • Cursor overview
      • Cursor block size
      • Stale data
      • Cursor refreshing
    • Locking
      • Table definition requirements
      • Session management
      • The DEX_LOCK table
      • Creating the DEX_LOCK and DEX_SESSION tables
      • Clearing stranded active locks
    • SQL Tables
      • Creating SQL tables
      • Auto-generated stored procedures
      • Granting access to tables
      • Paths for SQL tables
      • SQL error handling
      • Encrypted fields for SQL Server
      • Accessing existing SQL data
    • Stored Procedures
      • Using stored procedures
      • Creating a prototype procedure
      • Stored procedure parameters
      • Pathname support for stored procedures
      • Stored procedure time limits
    • Pass-through SQL
      • Pass-through SQL connections
      • Executing SQL statements
      • Working with results sets
      • Specifying a database
  • Source Code Control
    • Introduction to Source Code Control
      • Benefits of Source Code Control
      • Source code control terms
      • Configurations
      • Providers
    • Setting up Source Code Control
      • Connectivity
      • Installing components
      • Configuring the repository
      • Configuring the Source Code Control Server
      • Configuring Dexterity
    • Source Files
      • Source file contents
      • Source file structure
      • Source file names
    • Using Source Code Control
      • Checking in a new dictionary
      • Examining the repository
      • Checking out source files
      • Making changes to resources
      • Creating new resources
      • Checking in source files
      • Locking and unlocking source files
      • Fetching source files
      • Updating a dictionary
      • Creating and updating the index file
      • Building a dictionary
      • Viewing version information
      • Source code control errors
    • Maintaining the Repository
      • Deleting resources from a dictionary
      • Renaming resources
      • Labels
      • Updating source file states
    • Source Code Control for Integrating Applications
      • Configuring Dexterity
      • Developing an application
      • Checking in a development dictionary
      • Moving to new versions of Microsoft Dynamics GP
    • Generic Provider
      • Specifying the project location
      • Creating a project
      • Checking in a new dictionary
      • Checking out source files
      • Checking in source files
  • Using the Runtime Engine
    • Setting Product Information
      • Product information
      • Procedure: Setting product information
    • Using Launch Files
      • Creating a launch file
      • Contents of a launch file
      • Using the launch file to start your application
  • Packaging Applications
    • Making Installation Files
      • Installation scripts
      • Building chunk dictionaries
      • Creating an empty launch file
      • Testing the installation process
      • Additional components
      • Runtime command line parameters
    • Updating an Application
      • Changing table definitions
      • Converting c-tree and Pervasive.SQL tables
      • Converting SQL tables
      • How to package an update
      • Creating an update dictionary chunk
      • Updating forms and reports dictionaries
      • Updating forms dictionaries
      • Updating reports dictionaries
  • Utilities
    • Synchronize Utility
    • Duplicate utility
      • Procedure: Duplicating resources
      • Additional resources duplicated
    • Integration Reports
      • Procedure: Creating integration reports
      • Creating a submission file
• Scripting
  • sanScript
    • Syntax
      • General syntax
      • Names
      • Statements
      • Functions
      • Data types in sanScript
      • Variables
      • Constants
      • Expressions
      • Operators
      • Order of precedence
      • Casting
      • Arrays
    • The Script Editor
      • Using the Script Editor
      • Script Editor controls
      • Syntax coloring
      • The Names window
      • Script menu
      • Script drill-down
      • Compiling scripts
      • Online help support
      • Naming scripts
    • Attaching Scripts
      • Field scripts
      • Window scripts
      • Form scripts
      • Other scripts
  • Basic Scripting
    • Writing scripts
      • Scripting overview
      • Interaction-based programming
      • Procedure: Creating scripts
    • Communicating With the User
      • Dialogs
      • Controlling forms and windows
      • Controlling fields
      • Controlling the focus
    • Performing Calculations
      • Basic calculations
      • Overflow in numeric expressions
      • Calculations with variable currency values
      • Bit operations
      • Hexadecimal values
      • String calculations
    • Program Structures
      • Decision structures
      • Loop structures
  • Working with Controls
    • Standard Controls
      • Button drop lists
      • Check boxes
      • Drop-down lists and combo boxes
      • Push buttons
      • Radio buttons
      • String fields
      • Text fields
      • Controls on toolbars
      • Tooltips
    • Composites
      • Procedure: Creating standard composites
      • Procedure: Creating extended composites
      • Accessing composites from within scripts
      • Component-based scripts
      • Comparing composites
    • Scrolling Windows
      • Scrolling window types
      • Scrolling window elements
      • Scrolling window properties
      • Designing scrolling windows
      • Adding scripts to a scrolling window
      • Controlling the focus
      • Using lookups
      • Single-line scrolling windows
      • Procedure: Creating a scrolling window
    • Lookups
      • How lookups work
      • Implementing lookups
    • Tree View
      • Terminology
      • Tree view nodes
      • Tree view properties
      • Tree view scripts
      • Adding nodes to tree view fields
      • Image types for tree view nodes
      • Adding images to a tree view field
      • Image sizes
      • Specifying the images to use
      • Background colors
      • Searching tree view fields
    • List View
      • Terminology
      • List view items
      • List view properties
      • List view scripts
      • Image types for list views
      • Adding images to a list view field
      • Image sizes
      • Specifying the images to use
      • Background colors
      • Working with list views
      • Working with the selection
      • Searching a list view
  • Working with Tables
    • Table Overview
      • Common table operations
      • Data in windows
      • Table buffers
    • Working with Records
      • Example 1 - One window and one table
      • Example 2 - Two windows and two tables
      • Multiple records with the same key value
      • Modifying the values of key fields
    • Ranges
      • Range overview
      • Ranges for multisegment keys
      • Range types
      • Well-behaved ranges
    • Memory-based tables
      • Creating memory-based tables
      • Pathnames for memory-based tables
      • Using memory-based tables
    • Multiuser processing
      • Record locking
      • Releasing locks
      • Coding a multiuser application
      • Multiuser examples
    • Transactions
      • Transaction overview
      • Error handling for transactions
      • Transaction template
      • Guidelines for transactions
      • Integrating applications
  • Advanced Scripting
    • Procedures
      • Terminology
      • Creating and calling procedures
      • Parameters
      • Using parameters
      • Optional parameters
      • Passing parameters to other procedures
      • Using global fields as parameter types
      • Table buffers
      • Form procedures
      • Anonymous tables and fields
      • Background and remote processing
      • Process groups
    • User-defined Functions
      • Creating user-defined functions
      • Using user-defined functions
      • Form functions
      • Naming functions
    • Dynamic Link Libraries
      • Dexterity and DLLs
      • Using a DLL with Dexterity
      • Setting up the procedure for the DLL
      • Calling the DLL
      • Paths for accessing DLLs
    • Controlling the Compiler
      • Script preprocessor
      • Script preprocessor examples
      • Pragmas
      • Pragma reference
    • Call Stacks
      • Call stack usage
      • Managing call stacks
    • References
      • Creating references
      • Assigning references
      • Using references
      • Guidelines
      • Reference examples
    • Structured Exception Handler
      • Overview
      • User exceptions
      • System exceptions
      • Implementing an exception handler
      • Exception handler examples
  • Analysis Tools
    • Script Debugger
      • The Debug menu
      • The Script Debugger window
      • Breakpoints
      • Using the debugger
      • Examining the state of the application
      • Editing scripts
      • Debugging runtime errors
    • Script Profiler
      • Using the Script Profiler
      • Understanding the script profile
    • Script Logger
      • Logging scripts
      • Understanding the script log
      • Using the Script Logger
    • Resource Usage
      • Building the reference information table
      • Viewing reference information
      • Updating the reference information table
  • Software Engineering
    • The Development Process
      • Application development
      • Dexterity application development
      • Managing development
    • Design Guidelines
      • Resources
      • Scripting
      • Features
    • Optimizing Your Application
      • Procedures and functions
      • Forms and windows
      • Tables
      • Reports
      • Scrolling windows
      • Scripts
    • Testing Your Application
      • Characteristics of a good application
      • The SQA process
      • Testing Dexterity applications
      • Phases of testing
      • The macro system
      • The Macro menu
      • Additional macro menu items
      • Using macros for testing
      • Structure and syntax of a macro
      • The macro language
    • Creating an International Product
      • Locales
      • Designing for eventual translation
      • Window design
      • Report design
      • Coding issues
  • COM
    • Introduction to COM
      • Automation
      • Classes and objects
      • Events
    • COM Libraries
      • Type libraries
      • Referencing type libraries
    • Referencing COM Objects
      • COM references
      • Generic references
      • Creating COM references
    • COM in sanScript
      • Objects
      • Properties and methods
      • Constants
      • Data type conversion
      • Class Browser
      • Collections
      • COM exceptions
      • Debugging COM integrations
      • Assemblies created with the .NET Framework
    • Callbacks and Events
      • Callback objects
      • Accessing callback objects
      • Events
      • Creating an event handler
  • Using COM
    • Microsoft Word
      • Microsoft Word Object Library overview
      • Declared variables
      • Application object
      • Document object
      • Range object
      • Paragraph object
      • Table object
      • Cell object
      • Script example
    • Microsoft Excel
      • Microsoft Excel Object Library overview
      • Declared variables
      • Application object
      • Workbook object
      • Worksheet object
      • Range object
      • WorksheetFunction object
      • Chart object
      • Script example
    • Microsoft ADOX
      • Microsoft ADOX Object Library overview
      • Declared variables
      • Catalog object
      • Table object
      • Key object
      • Column object
      • Script example
    • Microsoft ADO
      • Microsoft ADO Object Library overview
      • Declared variables
      • Connection object
      • Recordset object
      • Field object
      • Script example
    • Microsoft Internet Explorer
      • Microsoft Internet Controls Object Library overview
      • Declared variables
      • InternetExplorer object
      • Script example
    • Microsoft Outlook
      • Microsoft Outlook Object Library overview
      • Declared variables
      • Outlook security
      • Application object
      • NameSpace object
      • MAPIFolder object
      • MailItem object
      • Attachment object
      • Recipient object
      • ContactItem object
      • Script example
    • Microsoft XML
      • Microsoft XML Object Library overview
      • Declared variables
      • DOMDocument object
      • IXMLDOMNode object
      • IXMLDOMNodeList object
      • IXMLDOMProcessingInstruction object
      • IXMLDOMElement object
      • IXMLDOMText object
      • Script example
• sanScript Commands
  • sanScript Command Listing
    • abort close
    • abort script
    • abs()
    • add item
    • addmonth()
    • anonymous()
    • arraysize()
    • ascii()
    • ask()
    • assert
    • assign
    • assign as key
    • beep
    • begingroup
    • bitclear()
    • bitset()
    • bittest()
    • call
    • call sproc
    • call with name
    • case...end case
    • change
    • change item
    • changed()
    • char()
    • check command
    • check error
    • check field
    • check menu
    • checkedfield()
    • checkedmenu()
    • clear changes
    • clear field
    • clear force change
    • clear form
    • clear table
    • clear window
    • close application
    • close form
    • close palettes
    • close table
    • close window
    • close windows
    • column()
    • continue
    • copy from field to field
    • copy from table
    • copy from table to table
    • copy from table to window
    • copy from window to table
    • copy from window to window
    • copy to table
    • countitems()
    • countrecords()
    • currencydecimals()
    • currentcomponent()
    • datatype()
    • day()
    • debug
    • debugger stop
    • decrement
    • default form to
    • default roundmode to
    • default window to
    • delete item
    • delete line
    • delete table
    • diff()
    • disable command
    • disable field
    • disable item
    • disable menu
    • dow()
    • edit table
    • editexisting()
    • empty()
    • enable command
    • enable field
    • enable item
    • enable menu
    • endgroup
    • eom()
    • err()
    • error
    • execute()
    • exit
    • expand window
    • extern
    • fill
    • fill table
    • fill window
    • filled()
    • finddata()
    • finditem()
    • focus
    • for do...end for
    • force change
    • force changes
    • format()
    • get
    • getfile()
    • getmsg()
    • getstring()
    • havetransactions()
    • hex()
    • hide command
    • hide field
    • hide menu
    • hide window
    • hour()
    • if then...end if
    • import
    • increment
    • insert item
    • insert line
    • isalpha()
    • isopen()
    • itemdata()
    • itemname()
    • keynumber()
    • length()
    • lock
    • lower()
    • max()
    • min()
    • minute()
    • missing()
    • mkdate()
    • mktime()
    • month()
    • move field
    • move window
    • naterr()
    • new
    • old()
    • open form
    • open form with name
    • open table
    • open window
    • override component
    • override field
    • pad()
    • physicalname()
    • pos()
    • precision()
    • range
    • range copy
    • range where
    • redraw
    • reject record
    • reject script
    • release table
    • remove
    • repeat...until
    • replace()
    • required()
    • resize field
    • resize window
    • resourceid()
    • restart field
    • restart form
    • restart script
    • restart try
    • restart window
    • return
    • round()
    • run application
    • run command
    • run macro
    • run report
    • run report with name
    • run script
    • run script delayed
    • save table
    • savefile()
    • scale()
    • second()
    • set
    • set precision of
    • set title of window to
    • setdate()
    • show command
    • show field
    • show menu
    • show window
    • str()
    • substitute
    • substring()
    • sum range
    • sysdate()
    • sysdatetime()
    • system
    • systime()
    • technicalname()
    • this
    • throw
    • throw system exception for table
    • transaction begin
    • transaction commit
    • transaction rollback
    • trim()
    • truncate()
    • try...end try
    • uncheck command
    • uncheck field
    • uncheck menu
    • unlock
    • upper()
    • value()
    • warning
    • while do...end while
    • year()
• Function Libraries
  • Function Library Listing
  • Activity tracking function library
    • Activity_GetBackgroundStatus()
    • Activity_GetExitMode()
    • Activity_GetResourceName()
  • Auto-complete function library
    • AutoComplete_AddStringValue()
    • AutoComplete_RemoveAllData()
    • AutoComplete_RemoveFieldData()
    • AutoComplete_RemoveStringValue()
    • AutoComplete_SetMode()
    • AutoComplete_SetOptions()
  • Color function library
    • Color_ConvertNameToValue()
    • Color_ConvertRGBToValue()
    • Color_ConvertValueToName()
    • Color_ConvertValueToRGB()
    • Color_GetFromDialog()
    • Color_ResetSystemColor()
    • Color_SetSystemColor()
  • COM function library
    • COM_AttachEventHandler()
    • COM_CreateObject()
    • COM_DetachEventHandler()
    • COM_GetObject()
    • COM_RegisterRunningObject()
    • COM_RevokeRunningObject()
  • Command function library
    • Command_Execute()
    • Command_GetAccelerator()
    • Command_GetBooleanProperty()
    • Command_GetIDs
    • Command_GetImageProperty()
    • Command_GetNamedProperty()
    • Command_GetStringProperty()
    • Command_GetTag()
    • Command_GetType()
    • Command_Reset()
    • Command_SetAccelerator()
    • Command_SetBooleanProperty()
    • Command_SetImageProperty()
    • Command_SetNamedProperty()
    • Command_SetStringProperty()
  • Command bar function library
    • CommandBar_Create()
    • CommandBar_Destroy()
    • CommandBar_GetPosition()
  • Command list function library
    • CommandList_Add()
    • CommandList_FindCommand()
    • CommandList_GetCommandByPosition()
    • CommandList_NumCommands()
    • CommandList_Remove()
    • CommandList_RemoveAll()
    • CommandList_RemoveCommandByPosition()
  • Currency function library
    • Currency_GetDecimalSymbol()
    • Currency_GetLeadingSymbol()
    • Currency_GetLeadingZero()
    • Currency_GetNativeSymbol()
    • Currency_GetNegativeAfterValue()
    • Currency_GetNegativeBeforeSymbol()
    • Currency_GetNegativeParens()
    • Currency_GetNegativeSymbol()
    • Currency_GetNumberOfDecimals()
    • Currency_GetSymbol()
    • Currency_GetThousandsSymbol()
    • Currency_SetDecimalSymbol()
    • Currency_SetLeadingSymbol()
    • Currency_SetLeadingZero()
    • Currency_SetNegativeAfterValue()
    • Currency_SetNegativeBeforeSymbol()
    • Currency_SetNegativeParens()
    • Currency_SetNegativeSymbol()
    • Currency_SetNumberOfDecimals()
    • Currency_SetSymbol()
    • Currency_SetThousandsSymbol()
  • Defaults file function library
    • Defaults_Read()
    • Defaults_ReadColor()
    • Defaults_Write()
  • Dexterity object function library
    • DexObject_AddMethod()
    • DexObject_AddProperty()
    • DexObject_Create()
  • Dictionary function library
    • Dict_CountCustomResource()
    • Dict_GetCustomResourceInfo()
    • Dict_GetName()
    • Dict_GetPathname()
    • Dict_LockCustom()
    • Dict_UnlockCustom()
    • Dict_UpdateFormsDictionary()
    • Dict_UpdateReportsDictionary()
  • Exception function library
    • Exception_Class()
    • Exception_ClassName()
    • Exception_Message()
    • Exception_Product()
    • Exception_ProductName()
    • Exception_SubClass()
    • Exception_SubClassName()
  • Field function library
    • Field_BDLCreateSubmenu()
    • Field_BDLAddToSubmenu()
    • Field_GetBooleanProperty()
    • Field_GetCaption()
    • Field_GetColor()
    • Field_GetFont()
    • Field_GetImage()
    • Field_GetInsertPosFromVisualPos()
    • Field_GetIntegerProperty()
    • Field_GetPosition()
    • Field_GetRequiredStatus()
    • Field_GetSelection()
    • Field_GetSize()
    • Field_GetStringProperty()
    • Field_GetVisualPosFromInsertPos()
    • Field_GetToolTip()
    • Field_InsertStringInText()
    • Field_MarkListItems()
    • Field_ParseText()
    • Field_SetAltLineColor()
    • Field_SetBackColor()
    • Field_SetBooleanProperty()
    • Field_SetCaption()
    • Field_SetCustomPromptFormat()
    • Field_SetFont()
    • Field_SetFontColor()
    • Field_SetFontSize()
    • Field_SetFontStyle()
    • Field_SetImage()
    • Field_SetIntegerProperty()
    • Field_SetPattern()
    • Field_SetPatternColor()
    • Field_SetRequiredFormat()
    • Field_SetRequiredStatus()
    • Field_SetSelection()
    • Field_SetStringProperty()
    • Field_SetToolTip()
    • Field_SetZoomFormat()
  • File function library
    • File_Count()
    • File_Delete()
    • File_GetSize()
    • File_GetTempDirectory()
    • File_Probe()
  • File list function library
    • FileList_Add()
    • FileList_Count()
    • FileList_Create()
    • FileList_Destroy()
    • FileList_Get()
    • FileList_Remove()
    • FileList_ShowDialog()
  • File type function library
    • FileType_CanAppend()
    • FileType_FillList()
    • FileType_GetExtension()
    • FileType_IsValid()
  • Help pane function library
    • HelpPane_Create()
    • HelpPane_Destroy()
    • HelpPane_DisplayTopic()
    • HelpPane_GetWidth()
    • HelpPane_SetTitle()
    • HelpPane_SetWidth()
    • HelpPane_Show()
  • Import function library
    • Import_CloseFile()
    • Import_GetNextField()
    • Import_GetNextRecord()
    • Import_OpenFile()
  • IP function library
    • IP_GetIPName()
    • IP_GetIPNumber()
    • IP_PingDPS()
  • Launch file function library
    • Launch_CountProds()
    • Launch_FillListWithProds()
    • Launch_GetFileInfo()
    • Launch_GetFileName()
    • Launch_GetProdID()
    • Launch_GetProdName()
    • Launch_GetProdPosition()
    • Launch_ParseFileFromPath()
    • Launch_ReadDictPath()
    • Launch_SelectDict()
    • Launch_SelectFile()
    • Launch_WriteDictPath()
  • List view function library
    • ListView_ColumnAdd()
    • ListView_ColumnCount()
    • ListView_ColumnGetAlignment()
    • ListView_ColumnGetLabel()
    • ListView_ColumnGetPosition()
    • ListView_ColumnGetSubitem()
    • ListView_ColumnGetWidth()
    • ListView_ColumnRemove()
    • ListView_ColumnSetAlignment()
    • ListView_ColumnSetLabel()
    • ListView_ColumnSetPosition()
    • ListView_ColumnSetWidth()
    • ListView_GetClickItem()
    • ListView_GetSortColumn()
    • ListView_GetStringWidth()
    • ListView_GetView()
    • ListView_ItemAdd()
    • ListView_ItemCount()
    • ListView_ItemGetCurrencySubitem()
    • ListView_ItemGetData()
    • ListView_ItemGetDateSubitem()
    • ListView_ItemGetImage()
    • ListView_ItemGetIntSubitem()
    • ListView_ItemGetLabel()
    • ListView_ItemGetStateImage()
    • ListView_ItemGetSubitem()
    • ListView_ItemGetTimeSubitem()
    • ListView_ItemMakeVisible()
    • ListView_ItemRemove()
    • ListView_ItemSetCurrencySubitem()
    • ListView_ItemSetData()
    • ListView_ItemSetDateSubitem()
    • ListView_ItemSetImage()
    • ListView_ItemSetIntSubitem()
    • ListView_ItemSetLabel()
    • ListView_ItemSetStateImage()
    • ListView_ItemSetSubitem()
    • ListView_ItemSetTimeSubitem()
    • ListView_SelectionCount()
    • ListView_SelectionGet()
    • ListView_SelectionSet()
    • ListView_SetEmptyMessage()
    • ListView_SetSortColumn()
    • ListView_SetView()
    • ListView_Sort()
  • Login function library
    • Login_AlterLogin()
    • Login_CreateLogin()
    • Login_DropLogin()
    • Login_ExitDataSource()
    • Login_GetDataSources()
    • Login_GetDBMSInfo()
    • Login_GetInfo()
    • Login_GetLoginSettings()
    • Login_LogIntoDataSource()
    • Login_LogIntoDataSourceEx()
    • Login_OpenDexDialog()
    • Login_VerifyInfo()
  • MAPI function Library
    • MAPI_AddAddress()
    • MAPI_CountAddresses()
    • MAPI_CreateAddressList()
    • MAPI_DestroyAddressList()
    • MAPI_DisplayDialog()
    • MAPI_DisplayReplyToDialog()
    • MAPI_GetAddress()
    • MAPI_IsLoggedOn()
    • MAPI_IsMailEnabled()
    • MAPI_LogOff()
    • MAPI_LogOn()
    • MAPI_ProfileGetAddress()
    • MAPI_PropertyListCount()
    • MAPI_PropertyListCreate()
    • MAPI_PropertyListDestroy()
    • MAPI_PropertyListGetValue()
    • MAPI_PropertyListGetValueByIndex()
    • MAPI_PropertyListSetValue()
    • MAPI_RemoveAddress()
    • MAPI_ResolveAddress()
    • MAPI_Send()
    • MAPI_SendDialog()
  • Menu function library
    • Menu_Invoke()
  • Menu bar function library
    • MenuBar_AddMenu()
    • MenuBar_RemoveAllMenus()
    • MenuBar_RemoveMenu()
  • OLE function library
    • OLE_CloseNote()
    • OLE_DeleteNote()
    • OLE_Exit()
    • OLE_IsNoteEnabled()
    • OLE_OpenNote()
    • OLE_SaveNote()
  • Path function library
    • Path_ChangeDefault()
    • Path_CreateFolder()
    • Path_DoesExist()
    • Path_GetForApp()
    • Path_MakeGeneric()
    • Path_MakeNative()
    • Path_ParseFileFromPath()
    • Path_ParsePathFromPath()
    • Path_SelectPathname()
  • Printer function library
    • Printer_Define()
    • Printer_GetName()
    • Printer_SetDestination()
  • Registry function library
    • Registry_DeleteKey()
    • Registry_DeleteValue()
    • Registry_GetProtectedString()
    • Registry_GetValue()
    • Registry_SetKeyValue()
    • Registry_SetProtectedKeyString()
  • Report function library
    • Report_Begin()
    • Report_DoubleLine()
    • Report_End()
    • Report_GetPageRemaining()
    • Report_GetPageSize()
    • Report_GetStringWidth()
    • Report_NewBand()
    • Report_NewPage()
    • Report_ReadyToRun()
    • Report_SetFont()
    • Report_SingleLine()
    • Report_WriteText()
  • Resource function library
    • Resource_EndSeriesFill()
    • Resource_FillSeriesList()
    • Resource_GetDisplayName()
    • Resource_GetID()
    • Resource_GetInfo()
    • Resource_GetNthResource()
    • Resource_GetResourceName()
    • Resource_GetSubResourceName()
    • Resource_StartSeriesFill()
  • Runtime function library
    • Runtime_GetCPUType()
    • Runtime_GetCurrentProductID()
    • Runtime_GetModuleInfo()
    • Runtime_GetOSBuildInfo()
    • Runtime_GetOSInfo()
    • Runtime_GetVersionNum()
    • Runtime_SetAboutMenu()
    • Runtime_SetFieldEnterMode()
    • Runtime_SetIcon()
  • Script log function library
    • ScriptLog_Start()
    • ScriptLog_Stop()
  • Script profile function library
    • ScriptProfile_Clear()
    • ScriptProfile_Save()
    • ScriptProfile_Start()
    • ScriptProfile_Stop()
  • Shell function library
    • Shell_DisplayNotification()
  • SQL function library
    • SQL_Clear()
    • SQL_Connect()
    • SQL_DescribeColumn()
    • SQL_Execute()
    • SQL_FetchNext()
    • SQL_GetData()
    • SQL_GetError()
    • SQL_GetNextResults()
    • SQL_GetNumCols()
    • SQL_GetNumRows()
    • SQL_Terminate()
  • Table function library
    • Table_AutoShrink()
    • Table_Compare()
    • Table_CopyShrinkRecords()
    • Table_CreateIndexes()
    • Table_CreateProcedures()
    • Table_DisableErrorChecks()
    • Table_DropProcedures()
    • Table_EndConversion()
    • Table_EndShrink()
    • Table_FillGroupList()
    • Table_FillList()
    • Table_FlushCache()
    • Table_GetAutoShrinkMode()
    • Table_GetDisplayName()
    • Table_GetFieldList()
    • Table_GetGroup()
    • Table_GetKeyInfo()
    • Table_GetOSName()
    • Table_GetRangeKey()
    • Table_GetSeries()
    • Table_GetSQLErrorText()
    • Table_IsRangeSet()
    • Table_OpenAsTemp()
    • Table_RebuildIndexes()
    • Table_SetCreateMode()
    • Table_SetDBType()
    • Table_SetDeleteOptions()
    • Table_SetRefreshFlags()
    • Table_StartConversion()
    • Table_StartShrink()
    • Table_Truncate()
    • Table_VerifyRecord()
  • Text file function library
    • TextFile_Close()
    • TextFile_Open()
    • TextFile_ReadLine()
    • TextFile_ReadText()
    • TextFile_WriteDOS()
    • TextFile_WriteLine()
    • TextFile_WriteText()
  • Timer function library
    • Timer_Sleep()
  • Tools function library
    • Tools_CloseDUOSTable()
    • Tools_DisableLoadBalancing()
    • Tools_EnableCommandMenus()
    • Tools_EnableCustomizationMaintenance()
    • Tools_EnableCustomizationStatus()
    • Tools_EnableImport()
    • Tools_EnableLoadBalancing()
    • Tools_EnableModifier()
    • Tools_EnableReportWriter()
    • Tools_GetTranLevel()
    • Tools_IsAppProcessServer()
    • Tools_IsScriptRemote()
    • Tools_OpenDUOSTable()
    • Tools_UseShell
  • Tree view function library
    • TreeView_AddNode()
    • TreeView_CollapseNode()
    • TreeView_CountChildren()
    • TreeView_CountNodes()
    • TreeView_ExpandNode()
    • TreeView_GetClickNode()
    • TreeView_GetCollapsingNode()
    • TreeView_GetExpandingNode()
    • TreeView_GetFirstChild()
    • TreeView_GetNextNode()
    • TreeView_GetNodeData()
    • TreeView_GetNodeImage()
    • TreeView_GetNodeLabel()
    • TreeView_GetNodeStateImage()
    • TreeView_GetParent()
    • TreeView_GetPreviousNode()
    • TreeView_GetRootNode()
    • TreeView_GetSelectedNode()
    • TreeView_IsParentNode()
    • TreeView_MakeNodeVisible()
    • TreeView_RemoveChildren()
    • TreeView_RemoveNode()
    • TreeView_SetNodeData()
    • TreeView_SetNodeImage()
    • TreeView_SetNodeLabel()
    • TreeView_SetNodeStateImage()
    • TreeView_SetSelectedNode()
  • Trigger function library
    • Trigger_CausedByProduct()
    • Trigger_DisableSingle()
    • Trigger_Enable()
    • Trigger_EnableSingle()
    • Trigger_GetCurrentTag
    • Trigger_IsTriggerEnabled()
    • Trigger_RegisterDatabase()
    • Trigger_RegisterDatabaseByName()
    • Trigger_RegisterFocus()
    • Trigger_RegisterFocusByName()
    • Trigger_RegisterForm()
    • Trigger_RegisterFormByName()
    • Trigger_RegisterFunction()
    • Trigger_RegisterFunctionByName()
    • Trigger_RegisterProcedure()
    • Trigger_RegisterProcedureByName()
    • Trigger_Unregister()
  • Utility function library
    • Utility_DecodeString()
    • Utility_DecryptTableString()
    • Utility_EncodeString()
    • Utility_EncryptTableString()
    • Utility_LoadDLL()
    • Utility_SubstituteTokens()
    • Utility_UnloadDLL()
  • Window function library
    • Window_ForceRedraw()
    • Window_GetMainWindowTitle()
    • Window_GetPosition()
    • Window_GetSize()
    • Window_GetState()
    • Window_GetTitle()
    • Window_GetTitleByProduct()
    • Window_PullFocus()
    • Window_ScrollScrollingWindow()
    • Window_SetBaseSize()
    • Window_SetLineMode()
    • Window_SetState()
  • WinHelp function library
    • WinHelp_ALinkLookup()
    • WinHelp_GetCurWindow()
    • WinHelp_GetFieldContextNumber()
    • WinHelp_GetHelpType()
    • WinHelp_GetWindowContextNumber()
    • WinHelp_InvokeHelp()
    • WinHelp_RegisterHelpProcedure()
    • WinHelp_RunHelpMacro()
    • WinHelp_Search()
• Windows in Dexterity
  • About Dexterity window
  • Add To Workset window
  • Breakpoint Options window
  • Breakpoints window
  • Button Items window
  • Button Values window
  • Calculated Expression window
  • Calculated Field Definition window
  • Calls window
  • Check In to Repository window
  • Check Out from Repository window
  • Class Browser window
  • Color window
  • COM Type Libraries window
  • Command Definition window
  • Compile Message Detail window
  • Compile Messages window
  • Composite Definition window
  • Constant Definition window
  • Data Type Definition window
  • Define Worksets window
  • Drawing Options window
  • Duplicate window
  • Edit Source File Names
  • Export Dictionary window
  • Export to Text File window
  • Expressions window
  • Fetch from Repository window
  • Field Definition window
  • Field Lookup window
  • Find window (scripts)
  • Form Definition window
  • Format Definition window
  • Generate Help Files window
  • Header Options/Footer Options window
  • Icon Definition window
  • Image Lookup window
  • Import From Text File window
  • Inherited Menu Options window
  • Insert Macro Header window
  • Install Information window
  • Integration Reports window
  • Key Components window
  • Key Definition window
  • Layout window
  • Library Definition window
  • ListView Images window
  • Local Field Definition window
  • Locals window
  • Lock in Repository window
  • Macro Comment window
  • Macro Insert Pause window
  • Macro Open Form
  • Macro Status window
  • Menu Definition window
  • Messages window
  • Modified Resources window
  • Names window
  • Native Picture Definition window
  • New Workset window
  • Open Script window
  • Options window
  • Pattern window
  • Picture Definition window
  • Pictures window
  • Pictures (picture library) window
  • Position Window window
  • Print Report Definition window
  • Process Detail window
  • Process Monitor window
  • Product Information window
  • Projects window
  • Properties window
  • Reference Information window
  • Related Field Lookup window
  • Related Tables window
  • Relationship Definition window
  • Relationship Table Lookup window
  • Replace window
  • Report Definition window
  • Report Destination window
  • Report Field Options window
  • Report Restriction Definition window
  • Report Restrictions window
  • Report Section Options window
  • Report Table Relationships window
  • Resource Explorer window
  • Resource Find window
  • Resource Lookup window
  • Resources to Update window
  • Screen Output window
  • Script Debugger window
  • Script Editor window
  • Scrolling Window Layout window
  • Scrolling Window Options window
  • Sorting Definition window
  • Source Code Errors window
  • Startup window
  • Static Picture Values window
  • Static Text Values window
  • String Definition window
  • Table Buffers window
  • Table Definition window
  • Table Export window
  • Table Group Definition window
  • Table Lookup window
  • Table Options window
  • Table Relationship window
  • Table Relationship Definition window
  • Toolbar window
  • Toolbox window
  • TreeView Images window
  • Unlock in Repository window
  • Update from Repository window
  • Version Details window
  • Versions window
  • Virtual Table Definition window
  • Visualizer window
  • Watch window
• Alert Messages
  • Runtime Messages
  • Compiler Messages
  • Dexterity Messages
• Form Factories
  • Creating the Visual Studio project
  • Coding the form factory class
  • Creating the new form
  • Installing and registering the form factory
  • Debugging a form factory
• Defaults File
  • Using a custom defaults file
  • Editing the defaults file
  • Defaults file settings
    • ApplicationName
    • AutoInstallChunks
    • Btrieve
    • BtrieveFileNameExtension
    • BTShrink
    • CTShrink
    • DatabaseType
    • DebugQueue
    • DisableBackgroundLoopCounter
    • DisplayTableErrors
    • DPSInstance
    • DPSSystemIndex
    • ExportOneLineBody
    • FHCheckRanges
    • Font
    • International
    • MailDefaultProfileName
    • MailEmptyBodyMessage
    • NativeFontLeading
    • NoPathnames
    • NoPrintDialogs
    • Owner
    • QueueMoreInfo
    • RuntimeAsserts
    • ScriptCacheEntries
    • ScriptDebugger
    • ShowAdvancedMacroMenu
    • ShowReportName
    • ShowResids
    • SQLCursorBlockSize
    • SQLDataSource
    • SQLDeadLockRetries
    • SQLDisableSPForDeletes
    • SQLDisableSPForInserts
    • SQLDisableSPForSelects
    • SQLDropTableOnDelete
    • SQLDynamicScrollJump
    • SQLLastDataSource
    • SQLLastUser
    • SQLLoginTimeout
    • SQLLogODBCMessages
    • SQLLogPath
    • SQLLogSQLStmt
    • SQLMaxBufferRows
    • SQLMaxConnections
    • SQLMaxInactiveConnections
    • SQLNumInitialConnections
    • SQLNumLoginTries
    • SQLPassword
    • SQLProcsTimeout
    • SQLQueryTimeout
    • SQLRprtsTimeout
    • SQLUser
    • StdInternationalInfo
    • StdInternationalInfoDateCentury
    • StdInternationalInfoDateZeroPrefix
    • Synchronize
    • Tolerance
    • UseUniqueHelp
    • WindowGridHeight
    • WindowGridWidth
    • Workstation2
• Macro System
  • The macro language
  • ActivateWindow
  • CheckActiveWin
  • CheckFocusSpring
  • ClearAllVars
  • ClearVar
  • ClickCancel
  • ClickHit
  • ClickHitMS
  • CloseWindow
  • ColSortAsc
  • ColSortDes
  • CommandExec
  • ContextMenu
  • ContNatTypeTo
  • ContTypeTo
  • DblClickHit
  • DCommandBarAll
  • DContextMenu
  • DField
  • DIELinksAll
  • DMenu
  • DMenuAll
  • DumpField
  • DumpFieldBegin...DumpFieldEnd
  • DumpShell
  • DWin
  • FileOpen
  • FilePath
  • FileSave
  • FileSaveAs
  • IfDefined...EndIf
  • IfNotDefined...EndIf
  • ItemCollapse
  • ItemExpand
  • Logging
  • MacroError
  • MenuSelect
  • MoveTo
  • NatTypeTo
  • NewActiveWin
  • OpenForm
  • Pause
  • PrintDialog
  • ScrollByLine
  • ScrollByPage
  • ScrollToEnd
  • SelChanged
  • SelectAccel
  • SelectChars
  • SetEbDateTo
  • SetEbTimeTo
  • SetExitAction
  • SetVar
  • ShellCommand
  • StateClick
  • TableDump
  • TNT_Event
  • TransLinePrepare
  • TypeTo
  • WindowMove
  • WindowSize
• Dexterity Limits
• Reserved Words
• ASCII Character Codes
• Glossary
• Copyright notice
• Privacy Statement