Hi everyone,
We've implemented an auto-lookup for address data using @cursor_from_col_id. When both a zip-code and a house number is filled, the street name and city is retrieved. This works great.
The table that contains the address data has over 9 million rows. Searching takes a few seconds. From a usability point of view, we would like to show an hour glass once the searching is starting in the fields that will be automatically filled.
We tried setting the field variables to the ASCII hour glass (⧗) manually, have two temporary variables filled with a SELECT statement that retrieves the data, and once the temp variables are filled, move their contents to the field variables. However, a field can't seem to set to a value more than once. So, we don't see the hour glass at all. Instead, the fields remain blank, until the data is retrieved from he database.
How would we set up a spinner sort of thing correctly, so that the user has visual confirmation that activity is going on? The form itself remains active, and the user can proceed with filling other fields while the search is being performed. Has anyone implemented something like this successfully in Universal?
Best regards,
- Alex.
