Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved ERROR Updating New Columns - SQL SERVER 2016

  1. How-to
0
Votes
Undo
  1. Ravi Pathirane
    Ravi Pathirane
  2. PowerBuilder
  3. Thursday, 8 October 2020 16:50 PM UTC

Hello Everyone..  Need HELP!

I am having issues updating new columns added to a dw inherited from u_dw..  

I get update failed, invalid column..

Yet I added the column using the designer itself..  tried many things including changing column name moving column in the table etc etc ..  no luck. 

Thank you 

Datetime issue with SQL 2016
OLE ConnectToNewObject("Outlook.Application")
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 16:55 PM UTC
  2. PowerBuilder
  3. # 1

Hi Ravi;

  In the DW Painter after you added the new column, did you ...

1) Add the column to the DWO's "Updatable Columns list"?

2) Test the updatability of the DWO in the DW Painter's "Preview" pane?

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 8 October 2020 19:58 PM UTC
What about in the PB IDE's "DB Painter"?
  1. Helpful
Ravi Pathirane
  1. Ravi Pathirane
  2. Thursday, 8 October 2020 20:21 PM UTC
works from there Chris..
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 8 October 2020 20:47 PM UTC
Assuming that the IDE's DB Profile is connecting to the same SS instance and it's using the same SNC DB CLient driver & settings, then it should work exactly the same from an App's EXE. So you might want to check ....

1) Is the SNC driver version / build the same on the App EXE machine as your IDE?

2) Is the SQLCA settings the same in the App EXE vs the PB IDE's DB Profile?

3) Is the PB IDE and the App EXE connecting to the same SS instance?

4) Is the PB IDE and the App EXE connecting to SS using the same credentials?

etc.

  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 17:56 PM UTC
  2. PowerBuilder
  3. # 2

Greetings, Ravi - 

I suggest you export the DW source and post it here. 

What version, release, build of PB are you using? What is the datatype of the newly-added column? Which database driver does your PB app use (SQLCA.DBMS = "???")?

Regards, John

Comment
Ravi Pathirane
  1. Ravi Pathirane
  2. Thursday, 8 October 2020 19:43 PM UTC
Hi John

Here is the source.. I did a new DW and its doing the same..

Thanks and best regards

R

PBExportHeader$d_test.srd

release 19;

datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" )

header(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )

summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )

footer(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )

detail(height=10208 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )

table(column=(type=long update=yes updatewhereclause=yes key=yes name=order_id dbname="o_vhcl.order_id" dbalias=".order_id" )

column=(type=long update=yes updatewhereclause=yes name=vhcl_cat_id dbname="o_vhcl.vhcl_cat_id" dbalias=".vhcl_cat_id" )

column=(type=char(15) update=yes updatewhereclause=yes name=model_cd dbname="o_vhcl.model_cd" dbalias=".model_cd" )

column=(type=long update=yes updatewhereclause=yes name=mfr_id dbname="o_vhcl.mfr_id" dbalias=".mfr_id" )

column=(type=char(10) update=yes updatewhereclause=yes name=pkg_cd dbname="o_vhcl.pkg_cd" dbalias=".pkg_cd" )

column=(type=char(6) update=yes updatewhereclause=yes name=whl_base dbname="o_vhcl.whl_base" dbalias=".whl_base" )

column=(type=char(40) update=yes updatewhereclause=yes name=model_desc dbname="o_vhcl.model_desc" dbalias=".model_desc" )

column=(type=char(35) update=yes updatewhereclause=yes name=model_series dbname="o_vhcl.model_series" dbalias=".model_series" )

column=(type=char(50) update=yes updatewhereclause=yes name=model_style dbname="o_vhcl.model_style" dbalias=".model_style" )

column=(type=char(9) update=yes updatewhereclause=yes name=model_short dbname="o_vhcl.model_short" dbalias=".model_short" )

column=(type=char(10) update=yes updatewhereclause=yes name=ext_clr_cd dbname="o_vhcl.ext_clr_cd" dbalias=".ext_clr_cd" )

column=(type=char(25) update=yes updatewhereclause=yes name=ext_clr_desc dbname="o_vhcl.ext_clr_desc" dbalias=".ext_clr_desc" )

column=(type=char(10) update=yes updatewhereclause=yes name=int_clr_cd dbname="o_vhcl.int_clr_cd" dbalias=".int_clr_cd" )

column=(type=char(25) update=yes updatewhereclause=yes name=int_clr_desc dbname="o_vhcl.int_clr_desc" dbalias=".int_clr_desc" )

column=(type=char(25) update=yes updatewhereclause=yes name=fin_no dbname="o_vhcl.fin_no" dbalias=".fin_no" )

column=(type=char(15) update=yes updatewhereclause=yes name=conc_no dbname="o_vhcl.conc_no" dbalias=".conc_no" )

column=(type=char(20) update=yes updatewhereclause=yes name=vhcl_serial_no dbname="o_vhcl.vhcl_serial_no" dbalias=".vhcl_serial_no" )

column=(type=long update=yes updatewhereclause=yes name=odo_kms dbname="o_vhcl.odo_kms" dbalias=".odo_kms" )

column=(type=char(1) update=yes updatewhereclause=yes name=price_src_id dbname="o_vhcl.price_src_id" dbalias=".price_src_id" )

column=(type=datetime update=yes updatewhereclause=yes name=pricing_date dbname="o_vhcl.pricing_date" dbalias=".pricing_date" )

column=(type=char(32766) update=yes updatewhereclause=no name=std_eqp_desc dbname="o_vhcl.std_eqp_desc" dbalias=".std_eqp_desc" )

column=(type=char(4) update=yes updatewhereclause=yes name=year dbname="o_vhcl.year" dbalias=".year" )

column=(type=datetime update=yes updatewhereclause=yes name=created dbname="o_vhcl.Created" dbalias=".Created" )

column=(type=char(50) update=yes updatewhereclause=yes name=created_user dbname="o_vhcl.Created_User" dbalias=".Created_User" )

column=(type=datetime update=yes updatewhereclause=yes name=last_updated dbname="o_vhcl.Last_Updated" dbalias=".Last_Updated" )

column=(type=char(50) update=yes updatewhereclause=yes name=last_updated_user dbname="o_vhcl.Last_Updated_User" dbalias=".Last_Updated_User" )

column=(type=char(10) update=yes updatewhereclause=yes name=lic_plate dbname="o_vhcl.lic_plate" dbalias=".lic_plate" )

column=(type=datetime update=yes updatewhereclause=yes name=lic_exp_date dbname="o_vhcl.lic_exp_date" dbalias=".lic_exp_date" )

column=(type=char(1) update=yes updatewhereclause=yes name=delay_build dbname="o_vhcl.delay_build" dbalias=".delay_build" )

column=(type=datetime update=yes updatewhereclause=yes name=delay_build_date dbname="o_vhcl.delay_build_date" dbalias=".delay_build_date" )

column=(type=char(15) update=yes updatewhereclause=yes name=key_code dbname="o_vhcl.key_code" dbalias=".key_code" )

column=(type=char(25) update=yes updatewhereclause=yes name=eng_desc dbname="o_vhcl.eng_desc" dbalias=".eng_desc" )

column=(type=char(6) update=yes updatewhereclause=yes name=find_serial_no dbname="o_vhcl.find_serial_no" dbalias=".find_serial_no" )

column=(type=char(10) update=yes updatewhereclause=yes name=selector_name dbname="o_vhcl.selector_name" dbalias=".selector_name" )

column=(type=char(25) update=yes updatewhereclause=yes name=tran_desc dbname="o_vhcl.tran_desc" dbalias=".tran_desc" )

column=(type=char(10) update=yes updatewhereclause=yes name=eng_cd dbname="o_vhcl.eng_cd" dbalias=".eng_cd" )

column=(type=char(10) update=yes updatewhereclause=yes name=tran_cd dbname="o_vhcl.tran_cd" dbalias=".tran_cd" )

column=(type=char(10) update=yes updatewhereclause=yes name=drv_clean_postal_cd dbname="o_vhcl.drv_clean_postal_cd" dbalias=".drv_clean_postal_cd" )

column=(type=datetime update=yes updatewhereclause=yes name=drv_clean_eff_date dbname="o_vhcl.drv_clean_eff_date" dbalias=".drv_clean_eff_date" )

column=(type=long update=yes updatewhereclause=yes name=drv_clean_phase dbname="o_vhcl.drv_clean_phase" dbalias=".drv_clean_phase" )

column=(type=decimal(0) update=yes updatewhereclause=yes name=gross_vw dbname="o_vhcl.gross_vw" dbalias=".gross_vw" )

column=(type=char(250) update=yes updatewhereclause=yes name=eqp_desc dbname="o_vhcl.eqp_desc" dbalias=".eqp_desc" )

column=(type=char(10) update=yes updatewhereclause=yes name=gmpp_plan dbname="o_vhcl.gmpp_plan" dbalias=".gmpp_plan" )

column=(type=char(20) update=yes updatewhereclause=yes name=gmpp_name dbname="o_vhcl.gmpp_name" dbalias=".gmpp_name" )

column=(type=datetime update=yes updatewhereclause=yes name=gmpp_start_date dbname="o_vhcl.gmpp_start_date" dbalias=".gmpp_start_date" )

column=(type=datetime update=yes updatewhereclause=yes name=gmpp_end_date dbname="o_vhcl.gmpp_end_date" dbalias=".gmpp_end_date" )

column=(type=long update=yes updatewhereclause=yes name=gmpp_start_kms dbname="o_vhcl.gmpp_start_kms" dbalias=".gmpp_start_kms" )

column=(type=long update=yes updatewhereclause=yes name=gmpp_end_kms dbname="o_vhcl.gmpp_end_kms" dbalias=".gmpp_end_kms" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=gmpp_markup dbname="o_vhcl.gmpp_markup" dbalias=".gmpp_markup" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=gmpp_price dbname="o_vhcl.gmpp_price" dbalias=".gmpp_price" )

column=(type=datetime update=yes updatewhereclause=yes name=gmpp_created dbname="o_vhcl.gmpp_created" dbalias=".gmpp_created" )

column=(type=char(1) update=yes updatewhereclause=yes name=gmpp_gp_updated dbname="o_vhcl.gmpp_gp_updated" dbalias=".gmpp_gp_updated" )

column=(type=long update=yes updatewhereclause=yes name=gmpp_com_acct_mgr dbname="o_vhcl.gmpp_com_acct_mgr" dbalias=".gmpp_com_acct_mgr" )

column=(type=char(10) update=yes updatewhereclause=yes name=gap_cert_no dbname="o_vhcl.gap_cert_no" dbalias=".gap_cert_no" )

column=(type=datetime update=yes updatewhereclause=yes name=gap_eff_date dbname="o_vhcl.gap_eff_date" dbalias=".gap_eff_date" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=gap_cost dbname="o_vhcl.gap_cost" dbalias=".gap_cost" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=gap_markup dbname="o_vhcl.gap_markup" dbalias=".gap_markup" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=gap_total dbname="o_vhcl.gap_total" dbalias=".gap_total" )

column=(type=long update=yes updatewhereclause=yes name=gap_acct_mgr dbname="o_vhcl.gap_acct_mgr" dbalias=".gap_acct_mgr" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=fuel_capacity dbname="o_vhcl.fuel_capacity" dbalias=".fuel_capacity" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=fuel_econ_city dbname="o_vhcl.fuel_econ_city" dbalias=".fuel_econ_city" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=fuel_econ_hwy dbname="o_vhcl.fuel_econ_hwy" dbalias=".fuel_econ_hwy" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=fuel_econ_goal dbname="o_vhcl.fuel_econ_goal" dbalias=".fuel_econ_goal" )

column=(type=decimal(4) update=yes updatewhereclause=yes name=co2_gpkm dbname="o_vhcl.co2_gpkm" dbalias=".co2_gpkm" )

column=(type=char(200) update=yes updatewhereclause=yes name=eng_desc_api dbname="o_vhcl.eng_desc_api" dbalias=".eng_desc_api" )

column=(type=char(200) update=yes updatewhereclause=yes name=drivetrain_api dbname="o_vhcl.drivetrain_api" dbalias=".drivetrain_api" )

column=(type=char(50) update=yes updatewhereclause=yes name=year_api dbname="o_vhcl.year_api" dbalias=".year_api" )

column=(type=char(200) update=yes updatewhereclause=yes name=make_api dbname="o_vhcl.make_api" dbalias=".make_api" )

column=(type=char(200) update=yes updatewhereclause=yes name=model_desc_api dbname="o_vhcl.model_desc_api" dbalias=".model_desc_api" )

column=(type=datetime update=yes updatewhereclause=yes name=etest_exp_date dbname="o_vhcl.etest_exp_date" dbalias=".etest_exp_date" )

column=(type=datetime update=yes updatewhereclause=yes name=on_road_date dbname="o_vhcl.on_road_date" dbalias=".on_road_date" )

column=(type=char(25) update=yes updatewhereclause=yes name=lic_sticker_no dbname="o_vhcl.lic_sticker_no" dbalias=".lic_sticker_no" )

column=(type=char(1) update=yes updatewhereclause=yes name=renew_plate dbname="o_vhcl.renew_plate" dbalias=".renew_plate" )

column=(type=decimal(2) update=yes updatewhereclause=yes name=lic_renewal_fee dbname="o_vhcl.lic_renewal_fee" dbalias=".lic_renewal_fee" )

column=(type=long update=yes updatewhereclause=yes name=test dbname="o_vhcl.test" dbalias=".test" )

retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"o_vhcl~" ) COLUMN(NAME=~"o_vhcl.order_id~") COLUMN(NAME=~"o_vhcl.vhcl_cat_id~") COLUMN(NAME=~"o_vhcl.model_cd~") COLUMN(NAME=~"o_vhcl.mfr_id~") COLUMN(NAME=~"o_vhcl.pkg_cd~") COLUMN(NAME=~"o_vhcl.whl_base~") COLUMN(NAME=~"o_vhcl.model_desc~") COLUMN(NAME=~"o_vhcl.model_series~") COLUMN(NAME=~"o_vhcl.model_style~") COLUMN(NAME=~"o_vhcl.model_short~") COLUMN(NAME=~"o_vhcl.ext_clr_cd~") COLUMN(NAME=~"o_vhcl.ext_clr_desc~") COLUMN(NAME=~"o_vhcl.int_clr_cd~") COLUMN(NAME=~"o_vhcl.int_clr_desc~") COLUMN(NAME=~"o_vhcl.fin_no~") COLUMN(NAME=~"o_vhcl.conc_no~") COLUMN(NAME=~"o_vhcl.vhcl_serial_no~") COLUMN(NAME=~"o_vhcl.odo_kms~") COLUMN(NAME=~"o_vhcl.price_src_id~") COLUMN(NAME=~"o_vhcl.pricing_date~") COLUMN(NAME=~"o_vhcl.std_eqp_desc~") COLUMN(NAME=~"o_vhcl.year~") COLUMN(NAME=~"o_vhcl.Created~") COLUMN(NAME=~"o_vhcl.Created_User~") COLUMN(NAME=~"o_vhcl.Last_Updated~") COLUMN(NAME=~"o_vhcl.Last_Updated_User~") COLUMN(NAME=~"o_vhcl.lic_plate~") COLUMN(NAME=~"o_vhcl.lic_exp_date~") COLUMN(NAME=~"o_vhcl.delay_build~") COLUMN(NAME=~"o_vhcl.delay_build_date~") COLUMN(NAME=~"o_vhcl.key_code~") COLUMN(NAME=~"o_vhcl.eng_desc~") COLUMN(NAME=~"o_vhcl.find_serial_no~") COLUMN(NAME=~"o_vhcl.selector_name~") COLUMN(NAME=~"o_vhcl.tran_desc~") COLUMN(NAME=~"o_vhcl.eng_cd~") COLUMN(NAME=~"o_vhcl.tran_cd~") COLUMN(NAME=~"o_vhcl.drv_clean_postal_cd~") COLUMN(NAME=~"o_vhcl.drv_clean_eff_date~") COLUMN(NAME=~"o_vhcl.drv_clean_phase~") COLUMN(NAME=~"o_vhcl.gross_vw~") COLUMN(NAME=~"o_vhcl.eqp_desc~") COLUMN(NAME=~"o_vhcl.gmpp_plan~") COLUMN(NAME=~"o_vhcl.gmpp_name~") COLUMN(NAME=~"o_vhcl.gmpp_start_date~") COLUMN(NAME=~"o_vhcl.gmpp_end_date~") COLUMN(NAME=~"o_vhcl.gmpp_start_kms~") COLUMN(NAME=~"o_vhcl.gmpp_end_kms~") COLUMN(NAME=~"o_vhcl.gmpp_markup~") COLUMN(NAME=~"o_vhcl.gmpp_price~") COLUMN(NAME=~"o_vhcl.gmpp_created~") COLUMN(NAME=~"o_vhcl.gmpp_gp_updated~") COLUMN(NAME=~"o_vhcl.gmpp_com_acct_mgr~") COLUMN(NAME=~"o_vhcl.gap_cert_no~") COLUMN(NAME=~"o_vhcl.gap_eff_date~") COLUMN(NAME=~"o_vhcl.gap_cost~") COLUMN(NAME=~"o_vhcl.gap_markup~") COLUMN(NAME=~"o_vhcl.gap_total~") COLUMN(NAME=~"o_vhcl.gap_acct_mgr~") COLUMN(NAME=~"o_vhcl.fuel_capacity~") COLUMN(NAME=~"o_vhcl.fuel_econ_city~") COLUMN(NAME=~"o_vhcl.fuel_econ_hwy~") COLUMN(NAME=~"o_vhcl.fuel_econ_goal~") COLUMN(NAME=~"o_vhcl.co2_gpkm~") COLUMN(NAME=~"o_vhcl.eng_desc_api~") COLUMN(NAME=~"o_vhcl.drivetrain_api~") COLUMN(NAME=~"o_vhcl.year_api~") COLUMN(NAME=~"o_vhcl.make_api~") COLUMN(NAME=~"o_vhcl.model_desc_api~") COLUMN(NAME=~"o_vhcl.etest_exp_date~") COLUMN(NAME=~"o_vhcl.on_road_date~") COLUMN(NAME=~"o_vhcl.lic_sticker_no~") COLUMN(NAME=~"o_vhcl.renew_plate~") COLUMN(NAME=~"o_vhcl.lic_renewal_fee~") COLUMN(NAME=~"o_vhcl.test~")WHERE( EXP1 =~"o_vhcl.order_id~" OP =~"=~" EXP2 =~":orderID~" ) ) ARG(NAME = ~"orderID~" TYPE = number) " update="o_vhcl" updatewhere=0 updatekeyinplace=no arguments=(("orderID", number)) )

text(band=detail alignment="1" text="Order Id:" border="0" color="33554432" x="37" y="4" height="64" width="713" html.valueishtml="0" name=order_id_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=1 alignment="1" tabsequence=10 border="0" color="33554432" x="768" y="4" height="76" width="384" format="[general]" html.valueishtml="0" name=order_id visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Vhcl Cat Id:" border="0" color="33554432" x="37" y="140" height="64" width="713" html.valueishtml="0" name=vhcl_cat_id_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=2 alignment="1" tabsequence=20 border="0" color="33554432" x="768" y="140" height="76" width="384" format="[general]" html.valueishtml="0" name=vhcl_cat_id visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Model Cd:" border="0" color="33554432" x="37" y="276" height="64" width="713" html.valueishtml="0" name=model_cd_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="768" y="276" height="76" width="549" format="[general]" html.valueishtml="0" name=model_cd visible="1" edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Mfr Id:" border="0" color="33554432" x="37" y="412" height="64" width="713" html.valueishtml="0" name=mfr_id_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=4 alignment="1" tabsequence=40 border="0" color="33554432" x="768" y="412" height="76" width="384" format="[general]" html.valueishtml="0" name=mfr_id visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Pkg Cd:" border="0" color="33554432" x="37" y="548" height="64" width="713" html.valueishtml="0" name=pkg_cd_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="768" y="548" height="76" width="384" format="[general]" html.valueishtml="0" name=pkg_cd visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Whl Base:" border="0" color="33554432" x="37" y="684" height="64" width="713" html.valueishtml="0" name=whl_base_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="768" y="684" height="76" width="247" format="[general]" html.valueishtml="0" name=whl_base visible="1" edit.limit=6 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Model Desc:" border="0" color="33554432" x="37" y="820" height="64" width="713" html.valueishtml="0" name=model_desc_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="768" y="820" height="76" width="1262" format="[general]" html.valueishtml="0" name=model_desc visible="1" edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Model Series:" border="0" color="33554432" x="37" y="956" height="64" width="713" html.valueishtml="0" name=model_series_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=8 alignment="0" tabsequence=80 border="0" color="33554432" x="768" y="956" height="76" width="1125" format="[general]" html.valueishtml="0" name=model_series visible="1" edit.limit=35 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Model Style:" border="0" color="33554432" x="37" y="1092" height="64" width="713" html.valueishtml="0" name=model_style_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=9 alignment="0" tabsequence=90 border="0" color="33554432" x="768" y="1092" height="76" width="1536" format="[general]" html.valueishtml="0" name=model_style visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Model Short:" border="0" color="33554432" x="37" y="1228" height="64" width="713" html.valueishtml="0" name=model_short_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=10 alignment="0" tabsequence=100 border="0" color="33554432" x="768" y="1228" height="76" width="357" format="[general]" html.valueishtml="0" name=model_short visible="1" edit.limit=9 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Ext Clr Cd:" border="0" color="33554432" x="37" y="1364" height="64" width="713" html.valueishtml="0" name=ext_clr_cd_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=11 alignment="0" tabsequence=110 border="0" color="33554432" x="768" y="1364" height="76" width="384" format="[general]" html.valueishtml="0" name=ext_clr_cd visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Ext Clr Desc:" border="0" color="33554432" x="37" y="1500" height="64" width="713" html.valueishtml="0" name=ext_clr_desc_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=12 alignment="0" tabsequence=120 border="0" color="33554432" x="768" y="1500" height="76" width="850" format="[general]" html.valueishtml="0" name=ext_clr_desc visible="1" edit.limit=25 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Int Clr Cd:" border="0" color="33554432" x="37" y="1636" height="64" width="713" html.valueishtml="0" name=int_clr_cd_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=13 alignment="0" tabsequence=130 border="0" color="33554432" x="768" y="1636" height="76" width="384" format="[general]" html.valueishtml="0" name=int_clr_cd visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Int Clr Desc:" border="0" color="33554432" x="37" y="1772" height="64" width="713" html.valueishtml="0" name=int_clr_desc_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="768" y="1772" height="76" width="850" format="[general]" html.valueishtml="0" name=int_clr_desc visible="1" edit.limit=25 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Fin No:" border="0" color="33554432" x="37" y="1908" height="64" width="713" html.valueishtml="0" name=fin_no_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=15 alignment="0" tabsequence=150 border="0" color="33554432" x="768" y="1908" height="76" width="850" format="[general]" html.valueishtml="0" name=fin_no visible="1" edit.limit=25 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Conc No:" border="0" color="33554432" x="37" y="2044" height="64" width="713" html.valueishtml="0" name=conc_no_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=16 alignment="0" tabsequence=160 border="0" color="33554432" x="768" y="2044" height="76" width="549" format="[general]" html.valueishtml="0" name=conc_no visible="1" edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

text(band=detail alignment="1" text="Vhcl Serial No:" border="0" color="33554432" x="37" y="2180" height="64" width="713" html.valueishtml="0" name=vhcl_serial_no_t visible="1" font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

column(band=detail id=17 alignment="0" tabsequence=170 border="0" color="33554432" x="768" y="2180" height="76" width="713" format="[general]" html.valueishtml="0" name=vhcl_serial_no visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial=&
  1. Helpful
John Fauss
  1. John Fauss
  2. Thursday, 8 October 2020 20:56 PM UTC
I should have been a little more explicit. Would you please Export the DW into an .srd file, zip it, then "Add A Reply" to this thread and attach the zip file by using the "Upload Files" button beneath the reply text editor. I would like to edit/inspect the DW source. The source was truncated when you pasted it into the comment.

I see from the exported DW source header that you are using PB 2019. Again, what release and build?

And, again, what is the DBMS property of your transaction object set to?
  1. Helpful
There are no comments made yet.
Ravi Pathirane
Ravi Pathirane Accepted Answer Pending Moderation
  1. Tuesday, 13 October 2020 14:00 PM UTC
  2. PowerBuilder
  3. # 3

Hello Everyone.

Thanks for all the suggestions..   It was resolved.  there was a trigger in the live database that was not in dev and test ( trying to figure out why.. ) that was causing the issue.

Thank you again!

R

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 13 October 2020 20:27 PM UTC
Hi Ravi ... Glad that you found the issue and thanks for the feedback!
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 13 October 2020 20:58 PM UTC
Thanks for sharing the solution Ravi!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.