![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 16 of 16 total |
![]() |
Mon, Sep 1 2008 7:05 AM | Permanent Link |
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. | |
Mon, Sep 1 2008 8:03 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Mon, Sep 1 2008 8:19 AM | Permanent Link |
Fernando Dias ![]() | 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] |
Mon, Sep 1 2008 9:03 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Mon, Sep 1 2008 7:31 PM | Permanent Link |
Fernando Dias ![]() | Roy,
Since it's OT, please find my answer in the discussion group. Thanks |
Tue, Sep 2 2008 8:20 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |