Issues and Problems | Forum

Back to forum list… Back to Issues and Problems...

IMan 4.1 - Subscript out of range (3 replies)

Randy

5 years ago

Randy 5 years ago

I'm getting a "Subscript out of range" error when attempting to use a Lookup. I've attempted to change the field type to Integer (we're expecting an integer result) and Text, and neither has worked.

Lookup Setup:

SELECT: MAX(CARDID) as 'cardid'
FROM: NNCARD
WHERE: 1 = 1

Lookup Use:

Lookup("MaxCardId", "cardid", array(), false)

Error:

Error whilst evaluating field [CARDID] on transaction type [OE0520]. Resolved Function - Lookup("MaxCardId", "cardid", array(), false) Error - Description: Subscript out of range

Support

5 years ago

Support 5 years ago

Try passing an empty string vs. an empty array.

Lookup("MaxCardId", "cardid", "", false)

Randy

5 years ago

Randy 5 years ago

That worked.... but empty arrays used to work.

Is this a change in 4.1?

Support

5 years ago

Support 5 years ago

Randy, thanks.

It probably would have changed in v4.

We will make a patch to allow an empty array.

IMan 4.1 - Subscript out of range (3 replies)

Contact

Request Demo

Access Downloads

Username
Password

	Remember Me Lost your password? Register