I use smallint as well.
You can create a domain that can emulate a logical column.

CREATE DOMAIN LOGICAL AS SMALLINT DEFAULT 0 CHECK (VALUE IN (0,1))

or

CREATE DOMAIN LOGICAL AS CHAR(1) DEFAULT 'F' CHECK (VALUE IN ('T','F'))

If you are using domains for columns definition, you can easily change all columns based on a certain domain in all tables. The good news are that records are not physically changed untill they are "visited"


>Oh I got it SmallInt and a 0 or a 1 does the job in the checkbox. If there are any better alternatives please let me know.
>
>>Hi all
>>
>>How can I represent a logical datatype in FireBird?
>>
>>Being a VFPer this is a major missing link for me.
>>
>>Please advise. And if possible also let me know what control in VFP can handle this alternative data type.