pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedCheck boxes with Access
2+ messages / 2 participants
[nested] [flat]
* Check boxes with Access
@ 1999-09-14 16:02 Sean W. Ellis <sean.ellis@oscenter.com>
1999-09-15 03:36 ` Re: [INTERFACES] Check boxes with Access Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 1 reply; 2+ messages in thread
From: Sean W. Ellis @ 1999-09-14 16:02 UTC (permalink / raw)
To: pgsql-interfaces
I have been extremely pleased with Postgres. And, using Access now as a
front-end is great using the ODBC driver. However, I cannot figure out
how to use checkboxes.
Any insight or VB code as a work-around ?
Thank you,
Sean Ellis, sean.ellis@oscenter.com
Office Systems Center, 110 N. Main, Victoria, TX 77901 (361) 575-6886
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Check boxes with Access
1999-09-14 16:02 Check boxes with Access Sean W. Ellis <sean.ellis@oscenter.com>
@ 1999-09-15 03:36 ` Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1999-09-15 03:36 UTC (permalink / raw)
To: Sean W. Ellis <sean.ellis@oscenter.com>; +Cc: pgsql-interfaces
"Sean W. Ellis" wrote:
>
> I have been extremely pleased with Postgres. And, using Access now as a
> front-end is great using the ODBC driver. However, I cannot figure out
> how to use checkboxes.
>
> Any insight or VB code as a work-around ?
>
> Thank you,
>
> Sean Ellis, sean.ellis@oscenter.com
> Office Systems Center, 110 N. Main, Victoria, TX 77901 (361) 575-6886
>
> ************
Checkboxes should be used with boolean columns types. There is a odbc
driver option called "bools as char" that should NOT be checked if you
are using a boolean data type for that column. Alternatively, you
could use a character type for a column, and turn on the bools as char
feature, and it should work also.
If you still have problems, look at the driver's logfile and see what
sql statement was sent to try and alter a checkbox field. That should
show exactly what the problem is.
Byron
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-09-15 03:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-14 16:02 Check boxes with Access Sean W. Ellis <sean.ellis@oscenter.com>
1999-09-15 03:36 ` Byron Nikolaidis <byron.nikolaidis@home.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox