Index U

User ID connection parameter

UID connection parameter: UltraLite

ULActiveSyncStream function: setting synchronization stream

ULConduitStream function: setting synchronization stream

ulgen utility: syntax

The UltraLite generator

ULHTTPSStream function: setting synchronization stream

UlHTTPSStream object: Java synchronization stream

ULHTTPStream function: setting synchronization stream

UlHTTPStream object: Java synchronization stream

Security Parameters synchronization parameter

ULSecureCerticomTLSStream function: security

ULSecureCerticomTLSStream: about

Security synchronization parameter

UlSecureRSASocketStream object: parameters

UlSecureRSASocketStream synchronization parameters

ULSecureRSATLSStream function: security

Security Parameters synchronization parameter

ULSecureRSATLSStream: about

Security synchronization parameter

UlSecureSocketStream object: Java synchronization stream

ULSocketStream function: setting synchronization stream

UlSocketStream object: Java synchronization stream

MobiLink synchronization features

UltraLite Component Suite Foundations: MobiLink synchronization

UltraLite Component Suite Foundations: Synchronizing UltraLite applications

Introduction

UltraLite Component Suite Foundations: The UltraLite Schema Painter

The UltraLite Schema Painter

UltraLite Component Suite Foundations: The ULXML command line utility

The ULXML utility

UltraLite Component Suite Foundations: user authentication

Developing UltraLite applications

UltraLite Component Suite: architecture

UltraLite Component Suite: features

UltraLite benefits

UltraLite components: about

Introduction

UltraLite components: development process

Developing applications with UltraLite components

UltraLite connection parameters: about

Specifying connection parameters

UltraLite databases: encrypting

Encrypting UltraLite databases

UltraLite databases: introduction

UltraLite databases
Databases and schema files

UltraLite databases: schema

Introduction to UltraLite utilities

UltraLite databases: storage

UltraLite database files

UltraLite databases: user IDs

File locations for the sample application

UltraLite directory: defined

UltraLite documentation: using

Using the UltraLite documentation

UltraLite generator: defined

Generating the UltraLite data access code

UltraLite generator: introduction

Generating the UltraLite data access code

UltraLite generator: syntax

The UltraLite generator

UltraLite initialization utility: about

The UltraLite initialization utility

UltraLite initialization utility: UltraLite Component Suite Foundations

The UltraLite initialization utility

UltraLite passwords: about

Creating an UltraLite project

UltraLite project creation wizard: using

UltraLite projects: about

Creating an UltraLite project

UltraLite projects: adding statements to

Adding SQL statements to an UltraLite project

UltraLite runtime library: about

The UltraLite runtime library

UltraLite Schema Painter: managing schemas

Managing schema files

UltraLite segment utility: syntax

The UltraLite segment utility

UltraLite SQL functions: ABS function syntax

UltraLite SQL functions: ACOS function syntax

UltraLite SQL functions: ARGN function syntax

UltraLite SQL functions: ASCII function syntax

UltraLite SQL functions: ASIN function syntax

UltraLite SQL functions: ATAN function syntax

UltraLite SQL functions: ATAN2 function syntax

UltraLite SQL functions: ATN2 function syntax

UltraLite SQL functions: AVG function syntax

UltraLite SQL functions: BYTE_LENGTH function syntax

UltraLite SQL functions: BYTE_SUBSTR function syntax

UltraLite SQL functions: CAST function syntax

UltraLite SQL functions: CEILING function syntax

UltraLite SQL functions: CHAR function syntax

UltraLite SQL functions: CHARINDEX function syntax

UltraLite SQL functions: CHAR_LENGTH function syntax

UltraLite SQL functions: COALESCE function syntax

UltraLite SQL functions: CONVERT function syntax

UltraLite SQL functions: COS function syntax

UltraLite SQL functions: COT function syntax

UltraLite SQL functions: COUNT function syntax

UltraLite SQL functions: DATALENGTH function syntax

UltraLite SQL functions: DATE function syntax

UltraLite SQL functions: DATEADD function syntax

UltraLite SQL functions: DATEDIFF function syntax

UltraLite SQL functions: DATEFORMAT function syntax

UltraLite SQL functions: DATENAME function syntax

UltraLite SQL functions: DATEPART function syntax

UltraLite SQL functions: DATETIME function syntax

UltraLite SQL functions: DAY function syntax

UltraLite SQL functions: DAYNAME function syntax

UltraLite SQL functions: DAYS function syntax

UltraLite SQL functions: DEGREES function syntax

UltraLite SQL functions: DIFFERENCE function syntax

UltraLite SQL functions: DOW function syntax

UltraLite SQL functions: EXP function syntax

UltraLite SQL functions: EXPRTYPE syntax

UltraLite SQL functions: FLOOR function syntax

UltraLite SQL functions: GETDATE function syntax

UltraLite SQL functions: GREATER function syntax

UltraLite SQL functions: HEXTOINT function syntax

UltraLite SQL functions: HOUR function syntax

UltraLite SQL functions: HOURS function syntax

UltraLite SQL functions: IFNULL function syntax

UltraLite SQL functions: INSERTSTR function syntax

UltraLite SQL functions: INTTOHEX function syntax

UltraLite SQL functions: ISDATE function syntax

UltraLite SQL functions: ISNULL function syntax

UltraLite SQL functions: LCASE function syntax

UltraLite SQL functions: LEFT function syntax

UltraLite SQL functions: LENGTH function syntax

UltraLite SQL functions: LESSER function syntax

UltraLite SQL functions: LIST function syntax

UltraLite SQL functions: LOCATE function syntax

UltraLite SQL functions: LOG function syntax

UltraLite SQL functions: LOG10 function syntax

UltraLite SQL functions: LOWER function syntax

UltraLite SQL functions: LTRIM function syntax

UltraLite SQL functions: MAX function syntax

UltraLite SQL functions: MIN function syntax

UltraLite SQL functions: MINUTE function syntax

UltraLite SQL functions: MINUTES function syntax

UltraLite SQL functions: MOD function syntax

UltraLite SQL functions: MONTH function syntax

UltraLite SQL functions: MONTHNAME function syntax

UltraLite SQL functions: MONTHS function syntax

UltraLite SQL functions: NEWID function syntax

UltraLite SQL functions: NOW function syntax

UltraLite SQL functions: NULLIF function syntax

UltraLite SQL functions: PATINDEX function syntax

UltraLite SQL functions: PI function syntax

UltraLite SQL functions: POWER function syntax

UltraLite SQL functions: QUARTER function syntax

UltraLite SQL functions: RADIANS function syntax

UltraLite SQL functions: REMAINDER function syntax

UltraLite SQL functions: REPEAT function syntax

UltraLite SQL functions: REPLACE function syntax

UltraLite SQL functions: REPLICATE function syntax

UltraLite SQL functions: RIGHT function syntax

UltraLite SQL functions: ROUND function syntax

UltraLite SQL functions: RTRIM function syntax

UltraLite SQL functions: SECOND function syntax

UltraLite SQL functions: SECONDS function syntax

UltraLite SQL functions: SIGN function syntax

UltraLite SQL functions: SIMILAR function syntax

UltraLite SQL functions: SIN function syntax

UltraLite SQL functions: SOUNDEX function syntax

UltraLite SQL functions: SPACE function syntax

UltraLite SQL functions: SQRT function syntax

UltraLite SQL functions: STR function syntax

UltraLite SQL functions: STRING function syntax

UltraLite SQL functions: STRTOUUID function syntax

UltraLite SQL functions: STUFF function syntax

UltraLite SQL functions: SUBSTR function syntax

UltraLite SQL functions: SUBSTRING function syntax

UltraLite SQL functions: TAN function syntax

UltraLite SQL functions: TODAY function syntax

UltraLite SQL functions: TRIM function syntax

UltraLite SQL functions: TRUNCATE function syntax

UltraLite SQL functions: TRUNCNUM function syntax

UltraLite SQL functions: UCASE function syntax

UltraLite SQL functions: UPPER function syntax

UltraLite SQL functions: UUIDTOSTR function syntax

UltraLite SQL functions: WEEKS function syntax

UltraLite SQL functions: YMD function syntax

Adding SQL statements to an UltraLite project

UltraLite statement creation wizard: using

UltraLite user IDs: about

Generating the UltraLite data access code

UltraLite: about

Welcome to UltraLite
Introduction
Utility Programs

UltraLite: code generation

UltraLite: database identification parameters

Database identification parameters

UltraLite: development overview

The static UltraLite development process

UltraLite: directory

File locations for the sample application

UltraLite: SQL support

Overview of SQL support in UltraLite

UltraLite: upgrading

Upgrading UltraLite software

ULUtil: about

The UltraLite Palm utility

ulxml command line utility: features

The ULXML utility

ul_add_project system procedure: about

ul_add_project system procedure

ul_add_statement system procedure: about

ul_add_statement system procedure

UL_AS_SYNCHRONIZE macro: ActiveSync UltraLite messages

UL_AS_SYNCHRONIZE macro

ul_delete_project system procedure: about

ul_delete_project system procedure

ul_delete_statement procedure: about

ul_delete_statement system procedure

ul_delete_statement system procedure: about

ul_delete_statement system procedure

UL_ENABLE_OBFUSCATION macro: about

UL_ENABLE_OBFUSCATION macro

UL_ENABLE_SEGMENTS macro: about

UL_ENABLE_SEGMENTS macro

UL_ENABLE_USER_AUTH macro: about

UL_ENABLE_USER_AUTH macro

ul_set_codesegment procedure: about

ul_set_codesegment system procedure

ul_set_codesegment system procedure: about

ul_set_codesegment system procedure

UL_STORE_PARMS macro: about

UL_STORE_PARMS macro

UL_STORE_PARMS macro: connection parameters

Specifying connection parameters

ul_stream_error structure: about

Stream Error synchronization parameter

UL_SYNC_ALL macro: about

UL_SYNC_ALL macro

UL_SYNC_ALL macro: publication mask

Publication synchronization parameter

UL_SYNC_ALL_PUBS macro: about

UL_SYNC_ALL_PUBS macro

UL_SYNC_ALL_PUBS macro: publication mask

Publication synchronization parameter

UL_TEXT macro: about

UL_TEXT macro

UL_USE_DLL macro: about

UL_USE_DLL macro

UNDER_CE compiler directive: about

UNDER_CE macro

UNDER_NT compiler directive: about

UNDER_NT macro

UNDER_PALM_OS compiler directive: about

UNDER_PALM_OS macro

Unicode: UltraLite databases

UltraLite runtime character sets

unique values: using default global autoincrement in UltraLite

Maintaining primary key uniqueness

universally unique identifiers: UltraLite SQL syntax for NEWID function

How UltraLite tracks row states

UPDATE statement: UltraLite SQL syntax

UPDATE statement

updates: UltraLite databases

updating: rows

UPDATE statement

upgrading databases: creating reference databases

Using an existing database as a reference database

upgrading: UltraLite database schema

Altering the schema of UltraLite databases
How the schema upgrade works

upgrading: UltraLite database schemas

Managing schema files

upgrading: UltraLite software

Upgrading UltraLite software

upload only synchronization: getUploadOnly method

upload only synchronization: setUploadOnly method

upload only synchronization: UltraLite databases

upload only synchronization: upload_only synchronization parameter

Synchronizing high-priority changes

upload-only synchronization: UltraLite databases

upload_ok synchronization parameter: about

Upload OK synchronization parameter

upload_only synchronization parameter: about

UPPER function: UltraLite SQL syntax

User authentication parameters

url_suffix stream parameter: HTTP synchronization

HTTP stream parameters

url_suffix stream parameter: HTTPS synchronization

HTTPS stream parameters

user authentication parameters: about UltraLite

user authentication: about

Authentication Value synchronization parameter

user authentication: Authentication Value synchronization parameter

user authentication: compiler directive

UL_ENABLE_USER_AUTH macro

user authentication: custom MobiLink

Authentication Parameters synchronization parameter
Number of Authentication Parameters parameter

user authentication: getPassword method

Password synchronization parameter

user authentication: getUserName method

New Password synchronization parameter

user authentication: new_password synchronization parameter

user authentication: password synchronization parameter

Password synchronization parameter

user authentication: PASSWORD UltraLite connection parameter

Password connection parameter

user authentication: reporting

Authentication Status synchronization parameter

user authentication: setNewPassword method

New Password synchronization parameter

user authentication: setPassword method

Password synchronization parameter

user authentication: setUserName method

Authentication Status synchronization parameter

user authentication: status

user authentication: UltraLite Component Suite Foundations

user authentication: UltraLite databases

user authentication: user_name synchronization parameter

user IDs: UltraLite databases

User ID connection parameter

user-defined data types: unsupported in UltraLite

Data types in UltraLite

UserID connection parameter: about UltraLite

userid connection parameter: UltraLite

User ID connection parameter

user_data synchronization parameter: about

User Data synchronization parameter

user_name synchronization parameter: about

Introduction to UltraLite utilities

use_cookies stream parameter: HTTPS synchronization

HTTPS stream parameters

usm files: about

usm files: creating

Introduction to UltraLite utilities

utilities: SQL preprocessor

The SQL preprocessor

utilities: UltraLite generator

The UltraLite generator

utilities: UltraLite Palm utility

The UltraLite Palm utility

utilities: UltraLite segment utility

The UltraLite segment utility

UUIDs: UltraLite SQL syntax for NEWID function

UUIDs: UltraLite SQL syntax for STRTOUUID function

UUIDs: UltraLite SQL syntax for UUIDTOSTR function

UUIDTOSTR function: UltraLite SQL syntax