d_ff_sales_order

demopfc.pbl   >   d_ff_sales_order

   SELECT "sales_order"."id",             "sales_order"."cust_id",             "sales_order"."order_date",             "sales_order"."fin_code_id",             "sales_order"."region",             "sales_order"."sales_rep",             "employee"."emp_lname",             "employee"."emp_fname",             "customer"."lname",             "customer"."fname",             "sales_order"."total_ht"       FROM "sales_order",             "customer",             "employee"      WHERE ( "customer"."id" = "sales_order"."cust_id" ) and            ( "employee"."emp_id" = "sales_order"."sales_rep" ) and            ( ( "sales_order"."id" = :sales_order_id  ) )     

 detail
 - List of objects belonging to this band 
 b_customer of type DWButton
 customer_fname of type field 
 customer_lname of type field 
 employee_emp_fname of type field 
 employee_emp_lname of type field 
 p_1 of type DWBitmap
 sales_order_cust_id of type field 
 sales_order_cust_id_t of type DWText
 sales_order_fin_code_id of type field 
 sales_order_fin_code_id_t of type DWText
 sales_order_id of type field 
 sales_order_id_t of type DWText
 sales_order_order_date of type field 
 sales_order_order_date_t of type DWText
 sales_order_region of type field 
 sales_order_region_t of type DWText
 sales_order_sales_rep of type field 
 sales_order_sales_rep_t of type DWText
 

 footer
 

 summary
 

 Field
 - Field associated with column "customer.fname"
 - A maximum of 15 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: First name of the customer
 

 Field
 - Field associated with column "customer.lname"
 - A maximum of 20 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: Last name of the customer
 

 Field
 - Field associated with column "employee.emp_fname"
 - A maximum of 20 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: First name of the employee
 

 Field
 - Field associated with column "employee.emp_lname"
 - A maximum of 20 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: Last name of the employee
 

 Dropdown Datawindow
 - Field associated with column "sales_order.cust_id"
 - Optional field.
 - A maximum of 0 characters can be entered.
 - Left aligned field.
 - Associated DropDownDatawindow: d_tab_employee
 - Displayed at: 700%
 

 Dropdown Datawindow
 - Field associated with column "sales_order.fin_code_id"
 - Optional field.
 - A maximum of 0 characters can be entered.
 - Right aligned field.
 - Tag value: Financial Code
 - Values: 
 - Associated DropDownDatawindow: d_tab_fin_cod
 - Displayed at: 400%
 

 Field
 - Field associated with column "sales_order.id"
 - A maximum of 0 characters can be entered.
 - Required field.
 - Right aligned field.
 - Tag value: Sales order ID
 

 Field
 - Field associated with column "sales_order.order_date"
 - A maximum of 0 characters can be entered.
 - Required field.
 - Center aligned field.
 - Initial value: today
 - Display format: DD/MM/YYYY
 - Tag value: Date Ordered
 

 Dropdown
 - Field associated with column "sales_order.region"
 - Optional field.
 - A maximum of 0 characters can be entered.
 - Left aligned field.
 - Tag value: Region
 - Sorted list
 - Values: 
 	Central Central
 	Eastern Eastern
 	South South
 	Western Western
 	Canada Canada
 

 Dropdown Datawindow
 - Field associated with column "sales_order.sales_rep"
 - Optional field.
 - A maximum of 0 characters can be entered.
 - Right aligned field.
 - Tag value: 
 - Associated DropDownDatawindow: d_tab_salesperson
 - Displayed at: 420%
 

 Field
 - Field associated with column "sales_order.total_ht"
 - Required field.
 - Left aligned field.
 

 DWBitmap

 DWButton

 Static Text

 Static Text

 Static Text

 Static Text

 Static Text

 Static Text

release 7;
datawindow(units=0 timer_interval=0 color=78682240 processing=0 HTMLDW=no print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no )
summary(height=0 color="-1" )
footer(height=0 color="-1" )
detail(height=384 color="536870912" )
table(column=(type=long update=yes updatewhereclause=yes key=yes name=sales_order_id dbname="sales_order.id" )
 column=(type=long update=yes updatewhereclause=yes name=sales_order_cust_id dbname="sales_order.cust_id" )
 column=(type=datetime update=yes updatewhereclause=yes name=sales_order_order_date dbname="sales_order.order_date" initial="today" )
 column=(type=char(2) update=yes updatewhereclause=yes name=sales_order_fin_code_id dbname="sales_order.fin_code_id" values="" )
 column=(type=char(7) update=yes updatewhereclause=yes name=sales_order_region dbname="sales_order.region" values="Central	Central/Eastern	Eastern/South	South/Western	Western/Canada	Canada" )
 column=(type=long update=yes updatewhereclause=yes name=sales_order_sales_rep dbname="sales_order.sales_rep" )
 column=(type=char(20) updatewhereclause=yes name=employee_emp_lname dbname="employee.emp_lname" )
 column=(type=char(20) updatewhereclause=yes name=employee_emp_fname dbname="employee.emp_fname" )
 column=(type=char(20) updatewhereclause=yes name=customer_lname dbname="customer.lname" )
 column=(type=char(15) updatewhereclause=yes name=customer_fname dbname="customer.fname" )
 column=(type=number update=yes updatewhereclause=yes name=sales_order_total_ht dbname="sales_order.total_ht" )
 retrieve="  SELECT ~"sales_order~".~"id~",   
         ~"sales_order~".~"cust_id~",   
         ~"sales_order~".~"order_date~",   
         ~"sales_order~".~"fin_code_id~",   
         ~"sales_order~".~"region~",   
         ~"sales_order~".~"sales_rep~",   
         ~"employee~".~"emp_lname~",   
         ~"employee~".~"emp_fname~",   
         ~"customer~".~"lname~",   
         ~"customer~".~"fname~",   
         ~"sales_order~".~"total_ht~"  
    FROM ~"sales_order~",   
         ~"customer~",   
         ~"employee~"  
   WHERE ( ~"customer~".~"id~" = ~"sales_order~".~"cust_id~" ) and  
         ( ~"employee~".~"emp_id~" = ~"sales_order~".~"sales_rep~" ) and  
         ( ( ~"sales_order~".~"id~" = :sales_order_id  ) )    
" update="sales_order" updatewhere=1 updatekeyinplace=no arguments=(("sales_order_id", number)) )
bitmap(band=detail filename="Order.gif" x="50" y="8" height="128" width="146" border="5"  name=p_1 )
text(band=detail alignment="1" text="ID: " border="0" color="33554432" x="357" y="8" height="56" width="78"  name=sales_order_id_t  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="1" tabsequence=32766 border="5" color="33554432" x="453" y="8" height="56" width="297" format="[general]"  name=sales_order_id  tag="Sales order ID" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=20 border="5" color="33554432" x="453" y="88" height="56" width="297" format="[general]"  name=sales_order_region  tag="Region" ddlb.limit=0 ddlb.sorted=yes ddlb.allowedit=yes ddlb.case=any ddlb.required=yes ddlb.autohscroll=yes ddlb.vscrollbar=yes  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="Region:" border="0" color="33554432" x="247" y="88" height="56" width="187"  name=sales_order_region_t  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="Customer" border="0" color="33554432" x="197" y="200" height="52" width="238"  name=sales_order_cust_id_t  tag=""  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" font.italic="1" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="1" tabsequence=50 border="5" color="33554432" x="453" y="280" height="56" width="297" format="[general]"  name=sales_order_sales_rep  tag="" dddw.name=d_tab_salesperson dddw.displaycolumn=emp_id dddw.datacolumn=emp_id dddw.percentwidth=420 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.required=yes dddw.vscrollbar=yes  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="Salesperson" border="0" color="33554432" x="128" y="280" height="52" width="306"  name=sales_order_sales_rep_t  tag=""  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" font.italic="1" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="Date:" border="0" color="33554432" x="1307" y="8" height="56" width="123"  name=sales_order_order_date_t  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="2" tabsequence=10 border="5" color="33554432" x="1458" y="8" height="56" width="416" format="[general]"  name=sales_order_order_date  tag="Date Ordered" edit.limit=0 edit.case=any edit.format="DD/MM/YYYY" edit.focusrectangle=no edit.autoselect=yes edit.required=yes edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=4 alignment="1" tabsequence=30 border="5" color="33554432" x="1458" y="84" height="56" width="416" format="[general]"  name=sales_order_fin_code_id  tag="Financial Code" dddw.name=d_tab_fin_cod dddw.displaycolumn=code dddw.datacolumn=code dddw.percentwidth=400 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.required=yes dddw.nilisnull=yes dddw.vscrollbar=yes  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="Financial code:" border="0" color="33554432" x="1061" y="84" height="56" width="379"  name=sales_order_fin_code_id_t  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="0" tabsequence=32766 border="5" color="33554432" x="1463" y="204" height="56" width="411" format="[general]"  name=customer_fname  tag="First name of the customer" edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="0" tabsequence=32766 border="5" color="33554432" x="1463" y="280" height="56" width="411" format="[general]"  name=employee_emp_fname  tag="First name of the employee" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=32766 border="5" color="33554432" x="791" y="280" height="56" width="645" format="[general]"  name=employee_emp_lname  tag="Last name of the employee" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="0" tabsequence=32766 border="5" color="33554432" x="923" y="204" height="56" width="512" format="[general]"  name=customer_lname  tag="Last name of the customer" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
button(band=detail text="..."filename=""action="0" border="0" color="33554432" x="777" y="196" height="68" width="119" vtextalign="0" htextalign="0"  name=b_customer  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=2 alignment="0" tabsequence=40 border="5" color="33554432" x="453" y="200" height="56" width="297" format="[general]"  name=sales_order_cust_id dddw.name=d_tab_employee dddw.displaycolumn=employee_emp_id dddw.datacolumn=employee_emp_id dddw.percentwidth=700 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.required=yes dddw.vscrollbar=yes  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" )