Sorry for that badly formed message, I was very tired when I wrote that!

To explain more fully, they want to use Access as their front end, but I
want to use OpenOffice. Access sees boolean as 0 and -1, and Openoffice
sees boolean as 0 and 1, so I just wondered if there was a way of
forcing either program to match the other, as ENUM does in MySql.

Rob Davis



Robin Davis wrote:

> Hello folks,
>
> Is there an equivalent to ENUM(-1,0) which I can use for boolean fields.
> I am trying to ween my office off Microsoft Access as theor database,
> but they simply won't stop using Access as the front-end. We have made
> extensive use of checkboxes in the past to speed up the work but I'm
> afraid they'll choke on using Firebird unless I can provide a totally
> transparent chage over for them. They are not interested in the
> background advantages of the change over, they just want EXACTLY the
> same interface they're used to. I've solved the case insensitive search
> issue, but this checkbox lark could be a deal breaker.
>
> Alternatively, how do I get access to use 1 and 0 instead of -1 and 0 in
> checkboxes? ;-)
>
> Sorry if this is poor question, not totally my fault. ;-)
>
> Rob Davis
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>