I don´t regain the value of a field in Form of Article in new Field “ANCHO” Answered

I create nine field in table OITM with Tools of Customizing:


 


This is my BeaSScript in artiket_edit.src:

windowevent postopen

   //Datos Gaviplast

                etab=addnewobject=stamm=object_name_t0=text=Datos Gaviplast=3500=10=350=56

                dw_1.item.object_name_t0.bold=true

   //1.Grosor

                etab=addnewobject=stamm=object_name_t1=text=Grosor=3100=70=350=56

                etab=addnewobject=stamm=object_name1=column=userfield1=3500=70=350=56

                dw_1.item.object_name1.alignment=1

                //etab=redraw

//2.Densidad

   etab=addnewobject=stamm=object_name_t2=text=Densidad=3100=140=350=56

                etab=addnewobject=stamm=object_name2=column=userfield2=3500=140=350=56

                dw_1.item.object_name2.alignment=1

//3.Viscosidad

etab=addnewobject=stamm=object_name_t3=text=Viscosidad=3100=210=350=56

                etab=addnewobject=stamm=object_name3=column=userfield3=3500=210=350=56

                dw_1.item.object_name3.alignment=1

//4.Gr/m2 Adh

                etab=addnewobject=stamm=object_name_t4=text=Gr_m2 Adh=3100=280=350=56

                etab=addnewobject=stamm=object_name4=column=userfield4=3500=280=350=56

                dw_1.item.object_name4.alignment=1

//5.Superficie - Campo Ancho de SAP (BWidth1)

                etab=addnewobject=stamm=object_name_t5=text=Ancho=3100=350=350=56

                etab=addnewobject=stamm=object_name5=column=userfield5=3500=350=350=56

                dw_1.item.object_name5.alignment=1

   //6.Superficie - Campo Alto de SAP (BLength1)

                etab=addnewobject=stamm=object_name_t6=text=Alto=3100=420=350=56

                etab=addnewobject=stamm=object_name6=column=userfield6=3500=420=350=56

                dw_1.item.object_name6.alignment=1

   //7.Superficie (Resultado de 5*6) si esta en blanco

                etab=addnewobject=stamm=object_name_t7=text=Superficie=3100=490=350=56

                etab=addnewobject=stamm=object_name7=column=userfield7=3500=490=350=56

                dw_1.item.object_name7.alignment=1

//8.Ancho Bolsa

                etab=addnewobject=stamm=object_name_t8=text=Ancho Bolsa=3100=560=350=56

                etab=addnewobject=stamm=object_name8=column=userfield8=3500=560=350=56

                dw_1.item.object_name8.alignment=1

//9.Alto Cliente

                etab=addnewobject=stamm=object_name_t9=text=Alto Cliente=3100=630=350=56

                etab=addnewobject=stamm=object_name9=column=userfield9=3500=630=350=56

                dw_1.item.object_name9.alignment=1

//SQL

                select "U_IFG_GPLASGROSOR","U_IFG_GPLASDENSIDAD","U_IFG_GPLASVISCOSIDA", &

                                                "U_IFG_GPLASGRM2ADH","U_IFG_GPLASANCHO","U_IFG_GPLASALTO", &

                                                "U_IFG_GPLASSUPERFICI","U_IFG_GPLASANCHOBOLS","U_IFG_GPLASALTOCLIEN" &

                                                from "OITM" where "ItemCode"=N'<dw_1.item.itemcode.value>'


                dw_1.item.object_name1.value=<wert1,#,##0.000>

                dw_1.item.object_name2.value=<wert2,#,##0.000>

                dw_1.item.object_name3.value=<wert3,#,##0.000>

                dw_1.item.object_name4.value=<wert4,#,##0.000>

                dw_1.item.object_name5.value=<wert5,#.##0.000>

                dw_1.item.object_name6.value=<wert6,#,##0.000>

                dw_1.item.object_name7.value=<wert7,#,##0.000>

                dw_1.item.object_name8.value=<wert8,#,##0.000>

                dw_1.item.object_name9.value=<wert9,#,##0.000>


                dw_1.item.object_name1.tabsequence=521

                dw_1.item.object_name2.tabsequence=522

                dw_1.item.object_name3.tabsequence=523

                dw_1.item.object_name4.tabsequence=524

                dw_1.item.object_name5.tabsequence=525

                dw_1.item.object_name6.tabsequence=526

                dw_1.item.object_name7.tabsequence=527

                dw_1.item.object_name8.tabsequence=528

                dw_1.item.object_name9.tabsequence=529

end event


windowevent itemchange dw_1.item.object_name5

   calculate()

end event

windowevent itemchange dw_1.item.object_name6

   calculate()

end event

//--------------------------------------------------------------------------------------------------------------------

//                        ACTUALIZACION

//--------------------------------------------------------------------------------------------------------------------

windowevent update

//SQL Actualización Campos Cabecera

                sql=update "OITM" &

                          set "U_IFG_GPLASGROSOR"=<dw_1.item.userfield1.value,dbnum>, &

                                "U_IFG_GPLASDENSIDAD"=<dw_1.item.userfield2.value,dbnum>, &

                                "U_IFG_GPLASVISCOSIDA"=<dw_1.item.userfield3.value,dbnum>, &

                                "U_IFG_GPLASGRM2ADH"=<dw_1.item.userfield4.value,dbnum>, &

                                "U_IFG_GPLASANCHO"=<dw_1.item.userfield5.value,dbnum>, &

                                "U_IFG_GPLASALTO"=<dw_1.item.userfield6.value,dbnum>, &

                                "U_IFG_GPLASSUPERFICI"=<dw_1.item.userfield7.value,dbnum>, &

                                "U_IFG_GPLASANCHOBOLS"=<dw_1.item.userfield8.value,dbnum>, &

                                "U_IFG_GPLASALTOCLIEN"=<dw_1.item.userfield9.value,dbnum> &

                                where "itemcode" = N'<dw_1.item.itemcode.value>'

end event

global function calculate

end global

// ---------------------------

 The script write all values in the new fields of OITM but the script don´t Paint the values the field userfield5  (U_IFG_GPLASANCHO) in the form.

Can you help me?

Than you.

 

 

Comments

1 comment

  • Comment author
    Yaremi Miranda Lopez
    • Official comment

    Hello Salvador,

     

    For more specific questions like this one, please contact you SAPB1 partner. They should analize the coding and provide you the best answer. Please consider that this kind of advanced questions involve time from our developers and is consider Premium Service.  Thank you so much for your understanding.

Please sign in to leave a comment.