Frank,
I did play with that in the past. But hey, why not try again.
Here's the results for Autofilter on a table:
With postgresql over JDBC you need to use the "mixed" mode (that doesn't
sound good, sounds like mixed up).
Using "default" the error is: error boolean = integer (it tries to
compare boolean field "billable" = 1)
Using "SQL"and "Access" the error is: error setting filter criterium (it
tries to compare "Billable" IS TRUE)
Using "Mixed", it works fine. Must have missed that in the passed.
Using Autofilter on a form in Mixed mode also works.
But using Formfilter on a form (still in mixed mode): Error: operator
does not exist: boolean = integer.
Funny, once the boolean filter is applied using the Autofilter, you can
go to FormFilter and apply additional (non boolean) filters without error.
Issue: 82199
Ferry
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Ferry,
*Using form filters on boolean fields produce an error that an integer
can not be compared to a boolean. Funny, Base nows that the field in the
table is a boolean, because is dislays a checkbox, but when you want to
set the form filter on "Billable" it add the filter Billable = 1
one more thing, while I think about it ... I assume you connect using
ODBC or JDBC? Ever tried "Edit / Database / Advanced settings": "Boolean
Comparison Mode"?
Ciao
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
