Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula error - CR XI

Status
Not open for further replies.

ReportDr00

IS-IT--Management
Mar 2, 2007
194
US
Hello,

Below is the formula and i am getting a number is required here error, can someone point me to the error.

Whileprintingrecords;
Local NumberVar topNode:=0;
Local StringVar array comments:="";
Local NumberVar i;
Local NumberVar InstLines := 0;

If ToText({Client.Instructions})="" then
InstLines := 0
else
(
comments := Split({Client.Instructions}, "|");
topNode := UBound(comments);
For i := 1 To topNode Do
(
If (Len(comments) > 0) Then
(
InstLines := InstLines + 1
)
);
);
InstLines
 
For one thing, instructions is already text. Then try:

Whileprintingrecords;
Local NumberVar topNode:=0;
Local StringVar array comments:="";
Local NumberVar i;
Local NumberVar InstLines := 0;

If trim({Client.Instructions})="" then
InstLines := 0;
If trim({Client.Instructions})<>"" then
(
comments := Split({Client.Instructions}, "|");
topNode := UBound(comments);
For i := 1 To topNode Do
(
If (Len(comments) > 0) Then
(
InstLines := InstLines + 1
)
);
);
InstLines

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top