@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]
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
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
@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
Change your matching as it contain only one of your fields but as you say you
have composite uniqueRegards,Karol Bieniaszewski
null