| 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 |