Hi,

In my opinion FIB is treating that field as a boolean field not as string.
FIB has this functionality, that if the domain name contains the word
BOOLEAN it will treat those fields as booleans.
But it can be disabled.

Regards,

Luis Madaleno


Clay Shannon wrote:

>I created a pseudo-Boolean domain (VarChar(1) with default 'F' value)
>
>
>
>However, at run time, I get "Invalid data conversion" when I attempt to
>access the field thus:
>
>
>
>qry.FldByName['LATEXALLERGY'].AsString;
>
>
>
>If I change the code to:
>
>
>
>qry.FldByName['LATEXALLERGY'].AsString;
>
>
>
>I get the following error at compile-time:
>
>
>
>"Incompatible Types: boolean and string"
>
>
>
>What can I do to access this string/boolean value?
>
>
>
>(Delphi 7, Firebird 1.5.2, FIB 6.1.0)
>
>
>
>Clay Shannon,
>
>Dimension 4 Software
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>