Dears,
In my Application, am using dynamic datawindow creation along with the sql, also creating compute & text (for heading) column dynamically for displaying "row" number using "getrow()" function, In web and Client server it is working fine, when I run using iwarunner, the 'x' coordinates move to the end of the datawindow, I want to display in the beginning of the datawindow to display the rownumber.
Please advice.
Regards
Antony
Dear Macro.,
following screen shot from using IWARunner
From Web
Sample Code
ls_exp = dw_master.Describe( "id.x")
If ls_exp = '?' or ls_exp = '!' then
ls_dummy='0'
else
ls_dummy=ls_exp
//
end if
ls_exp = 'create compute(band=detail alignment="1" expression="getrow()" border="6" color="33554432" x="'+ls_dummy+'" y="12" height="76" width="142" format="[general]" name=rowid font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="178" background.mode="2" background.color="536870912" )'
ls_dummy= Modify( ls_exp)
ls_dummy = Describe( ' rowid.x ' )
ls_exp = 'create text(band=header alignment="2" text="#" border="6" color="33554432" x="'+ls_dummy+'" y="8" height="64" width="142" html.valueishtml="0" name=rowid_t visible="1" font.face="Tahoma" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="536870912" ) '
ls_dummy = Modify( ls_exp)
Regards
Antony
you need to first make detail items invisible then visible in the x order.
i would make each column/compute invisible, do your CREATE modify, then make the items visible.
.
/////////////////////////////////
ls_exp = 'create compute(band=detail alignment="1" expression="getrow()" border="6" color="33554432" x="'+ls_dummy+'" y="12" height="76" width="142" format="[general]" name=rowid font.face="Tahoma" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="178" background.mode="2" background.color="536870912" )'
ls_dummy= Modify( ls_exp)
ls_exp = ' rowid.x="1" '
ls_dummy= Modify( ls_exp)
ls_dummy = Describe( ' rowid.x ' )
ls_exp = 'create text(band=header alignment="2" text="#" border="6" color="33554432" x="'+ls_dummy+'" y="8" height="64" width="142" html.valueishtml="0" name=rowid_t visible="1" font.face="Tahoma" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="536870912" ) '
ls_dummy = Modify( ls_exp)
/////////////////////////////////////////////////////