datawindow argument of type string array - using the value(s) in a computed field

Resolved datawindow argument of type string array - using the value(s) in a computed field

Issue

Votes

Undo

mike S
PowerBuilder
Wednesday, 30 May 2018 21:08 PM UTC

I appears that i can access an array argument value using a computed field. The values are quoted, and there appears to be a space between them?

Does anyone know the format?

Also, if i am just running the dw in preview mode, it appears that i can delimit the values using a space or a comma?

I would like to be able to parse it out in a computed field and display either the first, 2nd, etc. values.

I assume that number/date array arguments work the same exact way?

Responses (2)

mike S Accepted Answer Pending Moderation

Thursday, 31 May 2018 15:06 PM UTC
PowerBuilder
# 1

Hi Michael,

thanks for the reply.

I want to know the syntax within the datawindow at runtime so that i can access the array values in computed fields and/or expressions.

Comment

Alfredo Aldama
Friday, 1 June 2018 02:10 AM UTC

Hi,

The workaround, make it with global function, the arguments for the function ( Array, Index), You will have to build the function.

Expresion (inside datawindows):

Value = gf_Element(Array, Index)

Regards !

Helpful 0

There are no comments made yet.

Michael Kramer Accepted Answer Pending Moderation

Thursday, 31 May 2018 07:41 AM UTC
PowerBuilder
# 2

Hi Mike,

This answer is about sending arrays as retrieval arguments. Syntax for passing arrays as retrieval arguments is as follows:

string sCurrency[ ]

date dIgnoreDate[ ]

. . .

sCurrency = {'CH', 'DE', 'DK', 'GB'}

dIgnoreDate = {dYesterday, dToday, dNewYearDay, dXmasEve, dXmasDay, dBoxingDay, dNewYearEve}

dw_data.Retrieve(sCurrency , dIgnoreDate)

If on the other hand, you wanted to know how to access the array style retrieval argument in a computed field, please reply.

HTH /Michael

Comment

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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

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.