1. Antony Xavier
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 6 May 2019 06:45 AM UTC

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

 

Marco Meoni Accepted Answer Pending Moderation
  1. Monday, 6 May 2019 08:54 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Antony,

for a better understating, can you provide a code snippet and a screenshot showing the difference?

IWA is usually truly identical to C/S as it is free from browser's additional toolbars that may affect workspace width/height used in dynamic "x" and "y" calculation from PowerScript.

Best,

.m

Comment
  1. Chris Pollach @Appeon
  2. Monday, 6 May 2019 15:31 PM UTC
Hi Antony,

Along with what Marco said ... I would suggest opening a Support Ticket on this IWA issue and attaching a test case. This sounds like an IWA run-time issue if the same code works in PS Web & native - but not IWA.

Regards .. .Chris
  1. Helpful
  1. Antony Xavier
  2. Thursday, 9 May 2019 03:47 AM UTC
Sure Chris
  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Monday, 6 May 2019 13:33 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

is this a grid datawindow?

Comment
  1. Antony Xavier
  2. Thursday, 9 May 2019 04:51 AM UTC
yes it is grid datawindow
  1. Helpful
There are no comments made yet.
Antony Xavier Accepted Answer Pending Moderation
  1. Wednesday, 8 May 2019 11:18 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

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

Comment
  1. mike S
  2. Wednesday, 8 May 2019 12:51 PM UTC
i am pretty sure that since it is a grid, it will always add any new detail computes/columns etc at the end. Grids works that way. this has nothing to do with web or iwarunner.



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.

.
  1. Helpful
  1. Antony Xavier
  2. Thursday, 9 May 2019 05:07 AM UTC
Mike You are right , There is one line of code was missing when remove comments, in between am forcing the 'X' axis., following is the actual code , and I had given the screen shots which is real case. It is working in Web/CS but not working with IWARunner

/////////////////////////////////

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)

/////////////////////////////////////////////////////



  1. Helpful
  1. Antony Xavier
  2. Thursday, 9 May 2019 06:04 AM UTC
Mike, I tried with "i would make each column/compute invisible, do your CREATE modify, then make the items visible." and it is working fine, thank you very much.
  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.