Today brought a fun error when attempting to bring up a lookup table for deletion in SoftPro Classic Enterprise SQL. Standard has a similar process.  After pressing F9 an error showed up, SoftPro ProForm threw a SPFUNCS-233, Unable to initialize Look-up Recordset. Return Code = –1 Error Message Text = Invalid column name ‘TITLCON’. Invalid column name ‘TITLNAM’ statement(s) could not be prepared.

The column names will vary based on the lookup table’s setup. The cure was simple.  Locate the table in the ProFormLookups database and add the displayed columns to the table using SSMS.  Since this was an effort to delete the table, the column data type wasn’t important, we used char(50). 

To continue using the table and determine the proper column types, create a new lookup table with the offending columns in it, us that as a map to add the columns to the wanted lookup table.

The other method to fix this would be remove the rows from ProFormLookups TableSpecs table that have the correct KeyFieldName and ColumnName columns.  That is significantly harder process and more dangerous, column Rank should be reset to consecutive integers for the rest of the KeyFieldName matches.. In Standard TableSpecs and TableMap reside in a text files PfPxLkup*.Lku, and are harder to deal with than the SQL TableSpecs table..