Roy,

<< But a question - if you have two before delete triggers which sequence do
they fire in? I'm not sure yet if this will be important but I'd like to be
prepared. >>

Right now they fire in the defined order.  Juergen Sawatzki has already
submitted an enhancement request for the ability to specify the firing
sequence.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Which is fine, but you have to realize that we're making a database engine
>for a much wider audience than just Delphi. DBISAM was almost exclusively
>geared toward Delphi/C++Builder, whereas EDB is intended to be used just
>about anywhere.

I realise it - I'm just a human being - selfish <vbg>

>Not at all. However, it takes time to recreate an entire database engine,
>so the syntactic sugar comes later, not sooner.

Another area where we disagree. Some of the things you regard as syntactic sugar, and as a diabetic I'm not sure I'm allowed any, I regard as fairly fundamental.

><< I can't remember precise details of what I'd been writing since the code
>was thrown out ages ago but unless I'm misremembering or misinterpreting
>then in rough terms I'll need upto 150 triggers vs 1 procedure that tested a
>list of tables. That fact alone says more complex. >>
>
>I disagree. It's a lot of work and a pain in the ass, but it's not complex.
>The code is all very simple.

We've had this sort of discussion before, and I know we'll never agree.  Any single bit of the code is simple, but when you add the whole lot together it changes things.

Roy Lambert

Roy,

<< Another area where we disagree. Some of the things you regard as
syntactic sugar, and as a diabetic I'm not sure I'm allowed any, I regard as
fairly fundamental. >>

I can only do so much at one time, so things had to be trimmed down to what
could be done in the time frame that we had to work with.  Had I still been
sitting on EDB until this year waiting until I had every little feature done
to your satisfaction, then we would be out of business.  It would have been
4 years since we last had a major update, which is simply no good in the
software business.  We don't exist in a vaccum where revenue doesn't matter.

<< We've had this sort of discussion before, and I know we'll never agree.
Any single bit of the code is simple, but when you add the whole lot
together it changes things. >>

These things are all very manageable by writing a few simple tools to do so.
You have the metadata for the tables and triggers, and you have DDL
statements for adding, altering, and dropping triggers.  The rest is left up
to you or a third party tool for managing database schemas.

--
Tim Young
Elevate Software
www.elevatesoft.com