Subject fake boolean problems
Author Clay Shannon
I created a domain, D_BOOLEAN, that is in actuality a char(1), in which to
store values 'T' and 'F'



However, when I attempt to insert a 'T' into that column, I get:



:

Incompatible column/host variable data type.Dynamic SQL Error.

SQL error code = -303.

conversion error from string "T".





ADAMA is a true Boolean that gets passed to a procedure that calls a stored
proc.

The relevant code is:



if ADAMA then

sp.ParamByName('DAMA').AsString := 'T'

else

sp.ParamByName('DAMA').AsString := 'F';



Why might this be causing a problem?



Using FB 1.5.2, Delphi 7, and 6.1.0 FIB+ components



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]