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
