skip to main content
OpenEdge Development: AppBuilder
Data-Display/Capture Objects : Dynamic SmartDataBrowser
 
Dynamic SmartDataBrowser
The dynamic SDB is capable of displaying and updating records supplied by any SDO. You make the connection and set up the conditions at design time.
Creating a dynamic SmartDataBrowser instance
Use the Object Palette to place a dynamic SDB.
To create, place, and configure a dynamic SmartDataBrowser:
1. First create and place an appropriate SDO to supply the data stream the Browser will display.
2. Right‑click the SmartDataBrowser in the Object Palette and choose Dynamic SmartDataBrowser from the menu that opens.
3. Position your mouse cursor over the workspace and click to place the object. It appears as a Browse widget, initially with only a single column, as shown:
4. AppBuilder immediately opens an Advisor window if it finds opportunities to create SmartLinks to other objects. Examine the recommendations and accept all that seem appropriate.
5. Click on the Menu button and select Instance Properties from the menu. The following dialog box appears:
6. If you wish to display or allow updates to fewer fields than the SDO would permit, make those changes now. Click the appropriate button to open a selector dialog. See Table 10 for a description of how AppBuilder makes use of your choices.
 
Table 10: Dynamic SmartDataBrowser display/update rules 
Your choice
AppBuilder response
Display
Update
Make no changes.
Display all fields provided by the SDO (the value of the DataColumns property).
Allow updates on all fields enabled in the SDO (the value of the UpdatableColumns property).
Specify only the display list.
Display the fields you chose.
If there is a TableIO source, then allow updates on all fields that are enabled in the SDO, if they are also being displayed.
If no TableIO source, then allow no updates at all.
Specify only the enabled list.
Display all fields provided by the SDO (the value of the Data Columns property).
Allow updates on the fields you chose.
Specify both the display list and the enabled list.
Display the fields you chose.
Allow updates on the fields you chose.
7. If you wish to allow the user to search on one of the displayed fields, select it from the Search Field combo box.
8. Clear the Enable and View check boxes to initialize the object in a hidden, insensitive state.
9. Set the Down value to the number of rows you wish the browser to display. If you wish the object to determine its own best width, check the Calculate Width box and, if desired, enter a Max Width limiting value.
Note: The design‑time representation does not account for the Down and Width choices you make, so you cannot predict the run‑time appearance from it. You will need to experiment to determine how to get the run‑time appearance you desire. A good first approximation for number of lines might be to show 1 or 2 more lines than your Down setting (1 to account for the column‑labels line, and a second if there will be a horizontal scroll bar)
10. Unless the total number of records in the data stream is same or less than the Rows To Batch value, the user will not be able to use the scroll bar to reach the last record. The last record reachable by using the scroll bar is the last record in the buffer, not the last record in the data stream. This can be confusing to the user.
To solve this problem, check the Scroll Remote Results List box. You might also have to write some code. For more information see the “Scrolling to the last record in the data stream” section.
11. Check the Use sort indicator toggle if you want a graphical arrow to display in the column label to show the sort column and direction.
Unless you need to add special logic, the dynamic browser will typically be a lower‑cost choice than a static browser.