[RBASE-L] - Re: Invalid field definition for: surgproc1

[Steve Johnson]

Because you changed the field definition from integer to text, the form tables need to be updated. Just go to each form using surgproc1, highlight the data field and then save the form (you should be asked to save the form as you exit).  Then the form should work. By the way, you may have to do this same procedure with reports and labels that use the same column.

Steve

At 08:57 PM 5/6/2008, you wrote:

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?