I want to get the text that would have been displayed for the last error if I
didn't have error set off.
For instance:
SELECT COUNT(*) FROM Wazoo
IF SQLCode <> 0 THEN
SET VAR vLastError = ('Error was' & CVAL('LAST ERROR'))
PAUSE 2 USING .vLastError
ENDIF
The problem is that LAST ERROR gives the error number, not the text. What I
want is the string '-ERROR- Wazoo is an undefined table. (2038)'.
I'm pretty sure that I remember that this was added to the language some time
ago, but all I can find is how to get the error NUMBER (LAST ERROR) and
location in the file (ERROR DETAIL), but not the message text itself.
--
Larry