--- In firebird-support@yahoogroups.com, "Clay Shannon"
<cshannon@d...> wrote:

> Copy and paste is what I currently use, but it's "ugly."
>
> Clay Shannon,
> Dimension 4 Software
>

I cheat,
I use DbWorkbench to help me generate selects
because I've been at this for a while I put a description at the top
of the select that has my name, date, reason for query and its objectives.
I also incluse a list of dependancies table, views, fields and the like.
After this and in the same comment I put development history.

In the query I insert comments where ever my reasoning might be not
obvious or where I might be mistaken.

When revising queries I leave the old and insert the new.
This I cut and paste into delphi queries.
I depend on the compiler and pre exec routines to clean the human out
of the query.

Doing things this way means my programs are relatively easy to maintain.

Another advantage is that I can show the customer a copy for their
approval - even if they can't read SQL they can read the comments.

DbWorkbench makes it much easier for me.
Where would I be without the macro that inserts
{*****************************************

*****************************************}

ready for my comments

mick