Roy,

>I've been thinking about the issue of triggers and stored procedures and I'm still not sure. If the database I was using could be accessed from multiple apps some of which I had no control over it makes sense (almost mandatory) to put as much of the control as possible into the database so that its in place whoever and whatever accesses it. I'm not sure that the same is true when mine is the only app that will (should) access the data. Especially when, as in my case, there will be multiple versions of the database leading to code duplication.

The fact is more closer to server more secure is kept data. My
approach is intesive use of triggers and duplicate code
BeforeInsert/Update. I hate it, but ...

Now, in my EDB discovering (I used DBISAM exclusively for the last
eight years), have seen how is implemented (?) R.I.:  Only way in EDB
again is triggers to cascade update foreign keys and cascade delete
master detail relations. Tim has his reasons, but real world apps are
so complex than "one size fits all" is not true.


Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Fernando


>It still is, and getting better, I hope.

That would be exceptionally difficult since I was referring specifically to not having to trim fields before posting

Roy Lambert

Roy,

>> It still is, and getting better, I hope.
>
> That would be exceptionally difficult since I was referring specifically to not having to trim fields before posting

You must start looking on the bright side ..
I was talking about using Delphi, of course.

--
Fernando Dias
[Team Elevate]

Fernando

>You must start looking on the bright side ..

Why?

>I was talking about using Delphi, of course.

Ahhhh. Looking at their ngs it seems as if we're heading for the second divide. We'll have D7 and before, D2009 and after and the poor souls in the middle. Not requiring unicode I remain to be convinced that there is any benefit to me in upgrading. I'm especially waiting until I can work out the full cost of upgrading. As things stand the only one of the (thankfully few) 3rd party tools I know what the cost will be is ElevateDB.

At least I now like the IDE layout in D2006 so at least I've got that going for me.

Roy Lambert

Roy,
Since it's OT, please find my answer in the discussion group.
Thanks

Tiago


If you want to be really safe you also need a SUBSTRING in there to make sure the data length doesn't exceed the column length.

Roy Lambert [Team Elevate]