> > Also, I noted that card_id is an ambiguous reference, if
> you clean this
> > up the problem might go way.
>
> Ah! I think thats the problem right there. My older code
> had ambiguous column references which I fixed (originally
> because other databases were giving errors and now Firebird
> is too). I thought that Firebird would give an error about
> ambiguous column names though if this happened which is why
> it didn't occur to me that that could be the problem.

I'm very surprised that you didn't get the "ambiguous" error message.

So much so that I'm tempted to ask you for a test case, but I'll leave
Claudio V. to ask for one in case he needs one.


Sean