Question:
How can I display, at runtime, the set of values added to the Formula’s Values tab?
Solution:
These values are saved on a table called tablenames_Values. To access these values at runtime, you must run, via scripts, an SQL query’s GetADORecordset() function and then use its return value.
The example below runs all records from E3Browser’s Query1 (which displays values from tablenames_Values table), with name property shown via a MsgBox:
Set RS = Screen.Item(“E3Browser1”).Item(“Query1”).GetADORecordset()
For aux = 1 To RS.RecordCount
MsgBox RS.Fields.Item(“name”).Value
RS.MoveNext
Next
