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

string is required error

Status
Not open for further replies.

BHAT100

Programmer
Dec 5, 2002
115
CA
I have parameter as {?Location} = {iv30300.locncode}

when I am using following formula. it gives me error "a number,currency,string is required"

{?Location} in [{IV30300.TRXLOCTN},{IV30300.TRNSTLOC}]

Thanks for help

-b
 
Try this:
Code:
{?Location} = {IV30300.TRXLOCTN}
or {?Location} = {IV30300.TRNSTLOC}

-Dell




A computer only does what you actually told it to do - not what you thought you told it to do.
 
Please post technical information.

What TYPE of parameter is it?

What TYPE is the field you're referencing?

They have to be the same data type, which is probably your difficulty.

In either case the formula appears to be doing nothing:

{?Location} in [{IV30300.TRXLOCTN},{IV30300.TRNSTLOC}]

If you're trying to limit the rows try:

{IV30300.TRXLOCTN} = {?Location}
or
{IV30300.TRNSTLOC} = {?Location}

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top