Subject | RE: [firebird-support] Re: Corupting fields from simple SP |
---|---|
Author | Tim Gahnström |
Post date | 2005-07-01T15:05:41Z |
> -----Original Message-----Thanks for the input.
> 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;
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