Subject | Equivalent to ENUM? |
---|---|
Author | Robin Davis |
Post date | 2006-02-27T12:20:50Z |
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
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