Tim

When creating a new table I often want to check the structure of an existing table. Currently I open another copy of EDBMan, but I'm wondering if it would be possible to review these in the Create/Alter table dialogue at some point in the future?

Roy Lambert

Roy,

<< When creating a new table I often want to check the structure of an
existing table. Currently I open another copy of EDBMan, but I'm wondering
if it would be possible to review these in the Create/Alter table dialogue
at some point in the future? >>

It will most likely require some major reworking of the way the dialogs
work, most importantly making them non-modal.  I'll have to see whether this
can be done or not.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>It will most likely require some major reworking of the way the dialogs
>work, most importantly making them non-modal. I'll have to see whether this
>can be done or not.

Not necessarily, just  add another tab onto the page control and allow users to select a table to display the structure of.

Roy Lambert

Tim


Thinking a bit more the ability to print the table structure would be acceptable, possibly just the sql used to create it. That might even be better for my purposes.

Roy Lambert

Roy,

<< Thinking a bit more the ability to print the table structure would be
acceptable, possibly just the sql used to create it. That might even be
better for my purposes. >>

See "Reverse Engineer".

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Thinking a bit more the ability to print the table structure would be
>acceptable, possibly just the sql used to create it. That might even be
>better for my purposes. >>
>
>See "Reverse Engineer".

You mean

Reverse engineer the database
Open Windows Explorer
[Forget the directory selected and reverse engineer again to find it] Find the directory
Open reverse engineered code in suitable app
Select each table in turn and Print definition

As opposed to

Click "Print definitions" button

Roy Lambert

Roy,

<< You mean

Reverse engineer the database
Open Windows Explorer
[Forget the directory selected and reverse engineer again to find it] Find
the directory
Open reverse engineered code in suitable app
Select each table in turn and Print definition

As opposed to

Click "Print definitions" button >>

How about:

1) Reverse engineer database
2) Print .SQL file using notepad

?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Please note cheating is not allowed (unless I do it) - your step 2 is actually a summary of four steps.

Roy Lambert

Roy,

<< Please note cheating is not allowed (unless I do it) - your step 2 is
actually a summary of four steps. >>

Okay, I give in.   I'm just trying like crazy to not be forced to put in
another stinky report writer that comes with Delphi.  Maybe I'll just
use an RTF component to do the printing.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Okay, I give in. I'm just trying like crazy to not be forced to put in
>another stinky report writer that comes with Delphi.

That I can understand, and I know that you're determined to keep it to vanilla Delphi so can't use things like FreeReport even

>Maybe I'll just
>use an RTF component to do the printing.

With all the extra bumph now possible for the various fields its not going to be easy to come up with a sensible format.

As a compromise if we can reverse engineer one table I'll happily save to file and print each one

Roy Lambert