We help IT Professionals succeed at work.
Get Started

Computed Field - From Array - Which Column?

pemurray
pemurray asked
on
534 Views
Last Modified: 2013-12-26
Hi Everyone,

I am trying to fill a computed field from a global two dimensional array - gridarray[a,b]

The array is supposed to correspond directly to the dimensions of the datawindow.  So if the array has 20 columns and 40 rows it would be gridarray[20,40]

So...

In the datawindow grid, I have a bunch of computed fields.  Each computed field SHOULD have an expression as follows:

gridarray[getcolumn(),getrow()]

The 'getrow( )' part of this is easy.

Unfortunately, there is no built-in expression function like 'getcolumn( )'

Can anyone offer a suggestion as to the simplest way to know what the column number or name is?

I have a computed column with the name of C1.  In the computed field expression, I typed in 'C1.Name'.

I did not get an error, but it just does not work.  If it did work, I could write a function to pass the name to a funtion and then return only the column number.

Argh!!

I have tried so many ways to get this information and spent sooooo many hours goooogling the issue, that I can't believe that I have not figured it out yet.

Thank you in advance for any help!!!

Best,

PEM
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE