1. Home
  2. Labeling Software
  3. CODESOFT
  4. CODESOFT Error Messages
  5. ‘Table does not exist’ – CODESOFT Error Message

‘Table does not exist’ – CODESOFT Error Message

Bookmark(0)

Target Audience: Advanced User, IT Manager
Article #: 11237

Summary

CODESOFT generates an error message stating ‘Table does not exist’ under specific conditions:

  • Connecting to an Oracle database
  • Using the OLEDB driver from Oracle Client 11.2xx.xx
  • CODESOFT 2012 or later (up to 2019 as of this writing)

The error occurs while using CODESOFT in the design mode when you’re trying to define a Table lookup. This error occurs regardless of whether you are manually defining the Table lookup or using the Wizard.

In practice, the process proceeds normally until you try to save the Table lookup definition. Upon saving, you will receive the ‘Table does not exist’ error message. Making another attempt to save, will generate the message again. It appears that the number of times this message appears is directly related to the number of fields (columns) selected in the Table lookup.

Example: If the Table lookup has four columns, the error message will occur four times before finally saving on the fifth attempt.

However, after the Table lookup appears to have been correctly created, a look into the properties of each of the data fields reveals that the entered criteria for selecting the Table lookup is missing. Re-entering the information and testing it will result in a successful test. Unfortunately, clicking OK to save the Table lookup will once again generate the ‘Table does not exist’ error message.

Oracle OLEDB window with the Key Field area highlighted.

Explanation

We have confirmed with CODESOFT’s creator, Teklynx, that this is a defect in the software.

Solution

Fortunately, we have found that there is a work-around that can avoid the problem. Follow these steps:

STEP 1: Run CODESOFT in OldUI mode – C:\Program Files (x86)\Teklynx\CODESOFT 2018>lppa.exe /OldUI

STEP 2: Create a “When printed” variable that will be used as a key for the table lookup.

STEP 3: Start a Table lookup variable creation and select the SQL button.

Table lookup window with SQL creation button selected.

STEP 4: Enter the SQL query using the full table name to reference the field in the database and press OK.

You can now open this label in a new designer and continue with the label creation.

Additional Notes

IMPORTANT! DO NOT adjust the Table lookup variables in the new designer without being int the OldUI mode. Additionally, even opening the Table lookup properties dialog will corrupt the variable. This corruption cannot be undone by clicking the Cancel button. Under the conditions described at the beginning of this article, any modifications to a Table lookup should only be performed in OldUI mode.

Updated on August 28, 2020

Was this article helpful?

Related Articles

Need Help?
Click the link below to submit a support ticket
Submit Ticket