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?
