Introduction to PowerBuilder

Home	Previous Lesson: d_trans_data_entry_detail Next Lesson: d_error_info_display

d_transactions_monthly_rep

Property

Value

Data Source

SQL SELECT

Presentation Style

Crosstab

Tables

product_master, trans

Columns

tran_qty, tran_date from "trans" table. "product_description" from "product_master" table

Data Source definition

SELECT "product_master"."product_description", "trans"."tran_date", "trans"."tran_qty" FROM "product_master", "trans" WHERE ("trans"."tran_item_no" = "product_master"."product_no") and ((month("trans"."tran_date") = :a_month) AND (year("trans"."tran_date") = :a_year) AND ("trans"."tran_type" = :a_tran_type))

Other issues:

Join two tables on "product_no". The retrieval arguments are :a_month, :a_year and :a_tran_type. Datatype of the first two is number and the last one is a string.

Home Previous Lesson: d_trans_data_entry_detail
Next Lesson: d_error_info_display

Property	Value
Data Source	SQL SELECT
Presentation Style	Crosstab
Tables	product_master, trans
Columns	tran_qty, tran_date from "trans" table. "product_description" from "product_master" table
Data Source definition	SELECT "product_master"."product_description", "trans"."tran_date", "trans"."tran_qty" FROM "product_master", "trans" WHERE ("trans"."tran_item_no" = "product_master"."product_no") and ((month("trans"."tran_date") = :a_month) AND (year("trans"."tran_date") = :a_year) AND ("trans"."tran_type" = :a_tran_type))
Other issues:	Join two tables on "product_no". The retrieval arguments are :a_month, :a_year and :a_tran_type. Datatype of the first two is number and the last one is a string.