{"id":1010,"date":"2015-04-28T10:47:32","date_gmt":"2015-04-28T15:47:32","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=1010"},"modified":"2015-04-28T10:47:32","modified_gmt":"2015-04-28T15:47:32","slug":"softpro-spfuncs-233-error-unable-to-initialize-look-up-recordset","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/softpro-spfuncs-233-error-unable-to-initialize-look-up-recordset\/","title":{"rendered":"SoftPro (SPFUNCS-233) Error Unable to initialize Look-up Recordset"},"content":{"rendered":"<p><a href=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2015\/04\/clip_image002.jpg\"><img data-recalc-dims=\"1\" decoding=\"async\" title=\"clip_image002\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; float: left; padding-top: 0px; padding-left: 0px; margin: 0px 10px 0px 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"clip_image002\" src=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2015\/04\/clip_image002_thumb.jpg?resize=299%2C156\" width=\"299\" align=\"left\" height=\"156\"><\/a><\/p>\n<p>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.&nbsp; After pressing F9 an error showed up, SoftPro ProForm threw a SPFUNCS-233, Unable to initialize Look-up Recordset. Return Code = \u20131 Error Message Text = Invalid column name \u2018TITLCON\u2019. Invalid column name \u2018TITLNAM\u2019 statement(s) could not be prepared.<\/p>\n<p><!--more--><\/p>\n<p>The column names will vary based on the lookup table\u2019s setup. The cure was simple.&nbsp; Locate the table in the <strong>ProFormLookups<\/strong> database and add the displayed columns to the table using SSMS.&nbsp; Since this was an effort to delete the table, the column data type wasn\u2019t important, we used char(50).&nbsp; <\/p>\n<p>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.<\/p>\n<p>The other method to fix this would be remove the rows from ProFormLookups <strong>TableSpecs<\/strong> table that have the correct <strong>KeyFieldName<\/strong> and <strong>ColumnName<\/strong> columns.&nbsp; That is significantly harder process and more dangerous, column <strong>Rank<\/strong> should be reset to consecutive integers for the rest of the <strong>KeyFieldName<\/strong> matches.. In Standard <strong>TableSpecs<\/strong> and <strong>TableMap<\/strong> reside in a text files <strong>PfPxLkup*.Lku<\/strong>, and are harder to deal with than the SQL <strong>TableSpecs<\/strong> table..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.&nbsp; After pressing F9 an error showed up, SoftPro ProForm threw a SPFUNCS-233, Unable to initialize Look-up Recordset. Return Code = \u20131 Error Message Text = Invalid column name \u2018TITLCON\u2019. Invalid [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-1010","post","type-post","status-publish","format-standard","hentry","category-general","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-gi","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=1010"}],"version-history":[{"count":1,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1010\/revisions"}],"predecessor-version":[{"id":1011,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1010\/revisions\/1011"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}