Rosi Shared FormsUnits Class Hierarchy Classes, Interfaces, Objects and Records Types Variables Constants Functions and Procedures Identifiers |
Unit rdbtool_MDB
Description
rdbtool_MDB is set functions for working with MDB database file by using of DAO; can be used for updating of database structure by application.
Date: Apr 2008 Author: Rosi (http://www.rosinsky.cz/delphi) Full functional demo
Overview
Classes, Interfaces, Objects and Records
Functions and Procedures
function IsAccess97(DBName: string): boolean; |
function OpenMDB(DBName, Pwd: string): Database; |
procedure CompactMDBEx(SrcName, DstName, OldPwd, NewPwd: string); |
function CompactMDB(DBName, Pwd: string): boolean; |
function ReadMDBUsers(DBName: string; List: TStrings): boolean; |
procedure GetTableList(DBName, Pwd: string; List: TStrings); overload; |
procedure GetTableList(db: Database; List: TStrings); overload; |
function GetTableFields(DBName, Pwd, TableName: string; List: TStrings): TFieldRecArray; overload; |
function GetTableFields(db: Database; TableName: string; List: TStrings): TFieldRecArray; overload; |
function GetTableIndexes(DBName, Pwd, TableName: string; NotRelations: boolean; List: TStrings): TIndexRecArray; overload; |
function GetTableIndexes(db: Database; TableName: string; NotRelations: boolean; List: TStrings): TIndexRecArray; overload; |
function CreateTable(db: Database; TableName: string; FieldRecArray: TFieldRecArray; IndexRecArray: TIndexRecArray): TableDef; |
procedure DropTable(db: Database; TableName: string); |
procedure DeleteIndexes(db: Database; TableName: string; LeftPrimaryKey: boolean); |
procedure RenameTable(db: Database; SrcTableName, DstTableName: string); |
function GetQueryDefs(DBName, Pwd: string; List: TStrings): TQueryDefArray; overload; |
function GetQueryDefs(db: Database; List: TStrings): TQueryDefArray; overload; |
procedure ClearQueryDefs(db: Database); |
function CreateQueryDef(db: Database; QDef: TQueryDef): QueryDef; |
procedure CreateQueryDefs(db: Database; QDefArr: TQueryDefArray); |
function GetRelations(DBName, Pwd: string; List: TStrings): TRelationRecArray; overload; |
function GetRelations(db: Database; List: TStrings): TRelationRecArray; overload; |
procedure CreateRelations(db: Database; RelationRecArray: TRelationRecArray); |
procedure ClearRelations(db: Database); |
procedure RegDAO350; |
Types
Description
Functions and Procedures
function IsAccess97(DBName: string): boolean; |
|
function OpenMDB(DBName, Pwd: string): Database; |
|
procedure CompactMDBEx(SrcName, DstName, OldPwd, NewPwd: string); |
|
function CompactMDB(DBName, Pwd: string): boolean; |
|
function ReadMDBUsers(DBName: string; List: TStrings): boolean; |
|
procedure GetTableList(DBName, Pwd: string; List: TStrings); overload; |
|
procedure GetTableList(db: Database; List: TStrings); overload; |
|
function GetTableFields(DBName, Pwd, TableName: string; List: TStrings): TFieldRecArray; overload; |
|
function GetTableFields(db: Database; TableName: string; List: TStrings): TFieldRecArray; overload; |
|
function GetTableIndexes(DBName, Pwd, TableName: string; NotRelations: boolean; List: TStrings): TIndexRecArray; overload; |
|
function GetTableIndexes(db: Database; TableName: string; NotRelations: boolean; List: TStrings): TIndexRecArray; overload; |
|
procedure DropTable(db: Database; TableName: string); |
|
procedure DeleteIndexes(db: Database; TableName: string; LeftPrimaryKey: boolean); |
|
procedure RenameTable(db: Database; SrcTableName, DstTableName: string); |
|
function GetQueryDefs(DBName, Pwd: string; List: TStrings): TQueryDefArray; overload; |
|
function GetQueryDefs(db: Database; List: TStrings): TQueryDefArray; overload; |
|
procedure ClearQueryDefs(db: Database); |
|
function CreateQueryDef(db: Database; QDef: TQueryDef): QueryDef; |
|
function GetRelations(DBName, Pwd: string; List: TStrings): TRelationRecArray; overload; |
|
procedure ClearRelations(db: Database); |
|
Types
Generated by PasDoc 0.13.0 on 2018-03-18 21:06:12
|