At 06:47 AM 3/2/2008, [EMAIL PROTECTED] wrote:
I notices that in table Levels-there is a PFK key. When would that be used?
For a better understanding of PRIMARY and FOREIGN KEYS in R:BASE, refer to:
From The Edge: http://www.razzak.com/fte/
Topic: All About Constraints in R:BASE (08/21/2006):
. Types and Definitions
. Primary Key
. Foreign Key
. Not Null
. Unique Key
. Benefits of Constraints
. Adding CASCADE to Maintain Primary/Foreign Key Relationship
. Defining Constraints
. Listing Constraints
. LIST CONSTRAINTS
. LIST PKEYS
. LIST PKEYS for tablename
. LIST FKEYS
. LIST FKEYS for tablename
. LIST UKEYS
. LIST UKEYS for tablename
. Removing Constraints
. Customizing Constraint Violation Messages
Additional Topics:
. Using Enhanced CASCADE Options in R:BASE (05/21/2007)
. Indexing Explained (06/20/2007)
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
