Bernie - If you have time to try to replicate the problem and can - please DO send it to the RDCC - the RBDefine screens should work fine to add/delete a PK.
Sami > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis > Sent: Tuesday, July 27, 2004 7:14 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Primary key > > > Hi Sami, > I was using 76. Single user ( at home on my development computer ) > Do you think I should report this, I could try to duplicate it on > a copy of > my database. > Bernie > ----- Original Message ----- > From: "Sami Aaron" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, July 27, 2004 9:53 AM > Subject: [RBG7-L] - Re: Primary key > > > > Bernie - > > > > What build of 7.x are you using? Were you in multi-user mode > with another > > session running when you made your structure changes? > > > > I reported a bug in build 73 - when changing table structure in > multi-user > > mode, I would be left with two tables - one named with numbers > and letters > > only. This was fixed in build 74. > > > > Sami > > > > ------------------------------------------ > > Sami Aaron > > Software Management Specialists > > 19312 W 63rd Terr > > Shawnee KS 66218 > > 913-915-1971 > > mailto:[EMAIL PROTECTED] > > www.softwaremgmt.com > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Bernard Lis > > > Sent: Monday, July 26, 2004 2:15 PM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Re: Primary key > > > > > > > > > Razzak, > > > Now that was easy - why didn't I think of that? > > > All fixed! > > > Thank you very much, > > > Bernie Lis > > > > > > But is there a problem when removing a primary key. > > > Work-a-round: don't remove a primary key! > > > > > > ----- Original Message ----- > > > From: "A. Razzak Memon" <[EMAIL PROTECTED]> > > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > Sent: Monday, July 26, 2004 3:05 PM > > > Subject: [RBG7-L] - Re: Primary key > > > > > > > > > > > > > > At 02:30 PM 7/26/2004 -0400, Bernie Lis wrote: > > > > > > > > >If I can get rid of the table, I can easily reconstruct it. > > > > >But is there a way using rscope to make it deleted? > > > > > > > > CONNECT dbname > > > > SET NULL -0- > > > > OUTPUT NewDatabase.ALL > > > > UNLOAD ALL > > > > OUTPUT SCREEN > > > > DISCONNECT > > > > RENAME dbname.RB? dbnameX.RB? > > > > RBEDIT NewDatabase.ALL > > > > -- fix the file accordingly and save > > > > INPUT NewDatabase.ALL > > > > > > > > You may TRACE NewDatabase.ALL to see the entire database > > > > being build and note -ERROR-s, if any. > > > > > > > > Very Best R:egards, > > > > > > > > Razzak. > > > > > > > > > > > > > > > > > > > > > > > >
