Hi paulo,
Im working on a project for which i can View a set of parameters of Database for required time period in E3 browser …
i would like to see only a selected fields using combination box .
here i want to make a flexible query which can be scripted and performed after clicking a command button.
so can u plz guide me how to configure in E3 Query for the same.
Hi Srikanth!
Do you want to change the table or just choose the fields that will be shown in E3Browser?
HI paulov…
ya i just want to see the values in E3 Browser which i choose from a field /combo box…
Hi paulo,
Please refer the attached images for clarity,
In this image u can see my project screen , here im using a combox-1 where i can see the fields which have selected for this i have used a script Sub combobox1_OnStartRunning()
Clear()
set fields = Screen.Item(“Query1”).GetE3QueryFields()
for each field in fields
AddItem field.ColumnName
next… and when i press view data button only those values need to appear on my E3browser which i have selected in Comobox-1…
above is my sql data image.
please help me out how to get only selected field in E3 browser…
Dear Srikanth,
The Button’ script should be something like this:
Set ComboBox = Screen.Item(“ComboBox1”)
Set Browser = Screen.Item(“E3Browser1”)
Set Field = Browser.Fields.Item(ComboBox.Value)
Field.Visible = true
