Unit rDBImport

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

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;
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;
 
cImportLogWarning = 9;
 
cImportLogError = 10;
 

Variables

rDBImportForm: TrDBImportForm;
 
rDBImport_Setting: TrDBImport_Setting;
 

Author

Created

Jan 2006

Last Modified

Nov 2019


Generated by PasDoc 0.13.0 on 2019-12-01 20:56:26