CREATE TABLE "deleteion" control

[Andrew Sinning]

What does using an ObjectPtr mean with regard to "NATURAL" joins?  In
otherwords, do I still need to make the relationship between two tables
explicit with a WHERE t1.fieldName *= t2.fieldName, or is the
relationship automatic?

So, I have

TABLE games
  gameId UNIQUE
  gameName

TABLE questions
  questionId UNIQUE
  gameId REFERENCES games


So, if I want to select questionId 275 along with it's parent game, can
I just use

SELECT * FROM questions, games WHERE questionId = 275

or do I need to specify: AND questions.gameId *= games.gameId

?

Thanks.

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Tuesday, August 19, 2003 1:34 PM
To: valentina at lists.macserve.net
Subject: Re: CREATE TABLE "deleteion" control


on 8/19/03 20:59, Andrew Sinning at andrew at learningware.com wrote:

> In the ValentinaSQL.pdf, under CREATE TABLE, there as entry for
> "deleteion_control"
>
> : "on delete" { "set null" | "restrict" | "cascade" }
>
> What does this do?  All of my db experience is with MySQL, so I'm not
> familiar with this specification.

Hi Andrew,

Please look into ValentinaKernel.pdf,
Section about ObjectPtr field.
Deletion control -- is one of properties of ObjectPtr.


In 2.0 we add Standard Foreign Key for RDB - links also.

--
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina