Delphi Tips&Tricks News   Tips   .NET Software   VCL Software   Search   Contacts
Special Offer!

Ultimate Pack  hot!
Image Editor  new!
Runtime Fusion
Form Designer
Object Inspector
Print Suite Pro
Commented Image
Delphi Toys
WinDowse
Delphi Bonus
TMS Scripter Studio
Form Designer VB
Form Designer .NET

...get more...
for Delphi.NET, C#, VB.NET
for Delphi VCL, BCB 3-6

WinAPI Online
Unix Manual Pages
MegaDetailed.NET
in3steps.com

Blogspot  greatis.blogspot.com

 See more ads about delphi programming →


Copy and delete table - Databases - Tips & Tricks - Greatis Delphi Pages

For deleting table use DeleteTable procedure. For copying table use DbiCopyTable function. Don't forget that DbiInit must be called before calling of DbiCopyTable.


uses DbiTypes, DbiProcs;
 
procedure TForm1.Button1Click(Sender: TObject);
begin
  with Table1 do
  begin
    DatabaseName:='DBDEMOS';
    TableName:='CUSTOMER2';
    TableType := ttParadox;
    DeleteTable;
  end;
end;

procedure FDbiCopyTable(hTmpDb: hDbiDb; SrcTableName: string; 
  DestName: string);
begin
  Check(
    DbiCopyTable(
      hTmpDb, 
      True, 
      PChar(SrcTableName), 
    nil,
    PChar(DestName)));
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  Table1.Active:=True;
  Check(dbiInit(nil));
  FDbiCopyTable(Table1.dbHandle, 'CUSTOMER.DB', 'CUSTOMER2.DB');
  Table1.Active:=False;
end;
Related topics
Get directory from BDE-alias
Define BDE alias
Create DB file at runtime

For more
BDE Online Reference

Download source


 See more ads about delphi components →