Next, choose your DataWindow, display column, and data column. The display column is the kind of data that's displayed to the user. The data column value is the one that's saved into the database.You might also consider checking the "V ScrollBar" property. This is something a lot of users forget; when you test your application, you have just a few rows in your DDDW. When you go into production you'll have a lot of rows there, but now the user can't scroll with the mouse to these rows.
Now we'll start by describing some problems beginners frequently run into when they are using DDDWs.
The main problem we come across is that the DDDW will not be refreshed for the latest value from the database, if we added some value from the current datawindow. Refreshing whole datawindow is not a good idea. We can retrieve the particular column of the DropDownDatawindow. That too with a sing user event to refresh all the DropDwonDatawindow columns in the current datawindow.
Here is how to do this.
We need to create a new event for the Datawindow with the Event Id pbm_dwndropdow. In that event we will use the child datawindow concept.
- Declare to datawindow variable as dwc_child
- Use the getchild() function to assign the column to child datawindow as below
this.getchild(this.getcolumnname(), dwc_child)
- Then use the settransobject (The transaction object provides the information necessary for communicating with the database.)
- Finally use the retrieve() .
