Hi,I have a categorized view “Demo” with 2 columns.
I have a field on the form, which is a dialog list type and depending on what the value of DemoField is, it will bring up a view selection with only those values.
@DbLookup(“”:“NoCache”; “”; “Demo”; DemoField ;2)
It gives me error “Entry not found in index”. However, when I type in “DemoData”, it displays the values from the view in the dialog list field, but as soon as I put the field name instead of the actual data, it gives the error. I have checked, the DemoField contains the data.
Subject: Entry not found in index, but it exists and column is sorted.
Make sure that you use the correct format (text, number, etc) and make sure that you do not have any trailing spaces or other unprintable characters in the values.
Subject: Entry not found in index, but it exists and column is sorted.
Are you certain “DemoField” contains what you think it does? Use @Prompt temporarily to display the value (perhaps with something like “—” either side, to check for spaces, etc.).