Unit rDBImport

Description

rDBImport provides universal dialog for import of data from TXT, XLS, DB and other sources to any DB table.

Updated version compatible with Delphi2010+. Splash screen in demo version.

Overview

Classes, Interfaces, Objects and Records

Name Description
Record TrDBImport_Setting  
Class TrDBImportForm provides universal dialog for import of data from TXT, XLS, DB and other sources to any DB table

Functions and Procedures

function DBImport(TargetDataSet: TDataSet; LookupSQL: TStrings; UDLPath: string; PSFile: TPropSaveFile; BackupCallBack: TrDBImport_BackupCallBack): boolean;
function DBImportAutoDesign(TargetDataSet: TDataSet; LookupSQL, AutoSetting: TStrings; UDLPath: string; PSFile: TPropSaveFile; BackupCallBack: TrDBImport_BackupCallBack): boolean;
function DBImportAutoRun(TargetDataSet, SourceDataSet: TDataSet; LookupSQL, AutoSetting: TStrings; LogCallBack: TrDBImport_LogCallBack): boolean;

Types

TrDBImport_BackupCallBack = procedure(var Continue: boolean) of object;
TrDBImport_LogCallBack = procedure(LogStr: string; Level: integer; var Aborted: boolean) of object;

Constants

cImportLogInfo = 1;
cImportLogProgress = 2;
cImportLogResult = 5;
cImportLogTotalResult = 6;
cImportLogWarning = 9;
cImportLogError = 10;

Variables

rDBImportForm: TrDBImportForm;
rDBImport_Setting: TrDBImport_Setting;

Description

Functions and Procedures

function DBImport(TargetDataSet: TDataSet; LookupSQL: TStrings; UDLPath: string; PSFile: TPropSaveFile; BackupCallBack: TrDBImport_BackupCallBack): boolean;

run manual import to TargetDataSet, source is selected by dialog

function DBImportAutoDesign(TargetDataSet: TDataSet; LookupSQL, AutoSetting: TStrings; UDLPath: string; PSFile: TPropSaveFile; BackupCallBack: TrDBImport_BackupCallBack): boolean;

run or prepare manual import to TargetDataSet with possibility to store the AutoSetting

function DBImportAutoRun(TargetDataSet, SourceDataSet: TDataSet; LookupSQL, AutoSetting: TStrings; LogCallBack: TrDBImport_LogCallBack): boolean;

run automatic import to TargetDataSet driven by AutoSetting, source can be defined by SourceDataSet or by AutoSetting

Types

TrDBImport_BackupCallBack = procedure(var Continue: boolean) of object;

callback event for creating of backup

TrDBImport_LogCallBack = procedure(LogStr: string; Level: integer; var Aborted: boolean) of object;
 

Constants

cImportLogInfo = 1;
 
cImportLogProgress = 2;
 
cImportLogResult = 5;
 
cImportLogTotalResult = 6;
 
cImportLogWarning = 9;
 
cImportLogError = 10;
 

Variables

rDBImportForm: TrDBImportForm;
 
rDBImport_Setting: TrDBImport_Setting;
 

Author

Created

Jan 2006

Last Modified

Jan 2021


Generated by PasDoc 0.15.0.