|
Advanced PowerBuilder
Exercises:
Please complete the following exercises. We advise you not
to download the solution until you complete the exercises. Reading the solution without
completing the exercise might make things tougher in your real-life projects, since you
never tried the code before. If you have any questions, you can always e-mail me at prasad@applied-software.com
| # |
Problem Description |
| 1. |
We
didn't write script to print the transaction in "w_transactions" window. Provide
that functionality to the user.
Tip: It would be very
tedious to print multiple DataWindows on the same page. You may want create another
DataWindow object with group presentation style and assign it to a hidden DataWindow
control or use the DataStore object ( Go for hidden DataWindow control instead of
DataStore since this topic is not covered yet ). Another tip: RowsCopy() function.
Solution: - ex-11-1.zip |
| 2. |
While entering the
transactions, we are displaying the product information when the user tabs out of the
"tran_item_no" field. We didn't give the functionality to display the product
information when the user moves between rows using keyboard or when clicking with the
mouse button in the "dw_tr_detail" DataWindow. Provide this functionality. Tip: Write script in the "RowFocusChanged"
event.
Solution: - ex-11-2.zip |
| 3. |
There is no delete
functionality in the "w_transaction" window. Provide that functionality. User
should be able to delete a row in the "dw_tr_detail" DataWindow and also he
should be able to delete the header info record from the "dw_tr_head"
DataWindow. When (s)he tries to delete from the header DataWindow, delete the whole
transaction. Tip: Read the code for the
"ue_add" event and get an idea about what to write.
Solution: - ex-11-3.zip |
| 4. |
Do you remember writing
script for ue_query and ue_retrieve events in w_product_master window. We need to provide
similar functionality, i.e., query & retrieve functionality in w_transactions window
also. You may want to use a different DataWindow for query & retrieve purposes. When
you retrieve data, make the results DataWindow read-only. Double-clicking on a record in
the results DataWindow should display dw_tr_header and dw_tr_detail DataWindows, and allow
the user to edit the clicked record in those DataWindows. When the focus is in the results
DataWindow, selecting 'Print Preview' or 'Print' options from the menu should act on the
results DataWindow. In the query mode, allocate the whole window space for this purpose. Tip: You may use the DataWindow control used to
print a transaction. However, create a different DataWindow object for this purpose. Use Modify() function to put the DataWindow in read-only mode and vice-versa.
Use ItemChanged event to set the focus to detail DataWindow and
"tran_serial_no" field.
Solution: - ex-11-4.zip |
| 5. |
This exercise is not
part of the project. This exercise will give you good experience in using PowerScript and
in using various functions and events. Create a window as shown below. 
The functionality of this window is to allow the user to
select a table owned by him/her. Upon table selection, the script should
bring the columns for the selected table and display them in a list box, as shown in the
step 2. You should allow the user to select multiple columns from the listbox. Allow the
user to select the presentation style of the report (s)he wants. When every thing is
selected, and when the user clicks on the CommandButton shown in step 4, generate the
SELECT statement for the selected table depending on the columns selected and create a
DataWindow dynamically and display it to the user. If the user doesn't select any column,
display all columns in the selected table for the report. If the user doesn't select
any presentation style, set the default to 'Grid'.
Tips:
1. You can get table listing from 'systable' table and column listing from 'syscolumn'
table.
2. Current user id can be obtained using user_id().
3. Check the available presentation styles for dynamic DataWindows.
4. DataWindow control can be used to bring table & column names.
Solution: - ex-12-5.zip |
|
