Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Reverse engine a database duplicates triggers
Tue, Oct 14 2008 6:25 AMPermanent Link

2.02 b1

First of all, I prefer old way of reverse enginner: triggers were
created just afeter table creation, now they are created at the end of
script.

But with an existing database, running 2.02 reverse enginer has
duplicate triggers: after table creation and at the end of script.

BTW, why do you add constraints via ALTER TABLE in auto reverse
enginer scripts? Formerly where created on CREATE TABLE

I've send you a copy of this script.

Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.
Tue, Oct 14 2008 6:39 AMPermanent Link

"David Cornelius"
> BTW, why do you add constraints via ALTER TABLE in auto reverse
> enginer scripts? Formerly where created on CREATE TABLE

Because of the thread in the suggestions group entitled, "reverse
engineer => install script".

(http://www.elevatesoft.com/newsgrp?action=openmsg&group=10&msg=2651&pag
e=1)

--
David Cornelius
CorneliusConcepts.com
Tue, Oct 14 2008 6:59 AMPermanent Link

David,

>Because of the thread in the suggestions group entitled, "reverse
>engineer => install script".

Ok, I see the motivation. But you'll need to rearange generated script
in most cases due a procedure is calling another procedure declared
last. I think is more readable to see all related to a table near it,
but, it's not a great matter.

I guess "reverse enginering" needs some improvements ... Smiley


Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.
Tue, Oct 14 2008 10:54 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Tiago,

<< But with an existing database, running 2.02 reverse enginer has duplicate
triggers: after table creation and at the end of script. >>

Yep, you are correct.  I'll make sure this is corrected.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image