Introduction
Welcome
Using This Resource
Getting Involved
Submission Guidelines
License Agreement
The VistaDB Database Management System
Overview
Constraints
Encryption
Identity Fields
Relationships
Triggers
Using VistaDB .Net
Basic Direct Data Access (DDA)
Direct Navigation
Using VistaDBDatabase
Import XML Schema
Import XML Data
Using VistaDB COM Objects
Importing using COM
Exporting using COM
Using VistaDB Server
Obtain a List of Databases Registered on a VistaDB Server
Add a Database to a VistaDB Server Programmatically
Using VistaDB VCL 
Basics
Which Delphi Components to Use?
Connecting to an Encrypted Database
Using the Find function
Which 'Find' To Use?
Find Syntax
Making Find Syntax Easier
Using VDBDatabase
Import XML Schema
Import XML Data
Using VDBDirect
Changing the phsyical field order
Checking if a Column Exists
Creating an ID column in an existing Table
Using VDBQuery
Overview
Creating a Database using SQL
Creating a Table using SQL
Deleting a Record
Duplicating a Record
Open or ExecSQL?
Retrieving a Single Record from a database
Retrieving an Image from a database
Saving an image to a database
Using Live Datasets
Troubleshooting
Query returns incorrect results
Updating existing field value within the same SQL statement fails
Using VDBTable
Using The Databuilder Tool
Cascading Deletes
Cascading Inserts
Changing a Normal Column to an Identity Column
Reference
COM
Installation and Deployment
Installing COM
Deploying VistaDB COM applications
COM Objects
.NET
Installing and Deployment
Installing into Visual Studio .NET
Manual Installation
Deploying VistaDB .NET applications
Compact Framework
Using
Connecting to a VistaDB database
Connecting to a DataGrid
Configuring the VistaDBDataAdapter
ASP.NET FAQ
ASP.NET Sample
Configuring IIS for VistaDB
Crystal Reports FAQ
Crystal Reports Sample
.Net Version Numbers
.NET Data Provider
.NET Data Provider
.Net Provider Reference
Enumeration Reference
AccessMode Enumeration
CypherType Enumeration
VDBDatabaseParam Enumeration
VDBFileType Enumeration
VDBForeignKeyOptions Enumeration
VDBIndexOption Enumeration
VDBTriggerEvent Enumeration
VistaDBErrorCodes Enumeration
VistaDBType Enumeration
IVistaDBRemoteService Interface Reference
IVistaDBRemoteService Interface
IVistaDBRemoteService Members
IVistaDBRemoteService Methods
IVistaDBRemoteService.EnumTables Method
IVistaDBRemoteService.GetActiveUserList Method
IVistaDBRemoteService.GetAliasList Method
IVistaDBRemoteService.GetLogFile Method
IVistaDBRemoteService.IsAdminConnection Method
IVistaDBRemoteService.UpdateAliasList Method
IVistaDBRemoteService.UpdateUserList Method
RTagBackInfo Reference
RTagBackInfo Fields
RTagBackInfo Members
RTagBackInfo Structure
RTagBackInfo.iCount Field
RTagBackInfo.pTagsInfo Field
RTagInfo Reference
RTagInfo Fields
RTagInfo Members
RTagInfo Structure
RTagInfo.bActive Field
RTagInfo.bCaseInsensitive Field
RTagInfo.bDesc Field
RTagInfo.bFts Field
RTagInfo.bHasParentIndex Field
RTagInfo.bPrimary Field
RTagInfo.bRYO Field
RTagInfo.bStandardIndex Field
RTagInfo.bUnique Field
RTagInfo.cpForExpr Field
RTagInfo.cpKeyExpr Field
RTagInfo.cpTagName Field
RTagInfo.iInfoSize Field
RTagInfo.iOrderIndex Field
RTagInfo.ulLocaleId Field
VDBColumn Info Reference
VDBColumnInfo Fields
VDBColumnInfo Members
VDBColumnInfo Structure
VDBColumnInfo.AllowNull Field
VDBColumnInfo.Caption Field
VDBColumnInfo.Compressed Field
VDBColumnInfo.DataType Field
VDBColumnInfo.Decimals Field
VDBColumnInfo.DefValue Field
VDBColumnInfo.Description Field
VDBColumnInfo.Encrypted Field
VDBColumnInfo.FTS Field
VDBColumnInfo.Hidden Field
VDBColumnInfo.Identity Field
VDBColumnInfo.IncStep Field
VDBColumnInfo.Indexed Field
VDBColumnInfo.Name Field
VDBColumnInfo.PrimaryKey Field
VDBColumnInfo.ReadOnly Field
VDBColumnInfo.Unicode Field
VDBColumnInfo.UseDefValInUpdate Field
VDBColumnInfo.Width Field
VDBConstraintInfo Reference
VDBConstraintInfo Fields
VDBConstraintInfo Members
VDBConstraintInfo Structure
VDBConstraintInfo.Active Field
VDBConstraintInfo.Body Field
VDBConstraintInfo.Description Field
VDBConstraintInfo.Name Field
VDBIndexInfo Reference
VDBIndexInfo Fields
VDBIndexInfo Members
VDBIndexInfo Structure
VDBIndexInfo.CaseSens Field
VDBIndexInfo.Condition Field
VDBIndexInfo.Desc Field
VDBIndexInfo.Fields Field
VDBIndexInfo.FTS Field
VDBIndexInfo.Locale Field
VDBIndexInfo.Name Field
VDBIndexInfo.PrimaryKey Field
VDBIndexInfo.Standard Field
VDBIndexInfo.Unique Field
VDBRelationshipInfo Reference
VDBRelationshipInfo Fields
VDBRelationshipInfo Members
VDBRelationshipInfo Structure
VDBRelationshipInfo.Body Field
VDBRelationshipInfo.CascadeDelete Field
VDBRelationshipInfo.CascadeUpdate Field
VDBRelationshipInfo.Description Field
VDBRelationshipInfo.ForKeyColumns Field
VDBRelationshipInfo.Name Field
VDBRelationshipInfo.PrimKeyColumns Field
VDBRelationshipInfo.PrimTable Field
VDBTiggerInfo Reference
VDBTriggerInfo Fields
VDBTriggerInfo Members
VDBTriggerInfo Structure
VDBTriggerInfo.Active Field
VDBTriggerInfo.Body Field
VDBTriggerInfo.Description Field
VDBTriggerInfo.Event Field
VDBTriggerInfo.Name Field
VDBTriggerInfo.Priority Field
VistaDBColumn Reference
AllowNull Property
ColumnCaption Property
ColumnDecimals Property
ColumnDescription Property
ColumnWidth Property
VistaDBColumn Class
VistaDBColumn Members
VistaDBColumn Properties
Unique Property
VistaDBType Property
Unicode Property
Type Property
ReservedWord Property
ReadOnly Property
PrimaryKey Property
Packed Property
Name Property
IdentityValue Property
IdentityStep Property
Identity Property
Hidden Property
Encrypted Property
DataSize Property
VistaDBCommand Reference
VistaDBCommand Class
VistaDBCommand Constructor
VistaDBCommand Constructor ()
VistaDBCommand Constructor (String)
VistaDBCommand Constructor (String, VistaDBConnection)
VistaDBCommand Constructor (String, VistaDBConnection, VistaDBTransaction)
VistaDBCommand Fields
VistaDBCommand Members
VistaDBCommand Methods
VistaDBCommand Properties
VistaDBCommand.Cancel Method
VistaDBCommand.CreateParameter Method
VistaDBCommand.Dispose Method (Boolean)
VistaDBCommand.ExecuteNonQuery Method
VistaDBCommand.ExecuteReader Method ()
VistaDBCommand.ExecuteReader Method (CommandBehavior)
VistaDBCommand.ExecuteScalar Method
VistaDBCommand.Finalize Method
VistaDBCommand.Prepare Method
Connection Property
Dispose Method
Parameters Property
Transaction Property
UpdatedRowSource Property
ExecuteReader Method
VistaDBCommandBuilder Reference
VistaDBCommandBuilder Class
VistaDBCommandBuilder Constructor
VistaDBCommandBuilder Constructor ()
VistaDBCommandBuilder Constructor (VistaDBDataAdapter)
VistaDBCommandBuilder Members
VistaDBCommandBuilder Methods
VistaDBCommandBuilder Properties
VistaDBCommandBuilder.DeriveParameters Method
VistaDBCommandBuilder.GetDeleteCommand Method
VistaDBCommandBuilder.GetInsertCommand Method
VistaDBCommandBuilder.GetUpdateCommand Method
UpdateCommand Property
InsertCommand Property
DeleteCommand Property
DataAdapter Property
VistaDBConnection Reference
AccessMode Property
BeginTransaction Method
CaseSensitivity Property
ClusterSize Property
VistaDBConnection.BeginTransaction Method ()
VistaDBConnection.BeginTransaction Method (IsolationLevel)
VistaDBConnection.ChangeDatabase Method
VistaDBConnection.Close Method
VistaDBConnection.CreateCommand Method
VistaDBConnection.CreateTemporaryDatabase Method (Int32, Boolean)
VistaDBConnection.CreateTemporaryDatabase Method (VistaDBDatabase)
VistaDBConnection.Dispose Method (Boolean)
VistaDBConnection.Finalize Method
VistaDBConnection.GetRemoteService Method
VistaDBConnection.Open Method
VistaDBConnection Class
VistaDBConnection Constructor
VistaDBConnection Constructor ()
VistaDBConnection Constructor (String)
VistaDBConnection Members
VistaDBConnection Methods
VistaDBConnection Properties
State Property
ReadOnly Property
Password Property
LoginUser Property
LoginPassword Property
Exclusive Property
Dispose Method
DataSource Property
DatabaseDescription Property
Database Property
Cypher Property
CultureID Property
CreateTemporaryDatabase Method
ConnectionString Property
ConnectionTimeout Property
VistaDBDataAdapter Reference
VistaDBDataAdapter Class
VistaDBDataAdapter Constructor
VistaDBDataAdapter Constructor ()
VistaDBDataAdapter Constructor (String, String)
VistaDBDataAdapter Constructor (String, VistaDBConnection)
VistaDBDataAdapter Constructor (VistaDBCommand)
VistaDBDataAdapter Events
VistaDBDataAdapter Members
VistaDBDataAdapter Properties
VistaDBDataAdapter.RowUpdated Event
VistaDBDataAdapter.RowUpdating Event
UpdateCommand Property
TableMappings Property
SelectCommand Property
InsertCommand Property
DeleteCommand Property
VistaDBDatabase Reference
CaseSensitive Property
ClusterSize Property
VistaDBDatabase.ActivatedRecycling Method
VistaDBDatabase.ActivateRecycling Method
VistaDBDatabase.AddToExportList Method