Stephan Szabo wrote:
<snip>
>For the first one, you're making a query string that has lines like
> foo = rec.bar
>where you really want
> foo = <value of rec.bar>
>
>So for execute you want something like
> '' ... foo = '' || rec.bar || '' ... ''
>(possibly requiring casts)
>
>
</snip>
Okay, fixed that ...
<snip>
>As Tom said, this looks like something else. Do you have a rule on
>currentlist that also does an update on currentlist, perhaps forcing
>certain values or something?
>
>
</snip>
Yes, I did have a rule on the table which I had completely forgotten about. I removed it and the function works
properlynow.
Thanks Stephan and Tom!
Ron
