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 -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
