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

Resolved Application run using iwarunner, the 'x' coordinates move to the end of the datawindow

  1. Issue
0
Votes
Undo
  1. Antony Xavier
    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

 

Azure sql server database as powerserver datasourc...
DBParms and Oracle Expired Accounts in PowerServer...
Responses (3)
Antony Xavier
Antony Xavier Accepted Answer Pending Moderation
  1. Wednesday, 8 May 2019 11:18 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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
mike S
  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
Antony Xavier
  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
Antony Xavier
  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.
mike S
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
Antony Xavier
  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.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Monday, 6 May 2019 08:54 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

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
Chris Pollach @Appeon
  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
Antony Xavier
  1. Antony Xavier
  2. Thursday, 9 May 2019 03:47 AM UTC
Sure Chris
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.