> At 17:17 30.06.2003 +0600, Kubanych wrote:
> >It is not a good practice to use recursions in stored procedures.
> >Iterations are better. Remember Dejkstra and Wirth.
> >Algorithm should be clear.
> >Sometimes it requires more code but it will save time later while making
> >tests and tech support.
>
> Whether or not it is good practise may be disputable, but Martijn is the
> creator of Database Workbench and it should be left to the users of
> Database Workbench to decide whether they want to use recursive procedures
> or not. Firebird supports it and Database Workbench should also support

it.

It does :-)

I was only curious about the level...

As for the usefulness of recursive stuff:
- sometimes, it's simply easier to do so.

Instead of saying: you shouldn't - I think you should say: sometimes, it's
useful, other times it isn't.

> and then Martijn wrote:
> >http://www.bamsemums.com/
>
> Thanks Martijn! I never knew about this address and about all these great
> recipes:
>
> http://www.bamsemums.no/bamsemums/PageMaker.aspx?PageContainerID=5004

Lol! Nice pictures! A pitty I don't understand a thing of what the text
is saying...


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com