Re: Access 97 DB to Postgres Migration Questions

I had the same problem with Access97 and checkboxes.
My solution was:
1. Uncheck the "bools as char" driver option
2. Create a function in PostgreSQL to allow for "-1"
to be accepted as "true". The code was posted by
someone, called (I think) "booleqint4". If you want
to try that, then search the archives for that name,
or email me and I will send you the code.

--- Ian Harding <ianh(at)tpchd(dot)org> wrote:
> There is a switch in the ODBC configuration under
> OPTIONS | DATASOURCE | PAGE 2 to use -1 as true. I
> think that will make it work, although I have not
> tried it.
>
> >>> Richard Huxton <dev(at)archonet(dot)com> 07/18/03
> 10:41AM >>>
> On Friday 18 July 2003 18:11, Andrew Gould wrote:
> > > They match up pretty much as you would expect
> > > int4=>long integer etc. One
> > > thing to watch out for is booleans - come
> through as
> > > 0/-1 in Access.
> > >
> > > Richard Huxton
> >
> > I'm dealing with this specific issue for the first
> > time. How do you suggest dealing with the boolean
> > incompatibility issue? I can't seem to make
> > checkboxes work; but I want to keep the pgsql
> boolean
> > datatype. Is there a way to change the value input
> by
> > checkboxes? Or do I have to go with the text input
> of
> > T, F, Y or N?
>
> I could have sworn they did work in Access, but I'm
> not in Windows at the
> moment.
>
> The issue I was talking about is that if you pass
> raw SQL to the database
> you'll want to use "T" whereas in recordsets etc you
> can carry on using "-1"
> etc.
>
> If I get back into Windows before I knock off
> tonight I'll have a quick check.
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
> cleanly
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com