Bernie, I'm using 1.855Xrt03. I'm not sure if it matters but, did you try using Text (27)" with the parenthesis?
ALTER TABLE PoDetail ALTER COLUMN PartNo TEXT (27) NOT NULL Rich -------Original Message------- From: [EMAIL PROTECTED] Date: Friday, September 20, 2002 2:28:00 PM To: [EMAIL PROTECTED] Subject: Re: alter table rbwin65 1.858b William, Buddy, Richard, Are u using 1.858b? I still get the same error. It was ok before installing patch B Could this be a bug in latest release of 1.858 This worked b4 1.858b. I have a bunch of these in a run file w/o the word column and they worked. ----- Original Message ----- From: "William Cook" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 1:06 PM Subject: Re: alter table rbwin65 1.858b > Perhaps this might work? > > Alter table podetail alter COLUMN partno text 27 not null > > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 20, 2002 9:17 AM > Subject: alter table rbwin65 1.858b > > > > Altertable podetail alter partno text 27 not null > > gives the error "The referenced table does not exist" > > > > The table does exist as proved by "list podetail" > > > > I checked the spelling very carefully. So what's wrong here? > > Can anyone help? > > > > Bernie Lis > > Megabytes, Inc. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ . ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
