columnnumber

[mluerken]

I have a tablefield with a lot of columns: s1, s2, s3, s4, ... s40.
In my soucecode i have to check all rows and all columns for a special value.
I want to use something like this:

FOR i=1 TO tf_1.lastrow DO
FOR j=1 TO 40 DO
IF tf_1[i].columnnumber[j].Value=1 THEN //????????
... do somthing ....
ENDIF;
ENDFOR;
ENDFOR;

I know it! Line 3 is not correct. But how is the syntax to solve my problem?

Thank's for answering,
Mich@el

[Bodo]

That would be something like

FOR i=1 TO tf_1.lastrow DO
    FOR j=1 TO 40 DO
        attrname = 's'+varchar(j);
        tf_1[i].GetAttribute(:attrname = BYREF(myvaluevar));
        IF myvaluevar=1 THEN
           // ... do somthing ....
        ENDIF;
    ENDFOR;
ENDFOR;

You could of course also use dynamic expressions, or a loop with continuous Find() invocations for all 40 columns - probably the fastest of the given options.

[mluerken]

Thank you! That's one solution. And it works, because the attributename is contant with an index. Otherwise the columnumber will be better.

But for this time: Great!

[Bodo]

If you need the name of the column from the column number you just use:
attrname = FIELD(tf_1).TableBody.ChildFields[j].Name;
So, I hope that's even greater then