Great - hope this helped.

Martijn

> OK, I see the problem you are talking about here.
> I'll add this to my list of things to watch out for.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
>
> > Hi Jason,
> >
> > I quoted (part of) the original conversation below.
> >
> > ===
> > ok - while writing this email - I did some debugging and I found where
> > it went wrong... I think there's a bit of a combination of factors

here...

> >
> > First, here's the DDL for the table that's giving the error:
> >
> > CREATE TABLE IA_REPORT_RELOAD
> > (
> > ID INTEGER NOT NULL,
> > IA_REPORT_ID INTEGER NOT NULL,
> > RELOAD_ID INTEGER,
> > CONSTRAINT IA_REPORT_RELOAD PRIMARY KEY (ID)
> > )
> >
> > Here's the statement that gives the problem:
> >
> > SELECT RELOAD_ID FROM IA_REPORT_RELOAD