Trust ID PBCEX logo 300x102

Strange issue with V4 and dropdown retrieving from table

12 years 9 months ago
JeroenH
Fresh Boarder
Fresh Boarder
Posts: 13
More
Topic Author
Strange issue with V4 and dropdown retrieving from table #52
If I connect to an SQL database including a table for lookup usage,
got an error (see attachment) :o
Attachments:
12 years 9 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Strange issue with V4 and dropdown retrieving from table #55
Hi Jeroen,

Cause: Thanks for being one of the first that posts a bug-report the forum. The problem occurs when you select the drop-down menu with the lookup table option and then leave either the table name or one of the column names to the value that CardExchange selects by default. This value is not stored in the data definition and the SQL that is subsequently generated for loading the values from the lookup table misses table or column names. As if that were not enough, CardExchange shows an error message that doesn't make much sense. “An error occurred while loading the list of names” should rather be of “An error occurred while loading the lookup table i]name[/i.

Work-around:You can work around this problem by selecting another item from the drop-down menu and then select the first item again. When explicitly selecting a table or column name it is correctly stored.

There is actually another bug here. If you select different column names for the storage and the display values, you will find out that CardExchange uses them the wrong way around. So I ended up with the following bug fixes that will be released in version 4.1:

  • Bug fix: When a drop-down menu with a lookup table was defined in column-settings page of the data-definition wizard and a table or column name that was selected by default (the first one in the list) was not modified, the corresponding name was not stored and CardExchange produced incorrect SQL giving errors of the type “An error occurred while loading the list of names. An object or column name is missing or empty.”
  • Bug fix: For drop-down menus with a lookup table, the display and storage values were interchanged, causing the storage value to be shown and the display value to be stored.
  • Bug fix: When an error occurred while loading values from a lookup table, the error message shown read “An error occurred while loading the list of names” instead of “An error occurred while loading the lookup table i]name[/i.”
[/color]

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)