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


Share this page

Follow us
LinkedIn Blogspot Twitter Facebook

Related products
Ultimate Pack  hot!
iGrid Plotter  new!
Image Editor
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
Print Suite .NET
Gradient Controls .NET  new!

Related links
Win32.hlp online version
MegaDetailed.NET
Delphi to C#

Special
Free Software Promotion
Offers for Resellers

Hobby projects
cdtrrracks.com
books.storrre.com
in3steps.com
sovietphillumeny.com

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