Subject RE: [firebird-support] Re: Corupting fields from simple SP
Author Tim Gahnström
> -----Original Message-----
> From: lysander_fb [mailto:lysandersyahooadress@...]
> --- In firebird-support@yahoogroups.com, Tim Gahnström
> <tim.gahnstrom@i...> wrote:

> If you have it exactly so, there could be a problem resulting
> from not putting the colons as prefix to the variable
>
> > trc.status = status
> > where transaction_row_content_id =
> > :transaction_row_content_id_v;
>
> try if it is better with colons:
> trc.status = :status
> where transaction_row_content_id = :transaction_row_content_id_v;

Thanks for the input.

I tried it but it didn't make a difference in this case.

Anyway I found it now (finally!). I had an eroneous trigger on updates of the particular. My variables in the trigger were declared as integer instead of varchar(10).

Thanks anyway for taking the time.

Tim