Re: alter table rbwin65 1.858b

[David M. Blocker]

Bernard   Two possibities   If PartNo is an exist column, the correct syntax is:   ALTER TABLE PODETAIL ALTER PARTNO TO PARTNO TEXT 27   Or, "REFERENCED TABLE" implies that PODETAIL has a foreign key referencing another table.  WHen R:Base alters the table it may be checking all the other constraints, etc in the table and there may be a table you're removed that used to be the referenced PK.   David Blocker   ----- Original Message ----- From: Bernard Lis To: [EMAIL PROTECTED] Sent: Friday, September 20, 2002 11:17 AM Subject: alter table rbwin65 1.858b Alter table 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.