[BM V8i] Problem with lookup table

Hi,

I am working on cleaning of customer's project (as a part of preparation to be migrated to CE and/or to spatial SQL Server) and I found a weird problem:

It's old "mslink based" project, where all graphics is in DGNs and all data are in SQL Server.

There is a table that works as lookup table for several features. Its structure is quite simple, just MarkID, ClassID and MarkName, where ClassID represents (with some simplification) individual features, so when CombBox SQL domain list is defined as SELECT MarkID as ID, Markname as Display FROM LookupTable WHERE ClassID = <number>, it allows to maintain one central list of all "marks" (cells) and to extract a list of values valid for individual features.

It works fine, but I found out one feature (maybe there are more) that is created correctly, all data are commited also exactly as entered (so MarkID from looku table is used). But when queried (both edit and in analyze result dialog), the lookup id is not "converted back" to human friendly name from lookup table (as displayed in ComboBox), but is displayed as a plain integer.

I compared the definition with other features, where the same lookup table works fine (only used ClassID number is different), but I did not find any difference. Originally I thought it's because of wrongly defined foreign key, but other features work fine even without FK exists and CombBox  DomainList SQL is used.

The only difference I have found so far is when I use "session debug xfm all" key-in and I try to review a feature properties (glasses icon), in debug dialog for every ComboBox defined as SQL domain list, separate information similar to this one

appendPropertiesToCacheFromSQL Num columns=6  
...
appendPropertiesToCacheFromSQL Property #5 [ZnackaDruhId] Value[23]
...
DomainList SQL[SELECT VodDruhUzluID as ID, VodDruhUzluNazev as Display FROM VodDruhUzlu] Parsed[SELECT VodDruhUzluID as ID, VodDruhUzluNazev as Display FROM VodDruhUzlu] shouldCache=F

is displayed.

For features with no problems all DomainLists are mentioned, for the problematic feature one (defining values from lookup table) is missing. The property and its value (id that can be used to search in lookup table) is displayed, but the domain is not created.

I have no idea what to check further and based on what definition (somewhere deep inside XFM schema xml project, outside the feature definition?) the list of domains is created.

As the last chance I see to try to create the whole feature definition from scratch, but it would be long work as it contains more properties, SQL queries and well designed dialog(s).

With regards,

  Jan