Subject | Exception when creating exception message |
---|---|
Author | Rick Debay |
Post date | 2005-04-14T19:43:27Z |
I get the exception:
arithmetic exception, numeric overflow, or string truncation
when executing:
EXCEPTION E_NOTHING_TO_INVOICE 'There are no uninvoiced Pharmacy bill
group fees for ' || BILLGRP || ' from ' || BDATE || ' through ' ||
EDATE;
The variables are:
BILLGRP Char(3)
EDATE Date
BDATE Date
If I run it in the debugger under Database Workbench, it works fine (the
correct exception gets thrown). If I change the line to:
EXCEPTION E_NOTHING_TO_INVOICE;
it then works fine.
I'm running FB 1.5.2.
arithmetic exception, numeric overflow, or string truncation
when executing:
EXCEPTION E_NOTHING_TO_INVOICE 'There are no uninvoiced Pharmacy bill
group fees for ' || BILLGRP || ' from ' || BDATE || ' through ' ||
EDATE;
The variables are:
BILLGRP Char(3)
EDATE Date
BDATE Date
If I run it in the debugger under Database Workbench, it works fine (the
correct exception gets thrown). If I change the line to:
EXCEPTION E_NOTHING_TO_INVOICE;
it then works fine.
I'm running FB 1.5.2.