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. > > > > > >
