Re: Modifiyng a Paradox Database

"clinisbut" <clinisbut@xxxxxxxxx> wrote in message
news:22c103a7-e049-46c3-a692-43c912c35b0b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is there a way to modify a paradox database structure? Concretly
fields names.
I don't mean inside my own app, but with any existing applicaction.

The original Borland tool Database Desktop (DBD32.EXE) was newer a freely
distributable utility. There are some commercial/shareware "Database Desktop
replacemens" but I myself never had any need for those replacement tools.

Or to create a new one database. I'm stuck with this, all I found is
commercial applications

So, you do not want to use any money here? Then payment can always be
compensated with developer's own sweat:)

For instance one demoversion application dbu13.zip for instance from Delphi
Suer Page http://delphi.icm.edu.pl/ might help you to get started. This
utility shows the current Table Structure but does not itself write any
modifications to the table. Yet it gives ready made Delphi source how to
programmatically create equal Table:

Delphi Source For CONTACTS.DB:
=========================================================

with TTable.Create(Self) do
begin
Active := False;
DatabaseName := 'C:\TEMP'; { * Change the DatabaseName * }
TableName := 'CONTACTS.DB';
TableType := ttDefault;
with FieldDefs do
begin
Add('CustNo', ftFloat, 0, False);
Add('Name', ftString, 30, False);
Add('Phone', ftString, 15, False);
Add('Email', ftString, 40, False);
end;
CreateTable;
with IndexDefs do
begin
AddIndex('PrimaryIndex', 'CustNo;Name', [ixPrimary, ixUnique]);
end;
Free;
end;

By making your changes for instance to Field Lengths, you can easily get a
new Table created with the new structure you want.
Of course this same type of code can alter also the existing table's
structures. Yet it is a bit more complicated, and you have to go and dig the
exact examples from Google. Good luck.
EG



.