d_tab_fin_cod


demopfc.pbl   >   d_tab_fin_cod   

Last Update 13/03/2008 09:54:46
Size 6 550 bytes
Data Source
 SELECT  	fin_code.code, 	fin_code.type, 	fin_code.description FROM 	fin_code 
detail
 detail
 - List of objects belonging to this band 
 code of type field 
 description of type field 
 type of type field 
 
footer
 footer
 
header
 header
 - List of objects belonging to this band 
 code_t of type DWText
 description_t of type DWText
 type_t of type DWText
 
summary
 summary
 
code
 Field
 - Field associated with column "fin_code.code"
 - A maximum of 2 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: Unique financial identification code
 
description
 Field
 - Field associated with column "fin_code.description"
 - A maximum of 50 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: Financial Code description
 
type
 Field
 - Field associated with column "fin_code.type"
 - A maximum of 10 characters can be entered.
 - Required field.
 - Left aligned field.
 - Tag value: Financial Code type
 
code_t
 Static Text
description_t
 Static Text
type_t
 Static Text

release 7;
datawindow(units=0 timer_interval=0 color=16777215 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 )
header(height=72 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=72 color="536870912" )
table(column=(type=char(2) update=yes updatewhereclause=yes key=yes name=code dbname="fin_code.code" )
 column=(type=char(10) update=yes updatewhereclause=yes name=type dbname="fin_code.type" )
 column=(type=char(50) update=yes updatewhereclause=yes name=description dbname="fin_code.description" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"fin_code~" ) COLUMN(NAME=~"fin_code.code~") COLUMN(NAME=~"fin_code.type~") COLUMN(NAME=~"fin_code.description~")) " update="fin_code" updatewhere=1 updatekeyinplace=no  sort="code A " )
column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="0" x="183" y="8" height="56" width="297" format="[general]"  name=type  tag="Financial Code type" edit.limit=10 edit.case=any edit.autoselect=yes edit.autohscroll=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=1 alignment="0" tabsequence=32766 border="0" color="0" x="23" y="8" height="56" width="133" format="[general]"  name=code  tag="Unique financial identification code" edit.limit=2 edit.case=any edit.autoselect=yes edit.autohscroll=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=3 alignment="0" tabsequence=32766 border="0" color="0" x="503" y="8" height="56" width="594" format="[general]"  name=description  tag="Financial Code description" edit.limit=50 edit.case=any edit.autoselect=yes edit.autohscroll=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=header alignment="0" text="Type" border="0" color="8388608" x="187" y="8" height="56" width="288"  name=type_t  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=header alignment="0" text="Code" border="0" color="8388608" x="23" y="8" height="56" width="133"  name=code_t  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=header alignment="0" text="Description" border="0" color="8388608" x="494" y="8" height="56" width="594"  name=description_t  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" )