Re: openoffice and boolean

Le mardi 28 décembre 2004 à 11:52 -0600, Scott Marlowe a écrit :

> > Connecting OOo 1.1.2 to Postgresql via JDBC I can't seem to find the
> > correct OOo query editor criteria for a boolean value. Does anyone know
> > the magic formula?  The value in the database is 't'. = TRUE ='t' etc.
> > etc. don't work.
>
> Those queries are usually of the format:
>
> select * from sometable where somefield IS TRUE

returns "was expecting - or NULL"

> or simply
>
> select * from sometable where somefield

I'll try and write that into the non standard SQL editor of OpenOffice.

Thanks

Tony