In Webfocus 7.7.04, I can't use the LAST function on a field greater than A254V in the TABLE FILE section. It gives that dreaded EDASERVE error that gives you absolutely no clue as to what the problem is.

I tried looking it up in the manual to see if I missed a limitation or something, but I can't find one (not to say that it is not out there). So, I'm making this public service announcement in case somebody can't find it either.

For example:

This will crash the agent:

DEFINE FILE CAR
CAR2/A255V=CAR;
END
TABLE FILE CAR
PRINT COMPUTE CARLAST/A255V=LAST CAR2;
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

But change it to this and it runs happily along:

DEFINE FILE CAR
CAR2/A254V=CAR;
END
TABLE FILE CAR
PRINT COMPUTE CARLAST/A254V=LAST CAR2;
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

And using LAST in the DEFINE is just fine too:

DEFINE FILE CAR
CAR2/A255V=CAR;
CAR3/A255V=LAST CAR2;
END
TABLE FILE CAR
PRINT CAR3
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

This message has been edited. Last edited by: Anatess,

Uh oh!

A11000V works fine in v7.7.03...

quote:

A11000V

That's sooo interesting! It works in 7.7.04 too!

A256V does not crash but it returns empty! I'm going psychotic...

So, here are the stunning results:
A257V only returns the first character.
A258V returns 2 characters.
A259V returns 3 characters.
... and so on and so forth...

Francis, can you try A255V and A256V and A257V and see what happens?

This message has been edited. Last edited by: Anatess,

These all work fine in v7.7.03, and in our v7.7.04 sandbox environment.

Now, THAT's really really interesting! What patch number do you have on 7.7.04?

Run

? REL
? GEN

to get the exact release and gen of the report server. while they maybe the same release they may not be the same gen.