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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Varible can't be used in a formula

Status
Not open for further replies.

baycolor

MIS
Mar 23, 2005
148
US
Hi,

I'm using CRV10.

The following is a formula I have:

global NumberVar RentClubsStrStart;
global NumberVar RentClubsValStart;
global StringVar RentClubsVal;

RentClubsStrStart := InStr ({TESTUSOPENVIEW.COMMENT_TEXT}, "Rent Clubs: ");

RentClubsValStart = RentClubsStrStart + 12;

RentClubsVal := Mid ({TESTUSOPENVIEW.COMMENT_TEXT}, RentClubsValStart)

When doing a save and close on the formula I get no syntax errors.

When I'm back in the report and add the formula as a field I get the message:

"Start position is less than 1 or not an integer".

Why can't I use RentClubsValStart in the MID function. It's delcared as a number?

Thanks in advance.
 
You're missing an assignment operator (":") on this line:

RentClubsValStart [red]:[/red]= RentClubsStrStart + 12;

-dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top