Subject | fake boolean problems |
---|---|
Author | Clay Shannon |
Post date | 2005-03-17T18:44:28Z |
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]
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]