Topic: how to use array formula? Posted: 27 Oct 2010 at 11:55pm
Local StringVar array color_type_str := Split({qryTable.COLOR_TYPE}, ",");
Local NumberVar strLen := Count ({qryTable. COLOR_TYPE});
Local NumberVar i;
For i:=1 To strLen step +1 Do
(
if color_type_str = "A" then
(
"V";
Exit For ;
)
)
the array data is like ["A","B","C"]
1.why the result shows "True" instead of "V" or "X"?
2.and is Count() the right way to count array length, why it show double zero "00", not the correct number of elements?
Local StringVar array color_type_str := Split({qryTable. COLOR_TYPE}, ",");
Local NumberVar strLen := Count (color_type_str);
Local NumberVar i;
Local StringVar result;
For i:=1 To strLen step +1 Do
(
If color_type_str = "A" Then
(
result := "V";
Exit For;
)
);
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum