Larry, I am confused here. I am using the 6.5++ utilites and it will allow me to set a primary key on custnub2 which is a text column but when I try to do it from a R: prompt it will not let me.
Gives me errors like it all ready has a index. Then after dropping Index I get -ERROR- As column CUSTNUB2 is used in another table, its type cannot be redefined Not sure which way to go? Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, November 20, 2008 1:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Command for setting Primary and Forign keys intable << 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) >> For exactly the reason stated in the error message. Any column that participates in a primary key must be explicitly NOT NULL as part of its declaration. ALTER TABLE Customer ALTER COLUMN CustNub2 **INTEGER** NOT NULL (I'm assuming your field in integer -- you might have another datatype). This alter will fail if there are any NULL values in Customer.CustNub2. -- Larry
