This site is temporarily down. Please come back. Create a dBase database at runtime
DelphiFAQ Home Search:

Create a dBase database at runtime

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

The following procedure may be especially useful for temporary tables:

procedure MakeDataBase;
begin
  with TTable.Create(nil) do
  begin
    DatabaseName  := 'c:\temp';  (* alias *)
    TableName     := 'test.dbf';
    TableType     := ttDBase;
    with FieldDefs do
    begin
      Add('F_NAME', ftString,20,false);
      Add('L_NAME', ftString,30,false);
    end;
    CreateTable;
    { create a calculated index }
    with IndexDefs do
    begin
      Clear;
      { don't forget ixExpression in calculated indexes! }
      AddIndex('name','Upper(L_NAME)+Upper(F_NAME)',[ixExpression]);
    end;
  end;
end;

Content-type: text/html

Comments:

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: