Message-Id: <200012182321.JAA20291@mustang.sdc.com.au>
To: pgsql-interfaces@postgresql.org
Subject: re:ODBC handling of bools?
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 19 Dec 2000 09:51:24 +1030
From: Stephen Davies <scldad@sdc.com.au>

Thanks to those who replied to my earlier posting.

The "Bools as Char" option _was_ the immediate fix. What I had 
forgotten was that I was using Access as "middleware" and that you have 
to delete and relink the Access table for the driver change to take effect.
(The app involved was originally written for Access and then migrated to 
Postgresql)

My queries now work but the problem now, however, is that the bound 
checkboxes associated with the bools now give "type mismatch" errors 
(which they didn't before I changed the driver opton)

Cheers and thanks,
Stephen Davies


========================================================================
Stephen Davies Consulting                              scldad@sdc.com.au
Adelaide, South Australia.                             Voice: 08-8177 1595
Computing & Network solutions.                         Fax: 08-8177 0133