Hi Tim,.

> FOR SELECT
> l.Receipt, l.Receipt2, l.Acc_Num, l.Sub_Code,
> SUM(l.MQuantity) AS MQuantity, L.INV_TYPE, L.INV_PREFIX,
> c.SurName, s.Sub_Name, s.Card_Code, s.RegNum

<snip>

> INTO
> :Receipt, :Receipt2, :Acc_Num, :Sub_Code, :MQuantity,
> :Surname, :Sub_Name, :Card_Code, :RegNum, :inv_type,

:inv_prefix


The INTO list is not in the same order (following the names) as the select
list !!!!
You're putting INV_TYPE into SURNAME for example?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81