At 10:27 25.06.2003 +0200, you wrote:

>Hi all,
>
>I have a very strange error. Our production systems use Interbase 6.0.2.0,
>running an app written in D5 using IBX components.
>
>Running the following stored procedure in IB console produces a "arithmetic
>error, numeric overflow or string truncation error". This does not happen
>when the select only is run in IB Console, but only when the stored
>procedure is run.

Maybe because you mix SQL-89 and SQL-92? Change to

FROM
log L JOIN client C
ON
C.code = L.acc_Num
JOIN clnt_sub S
ON
S.code = L.acc_num
AND S.sub_code = L.sub_code
WHERE
L.POS_ID = :POSID
AND L.SHIFTNUM = :SHIFTNUM

(I'm only quoting the interesting bit, and the change is simply moving all
linking between S and L into the JOIN clause)

Or (more likely) it could simply be because you use double quotes for you
variable names.

HTH,
Set