Introduction to PowerBuilder

Home	Previous Lesson: d_product_custom_query Next Lesson: d_products_maint

d_display_product

Property

Value

Data Source

SQL SELECT

Presentation Style

Free Form

Tables

product_master

Columns

All

Data Source definition

SELECT "product_master"."product_no", "product_master"."product_description", "product_master"."product_balance", "product_master"."product_reorder_level", "product_master"."product_measuring_unit" FROM "product_master" WHERE "product_master"."product_no" = :a_product_no

Other issues:

:a_product_no is a retrieval argument. Screen is same as "d_product_custom_query" DataWindow. Set product_measuring_unit edit style to DDDW (d_units_dropdown).

Home Previous Lesson: d_product_custom_query
Next Lesson: d_products_maint

Property	Value
Data Source	SQL SELECT
Presentation Style	Free Form
Tables	product_master
Columns	All
Data Source definition	SELECT "product_master"."product_no", "product_master"."product_description", "product_master"."product_balance", "product_master"."product_reorder_level", "product_master"."product_measuring_unit" FROM "product_master" WHERE "product_master"."product_no" = :a_product_no
Other issues:	:a_product_no is a retrieval argument. Screen is same as "d_product_custom_query" DataWindow. Set product_measuring_unit edit style to DDDW (d_units_dropdown).