Ok,
Now I have another issue that I can not get around. Any Idea why I get this error R>Alter Table Customer Add Primary Key (CustNub2) -ERROR- Column CUSTNUB2 must be declared explicitly NOT NULL. (2722) Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Thursday, November 20, 2008 11:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Command for setting Primary and Forign keys intable Foreign keys can be set in the database to not include indexes unless specfically required. Check out the fast key option. Emmitt Dove wrote: > > ... ADD FOREIGN KEY not Index > > The help diagram shows index as an option, but I've never seen it used > and honestly don't know how it will differ from the key, but the key > is an index and will not let you insert a record with a value that > doesn't exist in the referenced table which, after all, is the point > of primary/foreign keys. > > Emmitt Dove > > Manager, DairyPak Business Systems > > Evergreen Packaging, Inc. > > [EMAIL PROTECTED] > > (203) 214-5683 m > > (203) 643-8022 o > > (203) 643-8086 f > > [EMAIL PROTECTED] > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Steve Breen > *Sent:* Thursday, November 20, 2008 9:20 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - RE: Command for setting Primary and Forign keys > in table > > Tell me if I am right on Primary > > Alter Table Customer Add Primary Key Case (Custnub2) > > Tell me if I am right on Foregin Key > > Alter Table CustContact Add Foreign Index (Custnub2) References Customer > > Thanks > > Steve > > ------------------------------------------------------------------------ > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Emmitt Dove > *Sent:* Thursday, November 20, 2008 8:57 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - RE: Command for setting Primary and Forign keys > in table > > Steve, > > Try HELP ALTER. > > Emmitt Dove > > Manager, DairyPak Business Systems > > Evergreen Packaging, Inc. > > [EMAIL PROTECTED] > > (203) 214-5683 m > > (203) 643-8022 o > > (203) 643-8086 f > > [EMAIL PROTECTED] > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Steve Breen > *Sent:* Thursday, November 20, 2008 8:50 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Command for setting Primary and Forign keys in > table > > Can someone give me an example of seeting a primary and forign key in > a table from a R: Prompt. > > Thanks, > > Steve >
