add a real boolean datatype and also a
Why does GetAsBoolean() not work here?? you can make a CF to wrap it in...
Why i should trick around and not use a standard datatype ?
Beside of a smaller and faster database with a native 1-bit datatype.
Can't see how/that we get anything 'faster' as a result here, its already stored as a number with only 2 index values being possible.
The general argument is that databases might be smaller by not reserving more bytes to store than required, but then we can easily change field type on the fly if required which is nowhere near as possible with those other databases...
Nearly every Database has an "ALTER TABLE ...".With an ALTER TABLE it's possible to change the datatype.
You may use ALTER TABLE (if you have the FM db shared with xDBC). Or you may change a field type in FileMaker through the define fields (Manage Database). What was your point in bringing up ALTER TABLE on a product idea for boolean datatype?
Just a reply to the statement
but then we can easily change field type on the fly if required which is nowhere near as possible with those other databases...
Just to show that it IS possible with 'those other databases' ;-)
Yes, but the "easily change" was the FileMaker part of the statement. ALTER TABLE is not as easy (yes, I'm a SQL dba, too!) But you are correct on the "possible".
Retrieving data ...