Look to see if the column you renamed is used in a computed field or view in addition to what Steve mentioned. Also look at any rules and recheck any indexes. Bill Eyring
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 8:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Invalid field definition for: surgproc1 We are currently using 6.5++. We have several tables with a column called surgproc1 INTEGER. We must redefine this col. as text. Since it is in multiple tables, I first used the following to redefine the col. to a new name and to text: ALTER TABLE table1 ALTER COL surgproc1 TO sproc1 TEXT (6). I this did for all tables with col. surgproc1 except for the last one where I did the following: ALTER TABLE dailycases ALTER COL sproc1 TO surgproc1 TEXT (6). Next, I did the following on all the other tables: ALTER TABLE table ALTER COL sproc1 TO surgproc1 TEXT (6). Now when I edit with a form on one of the tables, I get the subject error message. None of my forms use surgproc1 in its expressions . ; Does anyone know why?
