Re: [firebird-support] update or insert inside a stored procedure

[Issam Boughanmi amigof...@gmail.com [firebird-support]]

@Mark:
it's a little hard to give a reproducible example but please look this
please :

1) Error on executing the stored procedure
[image: e1.jpg]

so i search for records with these Fields

[image: e2.jpg]

then run a new query with the hardcoded values without a problem

[image: e3.jpg]


[Non-text portions of this message have been removed]

ODP: [firebird-support] update or insert inside a stored procedure

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

As Mark say „Please provide a reproducible example.”

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

Single query is not the answer because in stored procedure you have loop with 
multiple records

regards,
Karol Bieniaszewski

Re: [firebird-support] update or insert inside a stored procedure

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 31-10-2018 17:05, Issam Boughanmi amigof...@gmail.com 
[firebird-support] wrote:
> 
> 
> @Karol :
> 
> there is 3 fields :
> v*A*num : 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?

Yes, but you don't take into account the situation where the combination 
of vInum + ancode already exists.

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

Please provide a reproducible example.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] update or insert inside a stored procedure

[Issam Boughanmi amigof...@gmail.com [firebird-support]]

@Karol :

there is 3 fields :
v*A*num : 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 .

Re: [firebird-support] update or insert inside a stored procedure

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Change your matching as it contain only one of your fields but as you say you 
have composite uniqueRegards,Karol Bieniaszewski
null