Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
CASCADE Constraint support ? |
Mon, May 5 2008 6:39 PM | Permanent Link |
Charalabos Michael | Hello,
Is there CASCADE support in Constraints ? Thank you -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Mon, May 5 2008 6:48 PM | Permanent Link |
Charalabos Michael | Charalabos Michael wrote:
> Hello, > Is there CASCADE support in Constraints ? > > Thank you Hmm, Found the answer ... no support Any chance in EDB 2 ? Thank you -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Mon, May 5 2008 10:38 PM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | Michael:
Tim has stated in a thread at the beginning of April 2008 that this is something which will have to wait until the enterprise server is done. In the thread he said, "The locking model in EDB, due to the multi-user file-sharing support, won't allow it without extremely restrictive locking." While Tim has not let the cat out-of-the-bag regarding all of EDB v2's enhancements, I doubt very much by his comments in that thread that CASCADE support will be one of them. -- Regards, Jan Ferguson [Team Elevate] Charalabos Michael wrote: <<Charalabos Michael wrote: <<<< Is there CASCADE support in Constraints ? << <<Hmm, Found the answer ... no support <<Any chance in EDB 2 ? |
Tue, May 6 2008 5:07 PM | Permanent Link |
Charalabos Michael | Hello Jam, > Tim has stated in a thread at the beginning of April 2008 that this is > something which will have to wait until the enterprise server is done. > In the thread he said, "The locking model in EDB, due to the multi-user > file-sharing support, won't allow it without extremely restrictive > locking." > > While Tim has not let the cat out-of-the-bag regarding all of EDB v2's > enhancements, I doubt very much by his comments in that thread that > CASCADE support will be one of them. Code, sweet code ... What's the reason using RI if we don't use this awesome feature ? ... 1) Users deletes a Record from Master Table 2) Use SQL to delete all the client Records that linked with Master Table. In what situation RI will help me exactly ??? If the Tables get corrupt ? Can anyone tell me an example where the RESTRICT constraint will help ? Thank you -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Wed, May 7 2008 4:00 AM | Permanent Link |
"Ole Willy Tuv" | << What's the reason using RI if we don't use this awesome feature ? >>
I do agree that the optional referential actions, CASCADE, SET NULL and SET DEFAULT are neat RI functionality. << Can anyone tell me an example where the RESTRICT constraint will help ? >> It prevents that a master row having child rows is accidently deleted. Ole Willy Tuv |
Wed, May 7 2008 6:01 AM | Permanent Link |
Charalabos Michael | Hello Ole,
How are you ? Long time no see > << Can anyone tell me an example where the RESTRICT constraint will help > ? >> > > It prevents that a master row having child rows is accidently deleted. Emm, if you design you application correctly i don't think that will be possible. -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Wed, May 7 2008 12:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Emm, if you design you application correctly i don't think that will be possible. >> How so ? Someone could use the ODBC driver or .NET data provider to do so outside of your control. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, May 7 2008 4:26 PM | Permanent Link |
Charalabos Michael | Hello Tim,
> << Emm, if you design you application correctly i don't think that will be > possible. >> > > How so ? Someone could use the ODBC driver or .NET data provider to do so > outside of your control. If i allow it! -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |