Subject Re: [firebird-support] update or insert inside a stored procedure
Author Issam Boughanmi
@Karol :

there is 3 fields :
vAnum : primar key
vInum + ancode : composite unique index .

this is a little wierd to me : 
if the matching is based on the primary key , normally on the execution when the record is found it will update right and not insert a new one?

also like i said if i run this same query as a standalone outside the SP it run fine ..

hope it make sense .