Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

SoftPro (SPFUNCS-233) Error Unable to initialize Look-up Recordset

clip_image002

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..

Help support the site when shopping on Amazon, click through any ad to get to Amazon, ignore that product, then buy whatever you're there for. Thanks for helping out.
Category: General

Your email address will not be published. Required fields are marked *

*

css.php