Phil,
In forming this reply I failed to notice that you are not on the
latest version. the LIST PKEY command is not available in your
version. Just do a LIST CONSTRAINTS and find the blockcodes
name in that listing and the names of any FOREIGN KEYS if
applicable.
Sorry for slight miss info.
Jim Bentley
--- James Bentley <[EMAIL PROTECTED]> wrote:
> Phil,
>
> In order to drop a PRIMARY KEY or any key for that matter you
> need to know the "NAME" assigned by RBase. Do the following
> at
> an R> LIST PKEY FOR blockcodes
> The first column is the name assigned by RBase
> If this column is referenced by other foreign keys you will
> need
> to drop the FOREIGN KEYS first.
>
> Correct syntax is
> ALTER TABLE blockcodes DROP CONSTRAINT constraintname
> Where constraintname is the one found above
>
> Jim Bentley
> --- Bernard Lis <[EMAIL PROTECTED]> wrote:
>
> > Hi Phil,
> > since optcode exists in other tables, you will have to
> rename
> > it in those tables first
> > then
> > You could create another column OptcodeTxt text 6
> > then
> > update BlockCodes set OptCodeTxt = (ctxt(OptCode))
> > then
> > alter table BlockCodes drop col OptCode
> > then
> > ren col OptcodeTxt to OptCode in BlockCode
> >
> > Have fun,
> > Bernie Lis
> > ----- Original Message -----
> > From: [EMAIL PROTECTED]
> > To: RBASE-L Mailing List
> > Sent: Thursday, April 24, 2008 10:26 PM
> > Subject: [RBASE-L] - Alter table in 6.5++
> >
> >
> > We are currently on Rbase 6.5++. I defined a table and
> its
> > primary key with the following commands:
> > CREATE TABLE blockcodes +
> > (cptcode INTEGER NOT NULL,+
> > blockcatcode INTEGER,+
> > epidural TEXT (1) DEFAULT 'N' NOT NULL)
> > ALTER TABLE blockcodes ADD PRIMARY KEY (cptcode) +
> > ('cptcode already on file.', +
> > 'Cannot delete--value exists in another table.', +
> > 'Cannot update--value exists in another table.')
> >
> > I now need to redefine cptcode to a text field. I tried
> the
> > following: ALTER TABLE blockcodes ALTER cptcode TO cptcodet
> > TEXT (6). Rbase gave me the following error: -ERROR-
> Column
> > cptcode is indexed and may not be altered. (1143). Cptcode
> is
> > the primary key of the blockcodes table so I tried to
> removed
> > it with the following: ALTER TABLE blockcodes DROP
> CONSTRAINT
> > PRIMARY KEY (cptcode). This gave me the error: -ERROR-
> > Invalid constraint identifier. (2743).
> >
> > Can someone advise how I can redefine the cptcode column
> as
> > text or how to remove the primary key from the table?
> >
> > Thanks a bunch,
> > Phillip Cecil
>
>
> Jim Bentley
> American Celiac Society
> [EMAIL PROTECTED]
> tel: 1-504-737-3293
>
>
>
>
____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
