Hello,
  Is there CASCADE support in Constraints ?

Thank you
--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

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

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 ?

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

<< 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

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

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

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