Contents | Search


  • USoft 9.1 All Help Topics
  • USoft Approach Guide
    • Introducing the USoft Approach
      • Advantages of the USoft Approach
      • Principles of the USoft Approach
        • Deliver business conduct
        • Deliver in short cycles
        • Deliver specifications and implementations in parallel
        • Deliver a central repository with distinct application tiers
      • Phases and subphases in the USoft Approach
      • Infrastructure
      • Balancing work between phases
    • The PLAN Phase
      • The Business Orientation subphase
      • The Rapid Analysis subphase
      • The Project Definition subphase
      • Roles
    • The DEFINE Phase
      • The Structure Definition subphase
      • The Rule Definition subphase
      • The Interface Definition subphase
      • The SPECIFY task type
      • The IMPLEMENT task type
      • The TEST task type
      • Definition of Done
    • The DELIVER Phase
      • The Release subphase
      • The Acceptance subphase
      • The Maintenance subphase
  • USoft Authorizer Guide
    • Introducing USoft Authorizer
      • Authorization and authentication
      • Setting up authorization for developers
      • Setting up authorization for runtime users of your application
      • USoft Authorizer as a module
      • USoft Authorizer as a runtime application
      • Deploying authorization rules
    • Authorization concepts
    • Applications
    • Application users
    • User groups
      • How to assign users to user groups
      • How to assign menus to user groups
      • Definer User Groups
      • Menu conditions
        • How to define Menu Conditions
    • Authorization tables
      • Authorisation for supertypes and subtypes
    • Table rights
    • Column rights
    • Scope
    • Restricting conditions
      • How to check conditions
    • Deployment configurations
      • Deployment configuration contexts
      • Deployment Parameters
        • General deployment parameters
          • Record Facts Cache
          • Cache Size
          • Max Prepared Checks
        • Additional deployment parameters
          • Allow_Disable_Constraint
          • Allow_Set_Manipulations
          • Auto_Refresh_Constraints
          • Batch_Loglevel
          • Defer_Restr_Rel_Checks
          • Lock_Foreign_Keys
          • Lock_Parent_On_Seqno
          • Max_Constraint_Depth
          • Max_Driver_Conditions
          • Number_of_Update_Columns
          • Optimize_Changed_Table
          • Rdbms_Connect
          • Read_Only_ODBC
          • Request_Log_Size
          • Show_Component_Errors
          • Show_Rdbms_Errors
          • SQLServer_Option_Fast_1
          • Temp_Table_At_Owner
          • Unique_Key_Check
          • Update_Supertype_On_Ins
          • Wait_for_Lock
      • How to set a Deployment Parameter
    • Database grants
      • Options for granting or revoking database grants
      • How to grant and update access rights
      • How to revoke database grants
    • Authentication and USoft
      • User account mapping
      • How to change the Rules Engine cache refresh frequency
      • Authorising users to change their password
      • Using RulesEngine.SetUser()
      • Example: Client/server login dialog
      • MS SQL Server authentication
    • Deploying a Web Service Provider
      • Importing a Web Service
      • Creating UDDI Businesses, UDDI Registry, and Publish Accounts
        • How to create an UDDI Registry
        • How to create a new publish account
        • How to create or remove a UDDI Business
      • How to publish a UDDI Business
      • Associating a Web Service Provider with a UDDI Business
      • Publishing a Web Service
      • Importing a UDDI Business from the UDDI registry
      • Using an encrypted password
      • Generated files
      • Miscellaneous Web Service remarks
        • Calling a Web Service with SSL
        • How to create a certificate file to be imported in USoft Authorizer
          • How to import a certificate in USoft Authorizer
          • How to delete a certificate from USoft Authorizer
    • Server certificates
      • TLS/SSL
      • How server certificates work
        • A server certificate is domain/website-specific
        • Help with certificates
      • How to configure a web server for SSL
        • Use the web server to generate a CSR
        • Error-free CSR generation: Important Information
        • Example: Generating a key pair and CSR
        • Use the CSR to obtain a server certificate via a certificate issuer
        • Configure the web server to use the obtained certificate
      • Self-signed certificates and OpenSSL
        • Step 1: Download and install OpenSSL
        • Step 2: Create a private key
        • Step 3: Create a master certificate based on private key
        • Step 4: Create public key and certificate signing request
        • Step 5: Self-sign the certificate
        • Using self-signed certificates with USoft
        • Activation of TLS/SSL in the Remote Rules Service
        • Activation of TLS/SSL in the Rules Service
        • Activation of TLS/SSL in the JDBC Driver
  • USoft Binder Guide
    • Introducing USoft Binder
    • Projects
    • Project Properties
      • Project Tab
      • Database Tab
      • Content Tab
    • Project Items
      • Definer Properties
      • Delivery Manager Properties
      • Service Definer Properties
      • Upgrade Tool Properties
      • Web Designer Properties
      • Windows Designer Properties
      • Application Timer Properties
      • Authorizer Properties
      • Batch Runner Properties
      • BenchMark Properties
      • Free Object Properties 
      • Rules Service Properties
      • User Application Properties
    • Create Tables Dialog
    • Startup options for the USoft Developer platform
    • Startup options for batch runs
    • USoft Binder variables
    • Defining a Separate User Environment
  • USoft Definer Help
    • USoft Teamwork Guide
      • Introducing USoft Teamwork
        • USoft Studio
        • USoft Approach
      • USoft TeamWork Objects
        • Object Classification
        • TeamWork Catalog
        • Business Rules
          • Why Use Business Rules?
          • Guidelines for Writing Business Rules
            • Easy-to-understand Business Rules
            • Affirmative and Definite Business Rules
            • Functional Business Rules
            • Stand-alone Business Rules
          • Adding Information to Business Rules
            • Short Description attribute of Business Rules
            • Type attribute for Business Rules
            • Requires Implementation Y/N attribute for Business Rules
            • Priority attribute for Business Rules
          • Grouping Business Rules
            • Grouping Rules by Business Process Step
            • Grouping Rules by Business Area or Business Object
            • Grouping Rules by Rule Set
            • Grouping Rules by Motivation
            • Grouping Rules by Classification
            • Grouping Rules by Source
            • Classify Rules as belonging to other Rules
          • Splitting Business Rules
          • Implementing Business Rules
          • Reporting and Fixing Problems with Business Rules
          • Tracing a Business Rule's Life-Cycle
            • Repository Version attribute for Business Rules
            • Status attributes for Business Rules
            • Status History for Business Rules
          • Viewing Business Rules as Business Process Steps
        • Business Process Steps
          • Understanding Business Process Modeling in USoft TeamWork
          • Planning the Best Approach to Business Process Modeling
            • Approach 1: Work Procedure Handbook
            • Approach 2: Integrated Processes-and-Rules Base
            • Approach 3: User Function Coverage
            • Using an External Business Process Modeling (BPM) Tool
          • Branching Structures in Business Processes
          • Defining Business Process Steps
          • Guidelines for Defining Business Process Steps
        • Business Areas
        • Rule Sets
        • Business Objects
        • Motivations
        • Classifications
        • Sources
        • Data Contents
          • Owned vs. Shared Data Contents
          • Defining Data Contents
        • Implementations
        • Implementation Types
          • Automatically Generated Implementation Types
          • Manually Entered Implementation Types
        • Design Documents
        • Sessions
        • Notes
        • Note Sets
        • Repository Definitions
        • Repository Versions
        • Current Version
        • Test Needs
        • Export Definitions
          • Table Export Definitions
          • Domain Export Definitions
          • Constraint Export Definitions
          • Decision Export Definitions
          • Business Object Export Definitions
          • Business Area Export Definitions
          • Menu Page Export Definitions
          • Index Export Definitions
          • Site Information Export Definitions
        • Export Logs
        • Print Sequence
        • Workload
          • Workload at Business Object and/or Business Rule Level
          • Defining Workload
          • Monitoring Workload
        • Change Information
      • Object Shopping
        • Quick Walk-Through: Shopping an individual object
        • Quick Walk-Through: Shopping a business area
        • File format for Object Shopping
        • Inclusion rules for Object Shopping
          • Inclusion rules for Business Areas
          • Inclusion rules for Implementations
          • Inclusion rules for Tables, Views and Relationships
          • Inclusion rules for Domains
          • Inclusion rules for Jobs
        • Overwrite behaviour in Object Shopping
        • Object shopping via the clipboard (copy-paste)
      • Importing from USoft Studio
      • Importing off-the-shelf components and models
        • BIRT
          • Step 1: Download and Install BIRT Software
          • Step 2: Create a BIRT report definition file
          • Step 3: Import and configure the BIRT off-the-shelf component
          • Step 4: Start the USoft Rules Service
          • Step 5: Call the BIRT component to generate the report
          • Parameterisation of the BIRT report definition
          • Troubleshooting your BIRT connection
      • Exporting E/R diagrams to USoft Studio
      • Using USoft TeamWork
        • How to Add Data Contents
        • How to Add Information to Business Rules
        • How to Classify Business Rules as Belonging to Other Rules
        • How to Create an Export File
        • How to Define Business Areas
        • How to Define Business Objects
        • How to Define Business Processes
        • How to Define Business Rules
        • How to Define Data Contents
        • How to Define Export Definitions
        • How to Define Implementation Types
        • How to Define Implementations
        • How to Define Motivations
        • How to Define Note Sets
        • How to Define Notes
        • How to Define Repository Definitions
        • How to Define Repository Versions
        • How to Define Rule Sets
        • How to Define Sessions
        • How to Define Sources
        • How to Define Test Needs
        • How to Define the Current Version
        • How to Generate an E/R diagram for a Business Area
        • How to Generate an E/R diagram for a Business Object
        • How to Group Business Rules
        • How to Implement Business Rules
        • How to Monitor Workload
        • How to Obtain Change Information
        • How to Report and Fix Problems with Business Rules
        • How to Split Business Rules
        • How to Store a Design Document in the Database
        • How to Trace a Business Rule's Life-Cycle
        • How to View Export Logs
    • USoft Model and Rules Guide
      • Introducing USoft Model and Rules
        • Before you start
        • Getting started
        • Using the project catalog
          • Catalog icons
        • The Windows runtime interface
          • Info Windows
          • Info Boxes
          • Lookup Windows
          • Related Windows
          • Subtype Windows
          • Dialogs
          • Menus
          • The Objects List
          • The Transactions Window
          • The Picklist
          • The Workspace
            • How to save your workspace
          • The Find in Repository Dialog
          • The Toolbar
        • Printing in the production (runtime) environment
          • Data printing
        • Using USoft Definer
          • Manipulating records
          • Querying data from the database
            • How to define and execute queries
            • How to use Related Windows when querying
            • How to use wildcards and operators
          • Using spreadsheet look
            • Activating the spreadsheet popup menu
            • Manipulating records in spreadsheet Look
          • Saving your changes
        • Shortcut keys by key
        • Shortcut keys by function
        • Shortcut keys in spreadsheets
        • Mouse operations
      • Key concepts
        • Domains
          • Data types
          • Display types
            • Check Box display type
            • Option Buttons display type
            • Dropdown List Box display type
            • Slider display type
          • Allowed values
          • Default values
          • IO formats
            • Alternative input formats
            • Default date format
          • Unique values
          • Superdomains: Inheritance of domain properties
        • Tables
          • How to define a table and its columns
          • Table attributes
          • Generating tables
          • Indexes
        • Columns
          • How to add columns to a table
          • Column attributes
          • Virtual columns (joined columns)
        • Relationships
          • Mapping associations to tables, columns and relationships
          • How to define a relationship
          • Relationship attributes
          • The RELATE keyword
        • Logical views
          • Checking logical views
          • Limitations of logical views
          • Data manipulation through logical views
          • Logical view column attributes
          • How to define logical views
          • Rule-based logical views
            • How to define a rule-based logical view
            • Example: Rule-based Logical View
        • Constraints
          • Domain constraints
          • Table constraints
          • Transitional constraints
            • The OLD() function
            • Transition properties
              • Default transition properties
              • Changing default transition properties
              • Transitional constraints without OLD()
            • Differences between transitional and non-transitional constraints
            • Transitional constraint troubleshooting
          • Constraint messages
            • Variable constraint messages: Example 1
            • Variable constraint messages: Example 2
            • Variable constraint messages: Example 3
            • Variable constraint messages: Example 4
            • Variable constraint messages: Example 5
            • Variable constraint messages: Example 6
            • Supported constraint variables
            • Changing a restrictive constraint into a warning constraint
          • Constraint comments
          • Deferred table constraints
          • Recursive constraints
            • Example: Recursive constraint
          • Time constraints
            • The T_APP_TIME table
            • The Application Timer
            • Starting and stopping the Application Timer
          • Constraint implementation
            • Constraint activation events
              • Field-validation event
              • Store-record event
              • Commit event
            • Constraint evaluation order
              • Field corrections and field checks
              • Update-on-self corrections
              • Row checks
              • Transaction checklist signals
                • Driving table
                • Constraint key query
              • Cascade-to-other corrections
              • Transaction checks
              • Chained corrections
            • Preconditions and postconditions
              • Deactivation between constraints
              • Deactivation between incoming data, preconditions and postconditions
              • Update-on-self sorting
          • USoft Rule Language
            • USoft Rule Language and table constraints
            • USoft Rule Language and Object Name Plurals
            • USoft Rule Language and domain constraints
            • USoft Rule Language examples: Simple constraints
            • USoft Rule Language examples: Query statements with subquery
            • USoft Rule Language examples: Query statements with join
            • USoft Rule Language examples: Insert statements
            • USoft Rule Language examples: Update statements
            • USoft Rule Language examples: Delete statements
            • USoft Rule Language examples: GROUPED BY clause
            • USoft Rule Language examples: Statements without conditions
            • USoft Rule Language Examples: Variable constraint messages
        • Supertypes and subtypes
          • How to define a subtype table
          • Understanding subtype behaviour
            • Subtype indicators
            • Selecting subtype data
            • Inserting supertype and subtype data
            • Updating supertype and subtype data
            • Deleting supertype and subtype data
            • Relationship Inheritance from supertype to subtype (RELATE)
            • Constraints on supertypes and subtypes
            • Transitional constraints on supertypes and subtypes
            • GUI implementation of subtypes
          • Designing subtypes successfully
            • Setting Delete Super on Delete
            • Setting Update Supertype on Insert
            • Subtype Definitions
              • How to define a Subtype Definition
        • Decisions
          • Decision attributes
          • Decision variables and placeholders
          • Decision branching and looping
      • SQL and the Rules Engine
        • SQL Functions
          • ADD_DAYS SQL Function
          • CONCAT SQL Function
          • CURRENT_DATE SQL Function
          • DATALENGTH, LEN SQL Functions
          • DATEDIFF_IN_DAYS SQL Function
          • DATE_TO_CHAR SQL Function
          • ELAPSEDQUERYTRANSACTIONTIME SQL Function
          • ELAPSEDTRANSACTIONTIME SQL Function
          • INSTR SQL Function
          • OLD SQL Function
          • RECORDS SQL Function
          • SESSION_ID SQL Function
          • SUBSTR SQL Function
          • TIMESTAMP_TO_DATE SQL Function
          • TO_CLOB SQL Function
          • TRANSACTION_DATE SQL Function
          • TRUNC, TRUNCATE SQL Functions
          • USERGROUP SQL Function
        • RDBMS Functions
        • Pseudo-columns
        • Host variables in SQL
      • XML and the Rules Engine
        • USoft XML format
          • Table sections
          • Single-table XML documents
          • Multi-table XML documents
          • usoft-xml processing instruction
          • DML instruction tags
        • XML internal component
          • XML.CreateDTD
            • Example: Simple DTD creation
          • XML.Export
            • Example: Simple XML export
            • Example: XML export with DTD name and IO formats
            • Example: XML export for update
            • Example: XML export in combination with USFile
          • XML.GenerateComplexType
          • XML.Import
            • How import XML is processed
              • Obsolete children on import
              • Generating key values for parent-child data on import
            • XML.Import: Known problems and workarounds
            • The returning XML document
          • XML.Query
            • Example: Simple XML query
            • Example: XML query with Order-by attributes
          • XML.MultiExportTables
            • Example: exporting only database tables
          • XML.SQL2XML
          • XML.SQLStatementExport
          • XML.SQLExport
            • XML.SQLExport example
            • XML.SQLExport output description
            • XML.SQLExport compared to XML.Export
        • USXSL internal component
          • USXSL.Apply
          • USXSL.Apply2File
          • USXSL.Node
          • USXSL.SetGlobalXsl
          • USXSL.SetXml
          • USXSL.SetXsl
          • USXSL.Value
          • Mixing USoft application data into an XSLT transformation
        • Other XML formats
          • XML representation of date values
          • Document Type Definition (DTD) specification
          • XML representation of queries
            • Query By Form definition
        • XQuery
          • XQuery example 1
          • XQuery example 2
      • Rules-Driven Method Invocation (RDMI)
        • Components
          • Invoking components
          • Possible USoft contexts for INVOKE
          • When and how many times a component is invoked
            • INVOKE: Example 1
            • INVOKE: Example 2
            • INVOKE: Example 3
            • INVOKE: Example 4
          • Component state
          • Constructor SQL
        • Parameters
          • Parameter datatypes
          • Modes of RDMI parameters
            • InList parameter mode
          • How parameters are passed to and from components
        • RDMI Protocols
          • Standard protocol
          • Query protocol, component table
            • Example 1: Component table querying a CSV file
            • Example 2: Component table querying multiple CSV files
          • Aggregate protocol
            • Example: .NET component for exporting a data set to a CSV file
        • Using RDMI
          • Example 1: Invoking a randomizer
          • Example 2: Resolving an email address
          • Example 3: Checking an email address
          • Example 4: Sending an email
        • COM and DCOM components (Automation servers)
          • How to define an Automation server
        • Java Enterprise (J2EE) components
          • Defining J2EE components
            • Physical constructors
            • Defining a method
            • Passing arguments to methods
            • Method lookup wizard
            • Method invocation syntax
            • Limitations
            • Typecasts
          • Debugging J2EE components
        • DotNet (.NET) components
          • Defining a component starting from the RDMI interface
          • Defining a component starting from C# code
            • Example: Tracing information from a dotNet application
            • Example: Calling a method from a library created in an external DLL
          • Argument type mapping for dotNet
          • Static members
          • Application data in dotNet components
          • .NET-USoft data provider
          • Component references and inheritance for dotNet
        • RDMI error handling
          • Showing or suppressing component error messages
          • RDMI error messages
        • Internal components
          • Internal domain components
            • domain.CheckValue
          • Internal table components
            • table.GetNextGeneratedUniqueValue
          • RulesEngine internal component
            • RulesEngine.ExecuteStatement
            • RulesEngine.GetLastCaughtErrors
            • RulesEngine.GetLastCaughtErrorsAsXML
            • RulesEngine.GetLastGeneratedUniqueValue
            • RulesEngine.GetProperty
            • RulesEngine.GetRegistry
            • RulesEngine.MessageLanguage
            • RulesEngine.MustExistExecuteStatement
            • RulesEngine.PreCommit
            • RulesEngine.RefreshAuthorization
            • RulesEngine.SetProperty
            • RulesEngine.SetUser
            • RulesEngine.SetUserGroup
            • RulesEngine.StartCatchingErrors
            • RulesEngine.StopCatchingErrors
            • RulesEngine.TranslateMessage
            • Rules Engine properties
              • AllowSetManipulations
              • Application
              • BatchLogLevel
              • BinDir
              • ConceptualFile
              • ConstraintsActive
              • Database
              • DefaultDateFormat
              • DeferRestrictiveRelationalChecks
              • EndUserMsgs
              • Env
              • LockForeignKeys
              • LockParentOnSeqno
              • MaxConstraintDepth
              • MaxDriverConditions
              • NumberOfUpdateColumns
              • OsUserHomeDir
              • OsUserName
              • OsUserTempDir
              • Rdbms
              • RdbmsVersion
              • RecordFactsCacheSize
              • RowsCommitted
              • ShowComponentErrors
              • ShowMiddlewareErrors
              • ShowRdbmsErrors
              • SystemDir
              • TempTablesAtOwner
              • UniqueKeyCheck
              • UpdateSupertypeOnInsert
              • USoftLogDir
              • USoftTempDir
              • Version
              • WaitForLock
          • XML internal component
          • USFile internal component
            • USFile.Close
            • USFile.EOF
            • USFile.Open
            • USFile.ReadBinaryFile
            • USFile.ReadLine
            • USFile.ReadTextFile
            • USFile.Write
            • USFile.WriteBinaryFile
          • USFormat internal component
            • USFormat.CharAddIOFormat
            • USFormat.CharRemoveIOFormat
            • USFormat.CharToDate
            • USFormat.CharToDouble
            • USFormat.CharToLong
            • USFormat.DateToChar
            • USFormat.DoubleToChar
            • USFormat.IsAlphanumeric
            • USFormat.IsXMLName
            • USFormat.LongToChar
          • USMeta internal component
            • USMeta.Tables
            • USMeta.Columns
            • USMeta.Relationships
          • USXSL internal component
          • USPowerShell internal component
            • Example: Simple script execution
            • Example: Script execution with paramaters
            • Example: Stateful test
            • Example: Dynamically adding C#
            • Example: Converting MS Word to PDF
            • Example: Query call to the Rules Engine
            • Example: Manipulation call to the Rules Engine
            • Example: Call to the Rules Engine with variables
            • Example: Query call to the Rules Engine and loop through result
        • Web service components
          • Creating a web service component
          • How to import web service definitions
          • Calling a web service component
          • Calling a web service using an INVOKE statement
          • Calling a web service using a component table
            • Using XSL transformations for web service component tables
            • The USoft component table XML format
            • Finishing creating a web service component table
          • Proxy server settings
          • How to modify existing web service components
          • Web service component details
          • Setting a timeout value when calling a web service
          • DIME messages support
          • How to implement DIME messages
          • MTOM (Message Transmission Optimization Mechanism Support)
            • How to create an MTOM web service component
            • How to change the name of the received files
            • How to automatically generate a file name for received files
          • Debugging web service components
            • How to enable BenchMark profiling for a web service component
          • The sendSoapMessage function
      • Web services
        • USoft as a web service provider
          • How to define a web service and its methods
          • Defining parameters
            • Simple type and complex type parameters
            • Examples of simple type and complex type parameters
            • Parameter values and domains
            • Rules for parameter values
            • Examples of parameter values
          • Checking a web service method
          • SQL statement details of a web service provider method
          • Detailed web service settings
          • Generated files
        • Namespaces
          • How to define a namespace for an XML schema
        • Runtime architecture of a web service
        • RPC-oriented methods versus document-oriented methods
          • Differences between RPC-oriented methods and document-oriented methods
        • Web service examples
          • Web service example 1: RPC-oriented method with simple type parameters
            • Web service example 1: Define a web service provider
            • Web service example 1: Define a web service component
            • Web service example 1: SOAP request and response messages
          • Web service example 2: RPC-oriented method with simple type parameters based on a domain
            • Web service example 2: SOAP request and response messages
          • Web service example 3: RPC-oriented method with a complex type parameter based on a domain with allowed values
            • Web service example 3: XML schema definition for an AGE type with allowed values
          • Web service example 4: Document-oriented method with simple type parameters
            • Web service example 4: Step-by-step instructions
            • Web service example 4: SOAP request and response messages
          • Web service example 5: Document-oriented method with complex type parameters
            • Web service example 5: Step-by-step instructions
            • Web service example 5: XML schema definition for scheduled tours
            • Web service example 5: SOAP request and response messages
          • Web service example 6: RPC-oriented method with complex type SOAP array parameters
            • Web service example 6: Transforming attributes to dhild elements
            • Web service example 6: XML schema definition for scheduled tours
            • Web service example 6: Step-by-step instructions
          • Web service example 7: Component table with an output XSL transformation
            • Web service example 7: Define a web service provider method
            • Web service example 7: Define a component table to access a web service
            • Web service example 7: XML schema definition for tours
          • Web service example 8: Component table with an input XSL transformation
            • Web service example 8: Step-by-step instructions
            • Web service example 8: SOAP request and response messages
          • Web service example 9: Web service executing a batch job
            • Web service example 9: Step-by-step instructions
        • WSDL
          • Example of a WSDL document
        • Troubleshooting web services
          • Web service error messages
          • Web service debugging tips
          • Web service error handling
            • Customized XML error messages
            • Example: Customized XML error message
            • Example: USoft XML error messages
        • Importing a web service provider from a WSDL document
      • Modular development
        • Modular development
        • Modules
          • Composing modular applications
          • Running modular applications
          • The Module field in USoft Binder
          • Modules as plug-ins
        • Interface providers
          • Table interface providers
          • Rules for interface providers
          • How to define a table as interface provider
          • How to change an interface table into a database table
          • How to remove a column as interface provider
          • How to define or remove a domain as interface provider
          • How to define or remove a decision as interface provider
          • How to define or remove a batch job as interface provider
          • How to define or remove an RDMI Component as interface provider
          • How to view all interface providers
        • Synchronizing internal interfaces
          • How to import internal interfaces
      • Tuning your application
        • Optimizing application performance
          • RDBMS performance hints
        • Referential integrity
          • Disabling total locking
          • Postponing validation
          • Locking behaviour
      • Setting up a production environment
        • Flat files for distribution
        • Locating flat files
        • Installing your application on a server
        • How to install authorization in a production environment
        • Creating a production database
        • Calculating Oracle tablespace
        • How to define sites
        • How to set tablespace definitions
        • How to define site tables
        • How to define site indexes
        • How to calculate space requirements
        • How to create installation files
      • Miscellaneous tools
        • Create Flat Files tool
        • SQL Command tool
        • SQL Definer
          • Modes of operation
          • How to start the SQL Definer
          • How to start a new statement
          • How to select tables
          • How to change the appearance of the FROM list pane
          • How to specify a WHERE condition
          • How to specify output columns
          • How to specify values in INSERT...VALUES and UPDATE...SET statements
          • How to build subqueries into INSERT or UPDATE statements
          • How to define GROUP BY and ORDER BY clauses
          • How to modify or remove tables and other elements
          • How to manually edit your statement
          • How to execute your statement
          • How to save your statement
        • Cross-reference information
        • How to generate HTML pages from your repository
        • How to modify the Reserved Words List
        • The Bridge Wizard
          • How to use the Bridge Wizard
      • RDBMS portability
        • RDBMS connection recovery
        • NULL Values
        • Convertible datatypes
        • USoft for Microsoft SQL Server
        • USoft for ODBC
          • ODBC driver requirements
          • ODBC conformance
          • ODBC functions used by USoft applications
          • ODBC SQL syntax
          • ODBC scalar functions
          • ODBC scalar datatypes
        • USoft for Oracle
      • Connecting to and from other programs
        • JDBC Rules Engine connectivity
          • User authentication when using JDBC
          • Making Java client programs connect to a Rules Engine
            • Java Example Step 1: Loading the USoft JDBC classes
            • Java Example Step 2: Opening a connection to the Rules Engine
            • Java Example Step 3: Selecting records
            • Java Example Step 4: Closing the connection
          • JDBC Database metadata methods supported by USoft
            • allProceduresAreCallable()
            • allTablesAreSelectable()
            • dataDefinitionCausesTransactionCommit()
            • dataDefinitionIgnoredInTransactions()
            • doesMaxRowSizeIncludeBlobs()
            • getCatalogs()
            • getCatalogSeparator()
            • getCatalogTerm()
            • getColumns( catalog, schemaPattern, tableNamePattern, columnNamePattern )
            • getConnection()
            • getDatabaseProductName()
            • getDatabaseProductVersion()
            • getDefaultTransactionIsolation()
            • getDriverMajorVersion()
            • getDriverMinorVersion()
            • getDriverName()
            • getDriverVersion()
            • getExtraNameCharacters()
            • getIdentifierQuoteString()
            • getMaxBinaryLiteralLength()
            • getMaxCatalogNameLength()
            • getMaxCharLiteralLength()
            • getMaxColumnNameLength()
            • getMaxColumnsInGroupBy()
            • getMaxColumnsInIndex()
            • getMaxColumnsInOrderBy()
            • getMaxColumnsInSelect()
            • getMaxColumnsInTable()
            • getMaxConnections()
            • getMaxCursorNameLength()
            • getMaxIndexLength()
            • getMaxProcedureNameLength()
            • getMaxRowSize()
            • getMaxSchemaNameLength()
            • getMaxStatementLength()
            • getMaxStatements()
            • getMaxTableNameLength()
            • getMaxTablesInSelect()
            • getMaxUserNameLength()
            • getNumericFunctions()
            • getPrimaryKeys( catalog, schema, table )
            • getProcedureColumns( catalog, schemaPattern, procedureNamePattern, columnNamePattern )
            • getProcedures( catalog, schemaPattern, procedureNamePattern )
            • getProcedureTerm()
            • getSchemas()
            • getSchemaTerm()
            • getSearchStringEscape()
            • getSQLKeywords()
            • getStringFunctions()
            • getSystemFunctions()
            • getTables( catalog, schemaPattern, tableNamePattern, types)
            • getTableTypes()
            • getTimeDateFunctions()
            • getURL()
            • getUserName()
            • getVersionColumns( catalog, schema, table )
            • isCatalogAtStart()
            • isReadOnly()
            • nullPlusNonNullIsNull()
            • nullsAreSortedAtEnd()
            • nullsAreSortedAtStart()
            • nullsAreSortedHigh()
            • nullsAreSortedLow()
            • storesLowerCaseIdentifiers()
            • storesLowerCaseQuotedIdentifiers()
            • storesMixedCaseIdentifiers()
            • storesMixedCaseQuotedIdentifiers()
            • storesUpperCaseIdentifiers()
            • storesUpperCaseQuotedIdentifiers()
            • supportsAlterTableWithAddColumn()
            • supportsAlterTableWithDropColumn()
            • supportsANSI92EntryLevelSQL()
            • supportsANSI92FullSQL()
            • supportsANSI92IntermediateSQL()
            • supportsCatalogsInDataManipulation()
            • supportsCatalogsInIndexDefinitions()
            • supportsCatalogsInPrivilegeDefinitions()
            • supportsCatalogsInProcedureCalls()
            • supportsCatalogsInTableDefinitions()
            • supportsColumnAliasing()
            • supportsConvert( fromType, toType )
            • supportsConvert()
            • supportsCoreSQLGrammar()
            • supportsCorrelatedSubqueries()
            • supportsDataDefinitionAndDataManipulationTransactions()
            • supportsDataManipulationTransactionsOnly()
            • supportsDifferentTableCorrelationNames()
            • supportsExpressionsInOrderBy()
            • supportsExtendedSQLGrammar()
            • supportsFullOuterJoins()
            • supportsGroupBy()
            • supportsGroupByBeyondSelect()
            • supportsGroupByUnrelated()
            • supportsIntegrityEnhancementFacility()
            • supportsLikeEscapeClause()
            • supportsLimitedOuterJoins()
            • supportsMinimumSQLGrammar()
            • supportsMixedCaseIdentifiers()
            • supportsMixedCaseQuotedIdentifiers()
            • supportsMultipleResultSets()
            • supportsMultipleTransactions()
            • supportsNonNullableColumns()
            • supportsOpenCursorsAcrossCommit()
            • supportsOpenCursorsAcrossRollback()
            • supportsOpenStatementsAcrossCommit()
            • supportsOpenStatementsAcrossRollback()
            • supportsOrderByUnrelated()
            • supportsOuterJoins()
            • supportsPositionedDelete()
            • supportsPositionedUpdate()
            • supportsResultSetConcurrency( type, concurrency )
            • supportsResultSetType( type )
            • supportsSchemasInDataManipulation()
            • supportsSchemasInIndexDefinitions()
            • supportsSchemasInPrivilegeDefinitions()
            • supportsSchemasInProcedureCalls()
            • supportsSchemasInTableDefinitions()
            • supportsSelectForUpdate()
            • supportsStoredProcedures()
            • supportsSubqueriesInComparisons()
            • supportsSubqueriesInExists()
            • supportsSubqueriesInIns()
            • supportsSubqueriesInQuantifieds()
            • supportsTableCorrelationNames()
            • supportsTransactionIsolationLevel( level )
            • supportsTransactions()
            • supportsUnion()
            • supportsUnionAll()
        • Open Database Connectivity (ODBC)
        • Dynamic Link Libraries (DLLs)
        • Connecting non-database users to a USoft application
        • Dynamic Data Exchange (DDE)
          • DDE characteristics
          • USoft as a DDE client
            • Starting and finishing DDE conversations
            • Requesting and sending items
            • Executing a command
            • Running an advise loop
          • USoft as a DDE server
            • Using the Field topic
            • Using the SQL topic
          • Example of DDE in use
            • Which action(s) to use?
        • Support for Microsoft Transaction Server (MTS)
          • Distributed transactions and the two-phase commit protocol
          • The MTS architecture
            • Example 1: The Bank sample application
            • Example 2: MTS component sample code
        • Object Linking and Embedding (OLE)
          • OLE containers
          • OLE controls (OCX)
      • Localising your application
        • Defining languages
        • Defining translations
        • Providing translations
        • Dynamic language switching
        • XML errror messages
          • USoft XML message format
          • XSL transformations for editing messages
            • Switching between end user messages and developer messages
            • Customising messages
            • XSL editing effects on error logging
          • XML error message reference
            • Common structure
            • System messages with parameters
            • Rule violation messages
            • Context subtree and execution stack
            • Record information
            • Constraint-specific elements in rule violation messages
            • RDBMS messages
      • The Travel Agency application
        • Travel Agency data model
    • USoft Batch Guide
      • Introducing USoft Batch
      • Getting Started
        • Creating the USoft Batch Repository
        • Granting Yourself the Appropriate Rights
        • Starting the Definer
        • Using the Project Catalog
          • Project Catalog Batch Tab Page
            • Catalog Icons
        • Using SQL Definer
      • Jobs
        • Executing a Job from USoft Binder
        • Executing a Job from the Command Line
        • Executing a Job from within a USoft Web Application
        • Executing a Job from within a USoft C/S Application
        • Executing a Job from another Job
        • Executing a Job from a Constraint
        • BatchRunner Internal Component
          • Job Methods
          • BatchRunner.RunJob
          • BatchRunner.StartJob
          • BatchRunner.GetJobProperty
          • Predefined parameters for Batchrunner calls
        • Parameters and Variables
          • Job Output Parameters
          • Job Parameters as Import Task Variables
          • Import Task Set Virtuals Managing Decision Trees
          • Import Task Set Virtuals in Record-by-Record Computations
        • Logging
        • Error handling
          • Fatal Errors in Batch Jobs
        • Commit Type and Abort Mode settings
          • Task-Level Commit vs. Record-Level Commit
          • Error Handling and Abort Mode
          • Abort Mode and Commit Type Combinations
      • Tasks
        • SQL Tasks
        • Action Tasks
        • Export Tasks
        • Import Tasks
          • Import Task Status Files
        • Job Tasks
      • External Sets
        • File Formats
          • FIXED File Format
          • FIXEDVLE File Format
          • VARIABLE File Format
          • Comma-Separated Values (CSV) File Format
          • Record Separators
        • How to Compute Set Elements
        • External Sets for Export Tasks
          • How to Define External Sets and their Elements
            • Date Formats and Floating-Point Number Formats
          • Export Task Child Sets
          • How to Define HTML Sets
            • How to Specify HTML Set Attributes
            • Exporting Data to HTML Files
              • Layout Style
              • Navigation Style
              • Creating a Template
                • Using more than one layout
              • Viewing the Results
        • External Sets for Import Tasks
          • Driving Sets for Import Tasks
          • Import Task Set Virtuals
          • Example of an Import Task Set Virtual
          • User-Defined Tables for Import Tasks
            • Preparing to Use User-Defined Tables
        • Storing External Set Data in Tables
      • Advanced Techniques
        • Delayed Processing
          • Delaying Processing Using a Status Field
          • Delaying Processing Using Deactivation
        • Deactivating and Reactivating Checks and Constraints
        • Messages in SQL Tasks and Import Tasks
        • Reject tables
          • Defining a Reject Table
          • Transferring Error Status Data Into a Reject Table
          • Importing All Records Via a Reject Table
          • Detecting and Repairing Expected Import Errors Before Bulk Import
        • Working with external files
          • How to Import an XML File within a Batch Job
          • Recognizing External File Layout
          • Creating External File Layout
            • Lining Up Columns in an External File
            • Producing Header or Footer Lines in an External File
        • Working with parameters in import tasks
        • Scheduling
          • Store Batch Scheduler Information
            • Executing Jobs Scheduled Within a USoft Application
          • Scheduling Batch Jobs Using a BenchMark Procedure
          • Schedule Batch Processing with the Application Timer
          • Checking if a Job Should Run At All
            • Using a Decision to Check if a Job Should Run
        • Performance
          • Improving Import Task Performance
          • Improving SQL Task Performance
          • Disabling Rules
          • Improving Export Task Performance
        • Profiling Batch Jobs
      • The HTML Generator Test Drive
        • HTML Generator Test Drive
          • Installation Instructions
        • Step 1: Loading Sample Application Definitions
        • Step 2: Loading Sample Application Data
        • Step 3: Running Sample HTML Batch Jobs
        • Step 4: Exploring the Generated HTML Reports
        • Step 5: Exploring the Sample Data Model
        • Step 6: Defining a Simple HTML Batch Job That Extracts Data from One Table
        • Step 7: Running the Job and Viewing the Result
        • Step 8: Exploring the Generated HTML
        • Step 9: Defining More Complex HTML Batch Jobs That Extract Parent-Child Data
        • Step 10: Running the Job and Viewing the Result
        • Step 11: Defining a More Complex HTML Batch Job That Extracts Calculated Data
        • Step 12: Running the Job and Viewing the Result
        • Step 13: Customizing the HTML Template
        • Test Drive Background Information
          • Why Load Sample Application Definitions?
          • Why Load Data, and Why Load it by Means of a Batch Job?
          • Why Run Sample HTML Batch Jobs?
          • Why Explore the Sample Application Definitions?
          • Why Explore the Generated HTML?
          • Why Define More Complex HTML Batch Jobs?
    • USoft Developer Reference Guide
      • USoft Developer Reference Guide
      • Keyboard and Mouse Reference
        • Key Functions by Key
        • Key Functions by Function
        • Key Functions Available in Spreadsheets
        • Mouse Functions Available in Spreadsheets
      • USoft Action Language
        • Methods by use case
          • Methods for Starting and Stopping Applications
          • Methods for Performing Queries
          • Methods for Moving the Cursor between Records
          • Methods for Manipulating Data
          • Methods for Manipulating Controls
          • Methods for Communicating with the User
          • Methods for Manipulating Windows
          • Methods for Providing Help
          • Methods for Working with Files and Folders
          • Methods for Working with Resources
          • Methods for Dynamic Data Exchange (DDE)
          • Miscellaneous Methods
          • Methods for Communicating with the Operating System
          • Methods for Push Buttons
          • Methods for OLE/ActiveX Containers
          • Methods Supported in the Rules Service
        • Methods by name
          • About()
          • Accept()
          • ActionAllRows()
          • ActionControl()
          • ActionDecision()
          • ActionDialogApply()
          • ActionDialogCancel()
          • ActionDialogOk()
          • ActionDllExecute()
          • ActionDoNothing()
          • ActionRibbon()
          • ActionSelectedRows()
          • ActionStartJob()
          • ApplicationExit()
          • ApplicationLogin()
          • ApplicationProgressHide()
          • ApplicationProgressSet()
          • ApplicationProgressShow()
          • ApplicationRefresh()
          • CallMethod()
          • ChangeSql()
          • CommandSystemBackground()
          • CommandSystemForeground()
          • CommandWindows()
          • ComputerBrowse()
          • ComputeSet()
          • ControlAllowResize()
          • ControlDelete()
          • ControlFixColumn()
          • ControlSetActiveTab()
          • ControlSetFocus()
          • ControlSetInsensitive()
          • ControlSetSensitive()
          • ConvertAlternativeFormat()
          • Copy()
          • Create()
          • create-application-text-file()
          • create-conceptual-file()
          • create-system-message-file()
          • CurrentColumn()
          • CurrentField()
          • CurrentInfoBox()
          • CursorFirstRecord()
          • CursorGotoRecord()
          • CursorLastRecord()
          • CursorNextPage()
          • CursorNextRecord()
          • CursorPreviousPage()
          • CursorPreviousRecord()
          • DataCommit()
          • DataRdbmsStatement()
          • DataReport()
          • DataRollback()
          • DataToClipboard()
          • DdeConnect()
          • DdeDisconnect()
          • DdeExecute()
          • DdePoke()
          • DdeRequest()
          • DdeStartAdvise()
          • DdeStopAdvise()
          • Delete()
          • Drag()
          • ErrorRaise()
          • esi-create-schema-file()
          • ExecuteLookupMethod()
          • FieldClear()
          • FieldDuplicate()
          • FieldPaste()
          • FieldSelect()
          • FileEdit()
          • FileExists()
          • FileOpen()
          • FileSaveAs()
          • FileSearchIn()
          • FolderBrowse()
          • FORMULA()
          • GetValueFromCurrentItem()
          • GotoCel()
          • HasFocus()
          • Help()
          • HelpOnAccelerators()
          • HelpOnControl()
          • HelpOnLastMessage()
          • HelpOnTable()
          • HelpRunWinhelp()
          • HelpWhatsThis()
          • InsertString()
          • LookupAccept()
          • MenubarAddItem()
          • MenubarDeleteItem()
          • MenubarMarkItem()
          • MenubarSetItem()
          • MessageError()
          • MessageInformation()
          • MessageLanguage()
          • MessageQuestion()
          • MessageShowList()
          • MessageWarning()
          • Module()
          • Notify()
          • OnlineCall()
          • PageSetup()
          • PointerShowWaitstate()
          • PopupEditorDialog()
          • Print()
          • PrintDirect()
          • QueryAbort()
          • QueryDbCount()
          • QueryDefine()
          • QueryExecute()
          • QueryPrevious()
          • RdbmsDisconnect()
          • RecordClear()
          • RecordClearTable()
          • RecordClearWindows()
          • RecordCreate()
          • RecordDelete()
          • RecordDuplicate()
          • RecordRefresh()
          • RecordScrollTo()
          • RecordSelect()
          • RecordSelectAll()
          • RecordSingleView()
          • RecordStore()
          • RecordUndo()
          • RecordWrite()
          • ReevaluateTableSequence()
          • RefreshConstraints()
          • RefreshList()
          • RefreshTree()
          • Rename()
          • ResourceFileUpdate()
          • ResourceFileUpdateKeepBackslash()
          • RuleProfilerDescription()
          • RuleProfilerStart()
          • RuleProfilerStop()
          • Save()
          • Self()
          • Set()
          • SetDefault()
          • SetProperty()
          • SetSilentErrorMessages()
          • SetSilentInformationMessages()
          • SetSilentWarningMessages()
          • SetViewMode()
          • Sort()
          • SqlDefiner()
          • SqlScript()
            • SQL Command settings
          • SqlSelect()
          • Unset()
          • UnsetDefault()
          • ValidateJob()
          • WindowArrange()
          • WindowAtMousePosition()
          • WindowCentreScreen()
          • WindowCentreWindow()
          • WindowClose()
          • WindowCloseAll()
          • WindowCreate()
          • WindowCreateLookup()
          • WindowCreateLookupDialog()
          • WindowCreateRelated()
          • WindowCreateSecondary()
          • WindowCreateSubtype()
          • WindowIconize()
          • WindowMinimize()
          • WindowObjectList()
          • WindowRestore()
          • WindowToClipboard()
          • WindowTransactions()
        • Deprecated methods
          • ac-rel()
          • action()
          • action-other-control()
          • control-set-values()
          • set-values()
          • set-workarea()
      • Property Reference
        • Property Names vs Internal Names
        • Allowed Property Values vs Internal Resource Values
        • Properties by type
        • Properties by name
          • (NULL) Prompt property
          • Action property
          • Actions At Startup property
          • Adjust Change property
          • After SetUser property
          • After Usergroup Changed property
          • Alignment property
          • Allow Neighbor property
          • Allow Open Query property
          • Alternative Input Format property
          • Auto Expand property
          • Auto-commit property
          • Automatic Synchronization property
          • Auto-resize property
          • Auto-Tab property
          • Background Color property
          • Background Fetch property
          • Border Color property
          • Border Type property
          • Border Width property
          • Buffer Height property
          • Button Type property
          • Caption property
          • Catalog property
          • Chart Size (% Of Field) property
          • Check Count Query property
          • Check List property
          • Child Nodes property
          • Client Edge property
          • Client property
          • Column Alignment property
          • Column Headings property
          • Column Insertable property
          • Column Manager Class property
          • Column Widths property
          • Context Help property
          • Create on Demand property
          • Current Line Color property
          • Cursor Positioning property
          • Data Alignment property
          • Data Length property
          • Default Bind property
          • Default Value property
          • Deletable property
          • Detail Joined Columns property
          • Dialog Startup Actions property
          • Display All Subtype Indicators property
          • Display Class property
          • Display Foreign Key property
          • Display Length property
          • Display Text property
          • Display Type property
          • Displayed property
          • Double-click Action property
          • Early Save-local property
          • Echo property
          • Edit Method property
          • Edit Mode property
          • Expand Tree property
          • Expansion Level property
          • Extra Width For Label property
          • Fast Open property
          • Fast-Open Priority property
          • First Field on Create Record property
          • First Field on Data Manipulation property
          • First Field on Query property
          • Fix Column on Display property
          • Fixed Length property
          • Floor On Minimum property
          • Focus Type property
          • Foreground Bitmap property
          • Foreign Key Color property
          • Generate List property
          • Group Border Title Justify property
          • Group Border Title property
          • Group property
          • Height of Internal Buffer property
          • Height property
          • Help File property
          • Help Popup property
          • Help Topic ID property
          • Highlight Current Field property
          • Highlight Current Record property
          • Highlight Thickness property
          • Horizontal Cell Margin property
          • Horizontal Distance property
          • Horizontal Scrollbar property
          • Horizontal Spacing property
          • Iconic property
          • Idle Time-out Actions
          • Idle Time-out On Messages
          • Idle Time-out Time
          • Image property
          • Implement Scrollbar property
          • Include Subtype Presentations property
          • Initial Value property
          • Input Allowed property
          • Insertable property
          • Internal Height property
          • Internal Width property
          • IO Format property
          • Joined Columns property
          • Label Position property
          • Label property
          • Label Rotation property
          • Label Type property
          • Line Color property
          • Line Style property
          • Lock Parent On Sequence property
          • Lookup Method property
          • Mandatory property
          • Max Character Width property
          • Max Height property
          • Max No of Records Per Fetch property
          • Max Width property
          • Maximize Button property
          • Maximized property
          • Maximum No of Resident Windows property
          • MDI Child property
          • Menu Page property
          • Minimize Button property
          • Minimized property
          • Minimum Height property
          • Minimum Width property
          • Mnemonic property
          • Modal property
          • Mouse Pointer Shape property
          • Name property
          • No Action property
          • No of Decimals property
          • No Of Records Displayed property
          • No Of Records Displayed property (secondary info boxes)
          • Node-specific Menus property
          • Note property
          • Number Of Columns In Updates Property
          • Object Name property
          • On Change property
          • On Database Error property
          • On Empty Window property
          • Open Only Once property
          • Optimize Joined Column Fetch property
          • Oracle ROWID property
          • Order By property
          • Orientation property
          • Overlay Condition property
          • Overlay Image property
          • Page Title property
          • Pattern property
          • Popup Menu Page property
          • Position property
          • Post-change property (columns)
          • Post-change property (info boxes)
          • Post-close property
          • Post-create property
          • Post-delete property
          • Post-edit property
          • Post-fetch property
          • Post-insert property
          • Post-leave property
          • Post-open property
          • Post-rollback property
          • Post-update property
          • Pre-close property
          • Pre-commit property
          • Pre-delete property
          • Pre-exit Validation property
          • Pre-field-entry property
          • Pre-insert Validation property
          • Pre-record-entry property
          • Pre-update Validation property
          • Primary Key Color property
          • Primary Key Font property
          • Prompt For Edit property
          • Prompt For Fixed property
          • Prompt For Lookup property
          • Prompt property
          • Query Allowed property
          • Query Mandatory property
          • Query Some Mandatory property
          • Range Maximum property
          • Range Minimum property
          • Reflect Updates property
          • Refresh Changed Records property
          • Related Column property
          • Related Windows For Menu property
          • Relationships property
          • Resize Child property
          • Root Nodes property
          • Round Off Monetary Values property
          • Show Icons property
          • Show Message Numbers property
          • Show Root Lines property
          • Single Selection property
          • Sizable property
          • Sort Alphabetically property
          • SQL Query property
          • SQL Statement property
          • Startup Actions property
          • Static Edge property
          • Subtype Method property
          • Subtype Presentations property
          • Synchronize Lookup property
          • System Menu property
          • Tab Order property
          • Text Color property
          • Text Font property
          • Tick Mark Frequency property
          • Tick Mark Position property
          • Title property
          • Tool Window property
          • Topmost property
          • Underlying Query property
          • Uniform Cell Width property
          • Unit Lines Primary Axis property
          • Unit Lines Secondary Axis property
          • Updatable Only if Null property
          • Updatable property
          • Uppercase property
          • Use Static Tables property
          • Value List Prompts property
          • Value List property
          • Values to Query property
          • Vertical Cell Margin property
          • Vertical Distance property
          • Vertical Scrollbar property
          • Vertical Spacing property
          • View property
          • Virtual Color property
          • WHERE clause property
          • Width property
          • Window Edge property
          • X Position property
          • Y Position property
          • Yes Action property
    • USoft Rules Engine Guide
      • Introducing the USoft Rules Engine
      • Business Rules in the Rules Engine
      • Getting Started with USoft Rules Engine
      • Rules Engine behaviour
        • Transactions
        • Rules Engine validation moments
        • Row events
          • Pre-store, store-record, and post-store operations
          • Violation lists
        • Domain Checks
        • Rules Engine behaviour on INSERT
          • Field validation before INSERT
          • Group validation before INSERT
          • Pre-store record validation before INSERT
          • Post-store record validation after INSERT
          • Transaction validation after INSERT
        • Rules Engine behaviour on UPDATE
          • Field validation before UPDATE
          • Group validation before UPDATE
          • Pre-store record validation before UPDATE
          • Post-store record validation after UPDATE
          • Transaction validation after UPDATE
        • Rules Engine behaviour on DELETE
          • Pre-store record validation before DELETE
          • Post-store record validation after DELETE
          • Transaction validation after DELETE
      • Rules Engine parameters
      • Rules Engine properties
      • Rules Engine Optimisation Techniques
      • Lock and Commit Management
        • Smart Locking
        • Lock Parent on Sequence
        • Commit Management
      • Reasons for SQL Statements
      • Startup Constraints
      • Performance and Tuning Tips
        • Window Startup
          • Save Workspace
          • Resident Windows
          • Fast Open
          • Fast Open Priority
          • Remove Automatic Query
          • Use Gridboxes
          • Create Tab Pages on Demand
          • Define properties at the highest possible level
          • Re-inherit your Settings
        • Querying
          • Use Static Tables
          • Define Additional Indexes
          • Do Not Allow Open Queries
          • Query Mandatory
          • Query Some Mandatory
          • Check Count Query
          • Synchronize Lookup
          • Use Screen Values
          • Optimize Joined Column Fetch
          • Remove Columns from Main Query
          • Limit Query Buffer Size
        • Data Manipulation
          • Tune the Number of Columns in Update Statements
          • When Not to Lock Parent Records
          • Tune Additional Parameters
            • Unique Key Checks
            • Record Facts Cache
            • Record Facts Cache Size
            • Maximum Prepared Checks
            • Optimize Changed Table
          • Query Combining
            • Change in Functionality With Query Combining
        • General SQL Tuning Tips
          • Number of Subqueries
          • Joins versus EXISTS
          • WHERE versus HAVING
          • Avoid Grouping (DISTINCT / GROUP BY)
          • Group By Parent Columns
          • Use Table Aliases
          • Use the SQL Definer
          • EXISTS versus IN
          • Used Indexes
        • Table Components
          • Extended Query Conditions
            • The Extended Query Conditions XML Document
            • Pre-Defined XSL Transformations
          • Fetching Component Tables
            • Fetching Component Tables: Example
            • Order of Querying Tables
      • Rules Engine Checks
        • Domain Checks
        • Field Validation Checks
        • Group Validation Checks
        • Record Validation Checks
        • Transaction Validation Checks
  • USoft Delivery Manager Guide
    • Introducing USoft Delivery Manager
      • USoft Delivery Manager and .Git
      • Release management operations
        • Flag for release
        • Release
          • Release trees
          • Release properties
        • Deliver
        • Configure
          • Configuration by variable substitution
          • Configuration by XSL transformation
          • Configuration example 1
          • Configuration example 2
          • Configuration example 3
        • Deploy
      • Repository management operations
        • Export
        • Compare
        • Import
    • Getting started: Quick Walk-Through
      • Reviewing your development platform
      • Setting up Delivery Manager
        • Deciding on a location for Delivery Manager
    • USoft Delivery Manager concepts
      • Actions
      • Applications
      • Application tables
      • Attachments
      • Computers
      • Contexts
      • Custom XSL
      • Database accounts
      • Extracted module names
      • Extracted server objects
      • Flat files
      • Metadata and application data
      • Publication objects
      • Registries
      • Result types
      • Sections
      • Server objects
      • Source variables
        • Recursive substitution in source variables
      • Tags
      • Target variables
      • Tasks
      • Upgrade scripts
        • Processing order
        • Processing mode
        • Script status
    • Delivery Manager basic procedures
      • Archiving an upgrade script
      • Blocking an attachment
      • Comparing data
      • Creating a deploy script
      • Creating a new release
      • Creating a registry
      • Defining a task
      • Defining a task category
      • Dropping a release tree
      • Including an attachment
      • Initialising a release tree
      • Loading deploy samples and added XSL samples
      • Loading registry samples
      • Restoring an upgrade script
      • Reverting to the previous release
      • Running a deploy script
      • Running a task
        • Error handling during run
      • Setting a source variable
      • Setting a target variable
      • Writing an upgrade script
    • Delivery Manager background information
      • DTAP arrangement and environments
      • Folder paths and file paths
        • Special folders
        • Folder management principles
      • Running from flat files or repository
      • Best-practice task design
      • Delivering modules
      • Upgrade
        • Pre-upgrade scripts
        • Create-tables script
          • Customising the create-tables script
        • Post-upgrade scripts
        • Stashing
        • Tips for testing stashing
      • Added XSL
    • XSL sample code
      • Remove log stamps
      • Remove interface objects
      • Copy only owner users
      • Add schema name
    • Delivery Manager actions by name
      • Allow disable constraints
      • Apply custom XSL
      • Check objects
      • Clear and import from TDF
      • Compare data files
      • Copy file
      • Copy folder
      • Create flat files
      • Create folder
      • Create synchronisation file
      • Create tables
      • Drop appdata
      • Drop file
      • Drop folder
      • Drop repository
      • Export all appdata
      • Export deliverable appdata
      • Export metadata
      • Export to TDF
      • Extract module names
      • Extract USoft version
      • Extract servers
      • Fill Authorizer tables
      • Generate create-tables script
      • Generate grants
      • Import appdata
      • Import metadata
      • Mark up text file
      • Mark up XML attribute
      • Populate tables list
      • Publish publication object
      • Release create-tables script
      • Release custom folder
      • Release deliverable appdata
      • Release flat files
      • Release grants
      • Release metadata
      • Release publication
      • Release Rules Service
      • Release scripts
      • Release server
      • Run SQL command
      • Synchronise
      • Update Oracle sequences
      • Validate publication object
  • USoft Windows Designer Guide
    • Introducing Windows Designer
    • GUI applications and templates
      • How to make or change a template's re-use selection
      • Modular Development
        • Calling Windows from Another Module
        • Modular Development of Application Menus
    • Property Sheets
    • Windows
    • Info Boxes
      • Default classes
      • Info Window info box type
      • Lookup Window info box type
      • Related Window info box type
      • Secondary Window info box type
      • Subtype Window info box type
      • Class hierarchy of info boxes
      • Underlying queries
        • Data Synchronization
          • Related Query Statements
          • Example: Grandchild Data Synchronization
        • Joined Columns
        • Extra Queries
    • Dialogs
    • Objects and properties
      • Re-organising objects in a window
      • Tips for positioning objects
      • Controls for Style Sheet option
    • Controls
      • List views
      • Tabs
      • Tree Views
    • Menus
      • Menu Structure Concepts
        • Breadth versus Depth
        • Different Entry Points for Different User Groups
        • State Sensitivity
      • Menus and Menu Options
      • Menu Catalog
        • Menu Class Structure
      • How to Define a Menu Page and its Options
      • How to Translate the Default Window and Help Menu Options
      • How to Duplicate a Menu Page
      • How to Make Menu Options State-Sensitive
      • How to Add a Button to the Toolbar
        • Creating a Bitmap
        • Checking out Which Menu Page and Option to Use
        • Adding the Button's Data to the Menu Option Definition
        • Checking out Authorization
        • Looking at the Result
      • Menu Conditions
      • How to Refresh Menu Definitions
    • Window Sets
    • Scripting in USoft Windows Designer
      • Actions
        • Object Activator
        • User-defined global variables
        • System-defined global variables
        • Target objects in other windows
          • Permanent Window Interaction
            • The Created Window Affects the Calling Window
            • The Calling Window Affects the Created Window
            • Both Windows Affect Each Other
            • Clearing the Reference To a Closed Window
        • Old-style navigation paths
        • Scripting and SQL
          • FORMULA()
        • Actions Example 1: Automatic Query
        • Actions Example 2: Button Opening Related Window
        • Actions Example 3: Button Leading to Tab Page Sensitivity
        • Actions Example 4: Check Box Leading to Tab Page Sensitivity
        • Actions Example 5: Contrasting Field Color Based on Record Data
        • Actions Example 6: Dynamic Default Value
        • Actions Example 7: Passing a Value to Embedded Web Browser
        • Actions Example 8: Automatic Insert in Child Table and Related Box
        • Actions Example 9: Dialog for Search Conditions
          • Search Results Window
          • Search by Start Date Dialog
        • Actions Example 10: Catalog Node Leading to Data Query
          • ReservationsFromCatalog Window
          • Catalog Double-Click Action
        • Actions Example 11: Window with Separate Search Dialog
          • Find Existing Reservations Dialog
          • Reservations Window
        • Actions Example 12: Generic Search Dialog
          • Search Dialog
          • Reservations Window
          • Reservations Child Box
      • Events
        • Interface Events
          • Click Button Event
          • Enter Field Event
          • Leave Field Event
          • Enter Record Event
          • Close Window Event
          • Open Window Event
          • Open Application Event
          • After SetUser Event
          • After Usergroup Changed Event
        • Data Events
          • Lookup-Change Field Event
          • Query-Change Field Event
          • System-Change Field Event
          • User-Change Field Event
          • User-Change Value Event
          • Create Record Event
          • Delete Record Event
          • Fetch Record Event
          • Insert Record Event
          • Update Record Event
          • Commit Transaction Event
          • Receive Database Error Event
          • Rollback Transaction Event
        • When a Record Is Stored
        • Event Order
        • Data Validation Order
        • Data Validation Failure
    • Exports and reports
      • ESI flat file
      • GUI class export
      • Application XML report
    • ActiveX Support in USoft Developer
      • USoft Developer and ActiveX
        • ActiveX Objects in the Windows Designer Catalog
        • How to Insert an ActiveX Object
        • How to Create ActiveX Control Columns
        • ActiveX Control Property Dialogs
        • Using Method Calls with ActiveX Controls
      • USoft Developer and ActiveX: Examples
        • How to Create a Simple Dialog that Contains an ActiveX Control
        • How to Pass Values to and from an ActiveX Object
        • How to Call a Method of an ActiveX Browser Control
        • How to Create an ActiveX Control Column Bound to Base Column Values
    • ESI Action Interface
      • Introduction
        • Differences between the Windows Designer and the ESI Action Interface
      • ESI Object Model
        • ESI Object Model Compared to Other Models
        • Deducing the ESI Object Model from the Layout Model
        • Differences in Referring to Properties and Their Values
        • Implicit Controls vs Explicit Controls
      • Interface Actions
      • Executing ESI Actions
      • Available Actions
        • esi-add-component()
        • esi-add-info-window()
        • esi-add-subclass()
        • esideleteclass()
        • esideletecontrol()
        • esiinsertcontrol()
        • esi-new-application()
        • esi-open-application()
        • esi-save()
        • esi-set-attribute()
        • esi-set-class-property()
        • Notes
        • Frequently Asked Questions
    • Linking Help to Your Application
      • The Default Help
        • External Help File Types
      • How to Open a Help File
      • How to Make Context-Sensitive Help
        • How to Make a HTML Help File Containing Context-Sensitive Topics
        • How to Call Context-Sensitive Help from Objects in Your Application
        • How to Add a Help Button
  • USoft Web Designer Guide
    • Introducing Web Designer
      • Rules-Centred Architecture
      • A Jump Start: The Default Application
      • Development Tasks and Team Members
      • Model-driven, Rapid Application Development
    • Getting started
      • Upgrading to the HTTPS protocol
      • Getting started with IIS and COM+
    • Understanding the Development environment
    • Defining your web application with USoft Definer
      • Default application
      • Default menu
      • Default Info Pages
      • Default Lookup Buttons
      • Default Lookup Pages
      • Default Related Pages
      • Customising default web pages
      • Translating your application
        • How to translate application strings
        • How to add translation for the borrowed strings
        • How to translate system messages
        • How to specify the language with which to run the application
    • Customising your web application with USoft Web Designer and CSS
      • Design-time tooling
        • The Web Designer tool interface
        • The Catalog
        • The Preview Pane
        • The Object Tree
        • The Property Inspector
        • The Find in Repository dialog
      • Basic design operations
        • How to open a page from the Catalog
        • How to open the Property Inspector
        • How to set properties With the Property Inspector
        • How to reset properties
        • How to add a control to a page
        • How to remove a control from a page
        • How to access Web Designer property help
        • How to change the prompt or label of an object
        • How to make fields non-displayed
        • How to Include an Image
      • Design-time structure
        • The object containment hierarchy
        • The class inheritance hierarchy
        • Container controls
          • How to group objects in a container
          • How to change the orientation of objects in a container
          • How to change the order of objects in a container
      • Pages
        • Page chaining
        • Page stacking
        • How to add a navigation path to a page
        • How to embed a page in another page
      • Layout areas
      • Column controls and input controls
        • Input controls by type
        • Replicated Columns Control
      • Data sources
        • Embedded data sources
        • Data source path syntax
        • Life time data source property
        • How to define a Related Data Source
        • How to define a Lookup Data Source
        • How to insert a user-defined data source
        • How to define a Variable Set Data Source
      • Page and data source constructs
        • Pattern 1: Search-and-results on single page
        • Pattern 2: Search-and-results across two pages
        • Pattern 3: Save-and-confirm across two pages
        • Pattern 4: Master-detail form on a single page
        • Pattern 5: Master-detail on separate search and edit pages
        • Pattern 6: Re-used embedded page
        • Pattern 7: Customised lookup page
        • Pattern 8: Convert lookup page to dropdown list
        • Pattern 9: Classic joined column
      • Scripting with data sources
        • The DefaultDataSource placeholder
        • The getDataSourceAlias placeholder
        • The getMainDataSourceAlias placeholder
        • The getThisDataSourceAlias placeholder
        • The getSearchValue placeholder
        • The getValue placeholder
        • The getWhereClause Placeholder
        • The getSelection Placeholder
        • The getExpression Placeholder
      • SQL statements
      • SQL-related properties
        • Limiting search results
        • Limiting the number of records retrieved by a query
        • Grouping search results
        • Sorting search results
        • Querying data when a page is opened
      • Tree controls and tree node controls
        • TreeControl
        • TreeNodeControl
      • Grid controls
        • Record Identification and counting in grid (edit) controls
      • Dialog controls
        • Lookup dialogs
      • Cascading Style Sheets (CSS)
        • Stylesheet rules
        • How to define CSS stylesheet rules in USoft
        • Selectors in stylesheet rules
          • HTML Elements as selectors
          • Web Designer classes as selectors
          • Web Designer domain classes
            • How to add domain classes to the default class list
            • Where to use domain classes
          • Web Designer IDs as selectors
          • Contextual selectors
          • The style property specifying a CSS inline style
        • Example: The BODY element
        • Example: The DIV element
        • Example: The ButtonControl class
        • Example: The InputControl class
        • Example: Highlighting mandatory fields
        • Record colouring in grid controls and grid edit controls
        • Reusing existing style sheets
          • How to Set the Class List or Id of an Object
          • How to Set the Default Class of an Object
          • Example: Setting a CSS Property For a Group of Objects
          • Example: Attaching One Control to Multiple CSS Classes
      • Web menus
        • Web menus quick start
        • Reverting to the default menu
        • Defining a menu
        • Displaying a menu in your application
        • Adding authorisation to menus
        • Menu design issues
        • Menu ESI class structure
        • How to use images in web menus
        • How to execute a JavaScript function from a web menu
        • How to Include a non-clickable web menu Item
        • Location of files that affect menus
        • Sharing menu pages and controls between repositories
      • Messages
        • How to Include a Message Area
      • Sharing catalog items
      • How to display data as hyperlink
      • Setting a variable set with the URL protocol
      • How to make a page read-only
    • Finishing your web application with JavaScript
      • AJAX technology
      • Scripting example 1: The period case
      • Scripting example 2: Client check on a mandatory field
      • Script scope
        • How to add a script to the application
        • How to add a script to a page
        • How to add a script to an object
      • Events and actions
        • Event listeners and actions
        • How to insert an event listener
        • How to Insert an action
        • How to change the parameters of an action
      • Calling Info Pages with URL query parameters
        • Special characters in URL query parameters
      • Host variables
      • The caller keyword
    • Testing your web application with USoft Web Benchmark
      • Introducing USoft Web Benchmark
      • Getting started with Web Benchmark
      • The Web Benchmark control
      • Web Benchmark control properties
      • Recording and playback
        • Recording a test
        • Playing a test
        • Pausing a recording
        • Stopping a recording
        • Invoking a test
        • Delaying a test
        • Using variables in a test
        • Editing a test
          • Identifying the target control of an action
      • Profiler
        • Running the profiler for a test
        • Viewing test runs of a test
        • Overview of test runs
        • Comparisons
      • Test management
        • Selecting a test
        • Saving a test
        • Managing tests
        • Web Benchmark settings
      • Test automation with Web Benchmark
      • Reference section
        • Recordable actions
          • assert
          • assertEquals
          • assertNotSame
          • click
          • clickButton
          • clickRow
          • comment
          • delay
          • gotoDataSet
          • invoke
          • message
          • navigateMenu
          • navigateToLookup
          • nextDataSet
          • previousDataSet
          • script
          • setValue
          • test
        • Target control properties common to multiple actions
    • Publishing your web application
      • The Web Designer stack
      • Web publications
        • Published JSON files
        • Published XML Files
        • Published server Pages (ASP or JSP Files)
        • Published global.asax File
        • Cascading style sheets (CSS)
          • The CustStyle style sheet
          • The WRClasses style sheet
          • The XSLSource style sheet
        • The Combined.xml file
      • Active web browsers
        • The "application.html" initial document
        • Contexts
        • Client sessions
        • Frameworks
        • Supported browser versions
      • Authentication
        • Authentication for client/server applications
        • Authentication for web applications
        • The validation agent for a web application user
        • Web server validation of credentials
        • Web application validation of credentials
      • Publication Configurations
        • The Publication Configuration window
        • Publication attributes
        • System-defined publication properties
        • User-defined publication properties
        • Referring to publication settings
      • Publishing and page management
        • Page Sets
        • How to define a Page Set
        • Page states
        • How to create a new publication configuration
        • How to publish pages
        • How to change an existing publication configuration
        • How to apply a different jQuery theme
        • The Alternative Template Folder
    • Running your web application
    • Reference section
      • USoft DB (UDB) library
        • udb function object
          • udb()
          • .acceptLookupValue()
          • .cancelWindow()
          • .checkData()
          • .checkVersion()
          • .clearGenericHostVars()
          • .closePage()
          • .commit()
          • .currentPageName()
          • .currentPageNavigationSource()
          • .currentPageStackDepth()
          • .executeInContext()
          • .executeSQLStatement()
          • .genericHostVar()
          • .getContext()
          • .getMenu()
          • .groupRequests()
          • .hostvars
          • .isCommitted()
          • .isTransactionChecked()
          • .login()
          • .logout()
          • .mainPageName()
          • .navigateTo()
          • .navigateToLookup()
          • .navigateToRelated()
          • .off()
          • .on()
          • .ping()
          • .rollback()
          • .setTimeOut()
          • .settings
          • .showLogin()
          • .status.loggedIn()
          • .status.logonRequired()
          • .trigger()
        • udbMeta function object
          • udbMeta()
          • .alias()
          • .children()
          • .cols()
          • .currentDataSet()
          • .dataSetSize()
          • .each()
          • .hasChild()
          • .hasCount()
          • .hasLookup()
          • .id()
          • .initialState()
          • .isAutoQuery()
          • .isDefault()
          • .isDeletable()
          • .isDistinct()
          • .isFirstRecordDefaultSelected()
          • .isInsertable()
          • .isJoined()
          • .isLookup()
          • .isOnEmbeddedPage()
          • .isUpdatable()
          • .joins()
          • .keyCols()
          • .lifeTime()
          • .lookupRefs()
          • .lookups()
          • .name()
          • .orphanDataSource()
          • .pageAlias()
          • .parents()
          • .path()
          • .realDataSource()
          • .relations()
          • .sortOrder()
          • .table()
          • .type()
        • DataSourceContainer object
          • .clear()
          • .clearQuery()
          • .createRowSet()
          • .each()
          • .embeddedKeyCols()
          • .executeQuery()
          • .getDataSet()
          • .gotoDataSet()
          • .meta()
          • .off()
          • .on()
          • .refresh()
          • .rowCount()
          • .rowCreate()
          • .rows()
          • .rowSet()
          • .searchCols()
          • .setQueryHook()
          • .trigger()
        • Rowset object
          • .clear()
          • .dataSet()
          • .dataSetIndicator()
          • .dbCount()
          • .each()
          • .execute()
          • .gotoDataSet()
          • .indexOf()
          • .isEmpty()
          • .isQueried()
          • .keysString()
          • .keyValues()
          • .numberOfDataSets()
          • .position()
          • .range()
          • .rowCount()
          • .rows()
          • .select()
          • .sort()
        • Rows object
          • .cols()
          • .each()
          • .filter()
          • .index()
          • .isInserted()
          • .joinedVal()
          • .keys()
          • .keysString()
          • .keysXML()
          • .mark()
          • .mark( value )
          • .refresh()
          • .rowDelete()
          • .rowId()
          • .rowRemove()
          • .select( options )
          • .select( "multiple" )
          • .select( "multiple", value )
          • .status()
          • .values()
        • ColsMeta object
          • .alias()
          • .altInputFormats()
          • .defValue()
          • .displayLength()
          • .domain()
          • .getForeignKey()
          • .ioFormat()
          • .isEmbeddedColumn()
          • .isGroupBy()
          • .isInputAllowed()
          • .isKey()
          • .isMandatory()
          • .isPrimaryKey()
          • .isUpdatable()
          • .label()
          • .name()
          • .sortOrder()
          • .type()
          • .valueList()
        • Cols object
          • .clear()
          • .each()
          • .meta()
          • .rawVal()
          • .val()
        • UDB other functions
          • .title()
          • .wait()
        • Data Source Path Syntax Reference
      • USoft UI library
        • GUI elements (controls)
          • Factories
            • Creating a New Control Factory
            • Changing an Existing Control Factory
            • Factory Members
          • Handlebars
            • attr helper
            • data helper
            • lang helper
            • now helper
            • preview helper
            • rule helper
            • Escaping handlebars
          • Render
          • Events
        • Field validation
        • Localisation
          • .getLanguage()
          • .setLanguage()
          • .transform()
      • Events reference
        • Top-level events
          • before... events
          • postcommit event
          • timeout event
        • Data source events
          • colpreupdate event
          • colpostupdate event
          • dataset event
          • rowquery event
          • rowselect event
          • before... and rowpre... events
        • Control events
          • lookup event
          • value event
        • Custom events
      • USoft 8 functions (Obsolete)
        • acceptLookupValue()
        • callClientScript()
        • cancelWindow()
        • checkData()
        • clearQueryConditions()
        • closePage()
        • commit()
        • createRecord()
        • deleteRecord()
        • executeQuery()
        • executeSQLStatement()
        • getDataSet()
        • getRecordCount()
        • getSearchValue()
        • getTotalNrOfDataSets()
        • getTotalNrOfRecords()
        • getValidateValuesResult()
        • gotoDataSet()
        • handleEvent()
        • login()
        • logout()
        • navigateTo()
        • navigateToLookup()
        • navigateToRelated()
        • nextDataSet()
        • nextRecord()
        • previousDataSet()
        • previousRecord()
        • refresh()
        • refreshRecord()
        • rollback()
        • setFrameURL()
        • setSearchValue()
        • setValue()
        • submitUserAndPassword()
        • uwa.groupRequests()
        • validateValues()
  • USoft Service Definer Guide
    • Introducing USoft Service Definer
      • Introducing the USoft Services Platform
      • Technologies Used in USoft REST
    • Getting Started: Quick Walk-Through
    • USoft Service Definer Objects
      • Servers
        • Server properties
        • Server administration settings
        • Server security settings
        • Extending your response when a request is throttled
      • Applications
        • Defining an application
      • Connections
        • Defining a connection
        • Multiple connections and Rules Services
      • Services
        • REST Services
        • SOAP Services
        • WebSocket Services
          • USoft Default Web Socket Provider
          • Example: USoft Default Web Socket Provider for a Chat application
        • Services (Other)
          • Queue Services
      • Classes
      • Structures
        • Deriving structures from SQL statements or tables
      • SQL statements
      • Functional types
        • Default functional types
        • Custom functional types
          • Example: Reservation event functional type
          • Example: Custom authorization for REST services
      • Annotations
      • CORS configurations
      • File resources
    • Using predefined REST services
      • Getting table and column Information with USoft Table Resource
      • Retrieving data with USoft Table Resource
      • Adding data with USoft Table Resource
      • Updating data with USoft Table Resource
      • Deleting data with USoft Table Resource
      • Calling a batch job with USoft Job Resource
      • URL query parameters in predefined REST Services
      • Versioning predefined REST services
    • Creating your own services
      • Creating REST services
        • Designing a REST service
        • Defining a REST service
          • Defining REST methods
          • Defining input parameters
            • Input parameters in the URL path
            • Input parameters in the URL query string
            • Input parameters as matrix parameters
            • Input parameters as HTTP headers
          • Defining request messages
          • Defining response messages
          • Defining error handling
          • Limiting the number of records returned by a REST service
        • Generating a REST service from SQL
          • Example: a REST service for retrieving data (SELECT)
          • Example: a REST Service for adding new data (INSERT)
          • Example: a REST Service for manipulating data (UPDATE)
          • Example: a REST Service for returning manipulated data
          • Example: a REST Service for deleting data (DELETE)
      • Creating SOAP services
        • Designing a SOAP service
          • Choosing a SOAP service type
        • Defining a SOAP service
          • Defining SOAP methods
      • Java interface for USoft Service Definer
        • Utility functions for USoft Default Providers
          • openConnection()
          • sql() 
            • Java output classes returned by Sql()
          • getWarning()
          • logout()
        • Utility functions for general use
          • USoftService object
            • USoftService example code
        • Deprecated functions, classes and methods
    • Organising services
      • Designing service-specific interfaces
      • Modular service (REST, SOAP) development
      • Versioning custom REST services
      • Pagination of custom REST services
    • Exposing REST services
    • Calling a REST service without committing
    • Event processing
      • Design patterns for event processing
        • Synchronous input processing with synchronous result
        • Synchronous input processing with asynchronous result
        • Asynchronous input processing with synchronous result
        • Asynchronous input processing with asynchronous result
      • Event processing best practices in USoft
        • Model
        • Rules
        • Error handling
        • Logging for monitoring
      • Receiving events
        • Example: REST service that receives events asynchronously
      • Handling events
        • Example: Job that processes queued input events
        • Example: Queue service that processes input events
      • Producing events
        • Example: Model and rules for creating output events
        • Example: Job that processes queued output events
        • Example: Queue service that processes output events
    • Configuration
      • Server configuration
        • Config element
        • Server element
        • Authenticator element
        • Properties element
        • Services element
        • HttpProtocol element
        • Connections element
        • Cors element
      • Security configuration
        • SecurityConfig element
        • KeyStore element
        • SamlSP element
        • Attributes element
        • Info element
        • EncryptionKey element
        • SigningKey element
      • Log configuration
      • Multi-tenancy
    • Security
      • Authentication
        • USoft authentication
        • SAML authentication
        • Anonymous authentication
        • Cookie-based authentication
        • Authentication matrix
        • Discarding a session
    • Other topics
      • Logging and tracing servers, services and classes
  • USoft Rules Service Guide
    • Introducing the USoft Rules Service
    • Getting Started with USoft Rules Services
    • Configuring a Rules Service
    • Starting a Rules Service
    • Peer Rules Services
    • Setting up a Rules Service log file
    • Debugging a Rules Service
    • Recovering a Rules Service
    • Uninstalling a Rules Service
    • Connecting to a Rules Service via HTTP
      • Rules Service SOAP error messages
      • Rules Service SOAP success messages
    • Methods supported by the Rules Service
  • USoft BenchMark Guide
    • Introducing USoft Benchmark
      • Fully Automated Testing
      • Recorder
      • Player
      • Wizard (BenchMark)
      • Profiler
      • Tracer
      • Test Procedures
      • Test Procedure Editing
      • Test Checks
        • Status Checks
        • Procedure Checks
        • Property Step Checks
        • Note Step Checks
      • Test Data Management
      • Automating the Maintenance of Test Data
    • Reasons for SQL Statements
    • Violation Reports
      • Constraint Violation Report Structure
      • Report Configurations
    • BenchMark Guidelines
      • Resident Cache
      • Transaction Performance
      • Ignoring Import Errors
    • Using USoft BenchMark
      • How to Create the USoft BenchMark Repository
      • Starting USoft BenchMark
        • How to Start USoft BenchMark together with Your Application
        • How to Start USoft BenchMark from within Your Application
        • How to Start USoft BenchMark from the USoft Binder
      • How to Generate a Test Procedure with the Wizard
      • How to Record a Test Procedure
        • How to Record a Subprocedure
        • How to Record a Property Step Check
        • How to Record a Note
      • How to Define a Test Keyword
      • How to Edit a Test Procedure
      • How to Use External File Data within a Test Procedure
      • How to Define a Test
      • How to Play a Test
        • How to Inspect the Log Files from Previous Tests
      • How to Play a Test at Application Startup
      • Interpretation of Profiles
        • Test Profiles
        • Profile Groups
        • Preparing a Profile
        • Execution Elements
        • Execution Tree
        • SQL Statements Grouped by Source
        • Manipulations
        • View on Manipulation
        • Manipulation Tree
        • Statistics
        • Index Hints
          • How to Obtain Index Hints from the Test Database
          • How to Obtain Index Hints via the Test Profiles Window
      • Using Profiles
        • How to Make a Profile of Interactive User Actions
        • How to Make a Profile while Playing a Test
        • How to Make a Profile using the Stand-alone Profiler for Batch Jobs
          • For example
        • How to Make a Profile using the Stand-alone Profiler from Within Another Application
      • Tracing SQL Statements and Method Calls
        • Tracer Window: Tracer Tab Page
        • Tracer Window: Options Tab Page
        • How to Trace SQL Statements and Method Calls
      • How to Maintain Application Data for Test Purposes
        • How to Automate the Maintenance of Test Data
        • How to Drop Undefined Tables and Sequences
      • Using Violation Reports
        • How to Create a Report Configuration
        • How to Exclude a Constraint from a Violation Report
        • How to Exclude a Relationship from a Violation Report
        • How to Create a Violation Report on Relationships or Constraints
        • How to Create a Column Violation Report
        • How to View a Violation Report on Relationships or Constraints
  • USoft Remote Rules Service API Guide
    • Introducing USoft Remote Rules Service API
    • How the USoft Remote Rules Service API Works
      • Data Sources
    • Configuring the USoft Remote Rules Service API
      • Introduction
      • How to Configure a User or System Data Source (Microsoft Windows Platforms)
      • How to Configure a File Data Source (Microsoft Windows Platforms)
        • How to Define Additional Data Sources
        • Setting Up a Connection in Applications
    • Troubleshooting
      • Error Messages
        • ODBC 3.5 Components
    • ODBC Reference
      • Supported ODBC Functions
      • Supported SQL
      • ODBC Conformance
      • ODBC Error Messages
      • Online Documentation
      • Additional Information
    • ADO
      • ADO
        • ADO Architecture
        • Product Requirements for using ADO with USoft
        • Setting Up the ADO - USoft environment
        • Scripting an Application Using ADO
      • Examples
        • Salary Increase from a Visual Basic Script
        • Tour Reservation from Active Server Pages
    • The Remote Rules Service Configuration Dialog
      • The Remote Rules Service Configuration Dialog
        • Data Source Name (ODBC)
        • Data Source Description (ODBC)
        • Application Name (ODBC)
        • Hostname or IP
        • Port
        • Use TLS
        • User/Password
        • Timeout
        • Single Record Fetch
        • Tracing
  • USoft Installation Guide
    • Installation Overview
    • Installing the database product
    • Installing USoft product components
      • Development environment
        • Installing USoft Developer
        • Installing a USoft Development repository
          • Creating USoft Authorizer tables
          • Creating USoft Definer tables
          • Creating USoft Benchmark tables
          • Creating USoft Service Definer tables
          • Creating USoft Delivery Manager tables
          • Authorising team members
      • Production environment
        • USoft Production
        • User Application
        • USoft application tables
        • Installing your application on a server
        • Running applications in the Production environment
      • Configuring IIS for USoft
      • Installing the USoftComJavaCall component
      • Shutting down the USoftComJavaCall component
      • Installing a USoft Rules Service
      • Silent installation
      • Log files and temporary files
      • USAPI.DLL
    • USoft license management
      • Terminology used in license management
      • Installing a Server-based license
        • How to start and stop the license daemon
        • How to start and stop the license server as an NT service:
      • Installing an evaluation license
      • Replacing a license file
      • Checking the licensed USoft products
      • Troubleshooting license problems
      • FLEX license management software
        • Three-server redundant license servers
        • Server node configuration
        • Generating a license file for redundant servers
          • Example
    • Uninstalling USoft product components
      • Uninstalling the USoftComJavaCall Component
      • Uninstalling a USoft Rules Service
      • Uninstalling USoft Developer
    • Software requirements
    • Hardware requirements
    • RDBMS Requirements
      • Oracle requirements
      • ODBC requirements
      • Microsoft SQL Server requirements
  • USoft Upgrade Guide
    • Upgrading the Development Environment to USoft 9.1
      • Step 1: Backup
      • Step 2: Violation reports of source repository
      • Step 3: USoft 9.1 installation
      • Step 4: Action list
      • Step 5: Upgrade procedure
      • Step 6: Violation reports of target repository
      • Step 7: Test
      • Violation reports during upgrade
    • Upgrading the Production Environment to USoft 9.1
  • USoft Blend Guide
    • Introducing USoft Blend
      • Getting started with USoft Blend
      • USoft Blend scripts
      • How a USoft Blend script is processed
    • Understanding the USoft Blend architecture
      • USoft set processors
      • The USCSXSL internal component
    • Calling USCSXSL
      • Calling USCSXSL from a USoft context to apply a named transformation
      • Calling USCSXSL from a USoft context as a Blend script processor
      • Calling USCSXSL from the command line as a Blend script processor
      • Blend input parameters
    • Guide to expressions and data types
      • Literal expressions
        • Date literals
        • String literals
      • Path expressions
      • XML expressions
        • Embedded XML
      • XPath expressions
        • Node set expressions
        • Booleans
        • Strings
        • Numbers
        • Function calls
        • Variable references
        • Implicit XPath datatype conversion
        • Evaluated expressions vs. literals
      • SQL expressions
    • Guide to syntax descriptions
    • Directives
      • Debugging
        • pc:message
      • Dialogs
        • pc:Dialog
          • Button
          • CheckBox
          • ComboBox
          • FileButton
          • FolderButton
          • Form
          • Label
          • Panel
          • Picture
          • RadioButton
          • Result
          • TextBox
          • Title
      • File system
        • pc:CopyDirectory
        • pc:CopyFile
        • pc:CopyFileOverwrite
        • pc:CreateDirectories
        • pc:DeleteDirectories
        • pc:DeleteFile
        • pc:Directory
          • Looping over a set of files or directories
        • pc:MoveFile
        • pc:MoveFileOverwrite
      • Files
        • pc:AppendFile
        • pc:ReadFile
        • pc:ReadFiles
        • pc:ReadXmlFile
        • pc:ReadXmlFiles
        • pc:WriteFile
      • Instant repositories
        • pc:DatabaseExists
        • pc:DropDatabase
        • pc:NewBinder
        • pc:NewDatabaseForUSoft
        • pc:NewUDevelop
        • pc:Usd
      • Messages and error handling
        • pc:ConsoleWrite
        • pc:Failed
        • pc:msg
        • pc:Succeeded
        • pc:terminate
        • pc:textmsg
      • Operating system
        • pc:PowerShell
        • pc:ProgramSystemDir
        • pc:ServiceInstall
        • pc:ServiceList
        • pc:ServiceStart
        • pc:ServiceState
        • pc:ServiceStop
        • pc:ServiceUninstall
        • pc:SetEnvVarDefault
        • pc:SetEnvVarOverwrite
        • pc:UserTempDir
        • pc:WinCommand
      • Output control
        • pc:comment-of
        • pc:copy-of
        • pc:hideme
        • pc:ignorewhitespace
        • pc:indent
        • pc:indentchars
        • pc:nbs
        • pc:newline
        • pc:non-breaking-space
        • pc:processing-instruction
        • pc:return
        • pc:tab
        • pc:text
        • pc:value-of
      • RDBMSs
        • pc:RdbmsQuery
        • pc:RdbmsStatement
        • pc:SqlServerInstances
        • SQL command line tools via pc:PowerShell
      • Repository manager
        • pc:Compare
        • pc:Creapp
        • pc:CreateConceptualFile
        • pc:GenerateKeySchema
        • pc:SqlStatement
        • pc:XmlExport
        • pc:XmlImport
        • pc:XmlImportApply
        • pc:ValidateSchemas
      • Rules Services
        • pc:ConfigRulesService
          • Choosing a port number for a Rules Service
          • Configuring a Rules Service on the basis of an existing file
          • Manual Rules Service configuration
        • pc:GetConnections
        • pc:GetRulesEngineProperty
        • pc:RulesServiceList
        • pc:RunRulesService
        • pc:SetRulesEngineProperty
        • pc:SetRulesServiceConnection
        • pc:StopRulesService
        • pc:USoftSystemDir
        • pc:USoftTempDir
      • Script control
        • pc:call
        • pc:case
        • pc:default
        • pc:defs
        • pc:each
        • pc:else
        • pc:evaluate
        • pc:if
        • pc:if-not-then
        • pc:if-then
        • pc:switch
        • pc:terminate
        • pc:then
        • pc:void
      • Tools and utilities
        • pc:apply
        • pc:apply2file
        • pc:ConvertFormatAndCulture
        • pc:JsonToXml
        • pc:ReplaceVariables
          • Passing input parameters to the replacement routine
      • Variables
        • assign:variable
        • pc:assign-boolean
        • pc:assign-boolean-default
        • pc:assign-nodeset
        • pc:assign-nodeset-default
        • pc:assign-number
        • pc:assign-number-default
        • pc:assign-string
        • pc:assign-string-default
        • pc:assign-var
        • pc:assign-var-default
        • pc:define-boolean-flags
        • pc:GetVariables
        • pc:LoadVariables
        • pc:LoadVariablesOverwrite
        • pc:SaveVariables
      • ZIP compression
        • pc:ZipExtractFiles
        • pc:ZipFile
        • pc:ZipFileCreate
        • pc:ZipFileCreateFromDir
        • pc:ZipFileEntry
        • pc:ZipReplace
        • pc:ZipUpdate
    • Directives by name
      • assign:variable
      • pc:AppendFile
      • pc:apply
      • pc:apply2file
      • pc:assign-boolean
      • pc:assign-boolean-default
      • pc:assign-nodeset
      • pc:assign-nodeset-default
      • pc:assign-number
      • pc:assign-number-default
      • pc:assign-string
      • pc:assign-string-default
      • pc:assign-value
      • pc:assign-value-default
      • pc:assign-var
      • pc:assign-var-default
      • pc:call
      • pc:case
      • pc:comment-of
      • pc:Compare
      • pc:ConfigRulesService
      • pc:ConsoleWrite
      • pc:ConvertFormatAndCulture
      • pc:CopyDirectory
      • pc:CopyFile
      • pc:CopyFileOverwrite
      • pc:copy-of
      • pc:Creapp
      • pc:CreateConceptualFile
      • pc:CreateDirectories
      • pc:DatabaseExists
      • pc:default
      • pc:define-boolean-flags
      • pc:defs
      • pc:DeleteDirectories
      • pc:DeleteFile
      • pc:Dialog
      • pc:Directory
      • pc:DropDatabase
      • pc:each
      • pc:else
      • pc:evaluate
      • pc:Failed
      • pc:GenerateKeySchema
      • pc:GetConnections
      • pc:GetRulesEngineProperty
      • pc:GetVariables
      • pc:hideme
      • pc:if
      • pc:if-not-then
      • pc:if-then
      • pc:ignorewhitespace
      • pc:indent
      • pc:indentchars
      • pc:JsonToXml
      • pc:LoadVariablesDefault
      • pc:LoadVariablesOverwrite
      • pc:message
      • pc:MoveFile
      • pc:MoveFileOverwrite
      • pc:msg
      • pc:nbs
      • pc:NewBinder
      • pc:NewDatabaseForUSoft
      • pc:newline
      • pc:NewUDevelop
      • pc:non-breaking-space
      • pc:PowerShell
      • pc:processing-instruction
      • pc:ProgramSystemDir
      • pc:RdbmsStatement
      • pc:ReadFile
      • pc:ReadFiles
      • pc:ReadXmlFile
      • pc:ReadXmlFiles
      • pc:ReplaceVariables
      • pc:return
      • pc:RulesServiceList
      • pc:RunRulesService
      • pc:SaveVariables
      • pc:ServiceInstall
      • pc:ServiceList
      • pc:ServiceStart
      • pc:ServiceState
      • pc:ServiceStop
      • pc:ServiceUninstall
      • pc:SetEnvVarDefault
      • pc:SetEnvVarOverwrite
      • pc:SetRulesEngineProperty
      • pc:SetRulesServiceConnection
      • pc:SqlServerInstances
      • pc:SqlStatement
      • pc:StopRulesService
      • pc:Succeeded
      • pc:switch
      • pc:tab
      • pc:terminate
      • pc:text
      • pc:textmsg
      • pc:then
      • pc:Usd
      • pc:UserTempDir
      • pc:USoftSystemDir
      • pc:USoftTempDir
      • pc:value-of
      • pc:void
      • pc:WinCommand
      • pc:WriteFile
      • pc:XmlExport
      • pc:XmlImport
      • pc:XmlImportApply
      • pc:ZipExtractFiles
      • pc:ZipFile
      • pc:ZipFileCreate
      • pc:ZipFileCreateFromDir
      • pc:ZipFileEntry
      • pc:ZipReplace
      • pc:ZipUpdate
    • Functions
      • booleanflags:Show
      • booleanflags:ToBoolean
      • clipboard:GetText
      • dates:ShowInputFormats
      • directories:DirectoryContent
      • directories:Get
      • environment:MachineName()
      • files:XmlFile
      • oracle:USoftConnectString
      • path:Combine
      • path:GetFullPath
      • rulesservice:ReadConfig
      • service:ServiceState
      • sql:DataTableSetExport
      • sql:SqlStmnt
      • strings:Aposssed
      • strings:EndsWith
      • strings:join
      • strings:Quoted
      • strings:ReplaceVariables
      • strings:StartsWith
      • strings:StartsWithIgnoreCase
      • strings:Text2Xml
      • strings:TitleCase
      • strings:ToLower
      • strings:ToUpper
      • variable:IsDefined
      • variable:Set
      • variable:TypeOf
      • wrights:HasAdminRole
      • xslutil:applyTemplate
      • xslutil:nodeset
      • xslutil:test
      • xslutil:UserTempDir
      • xslutil:USoftDir
    • Resources
    • Obsolete entries
      • pc:assign
      • pc:assign-default
      • pc:assign-value
      • pc:assign-value-default