Subject Re: [IBO] D2010 and 4.9.9
Author Geoff Worboys
>>> Could not convert variant of type (UnicodeString) into type (Double)
...
> interesting also that I never assign double values. I only
> ever assign integers. Why is it trying to convert '' empty
> string to double? This ACol is of type LargeInt. In the case
> of IBO sets I often assign to AsString from AsString - left
> over from when the IBO stuff didn't have LargeInt.

IBO attempts to work with early versions of Delphi, including
those without int64 support which only came in with Delphi v4
and variant did not support int64 until Delphi v6. I see some
code in SetAsVariant relating to SQL int64 types (and truth
be told I think I had something to do with it) that does
conversion to extended. [This was all about trying to avoid
loss of accuracy when dealing with int64 based numeric types
when using older Delphi versions... obviously it is an area
that needs review given the features of new Delphi versions.]

Debugging further into the SetAsVariant function inside IBO
should prove my hypothesis... but at the moment I assume that
will be the reason for the "double" aspect of the error.
(Converting blank string to int64 would get a similar error
anyway.)

--
Geoff Worboys
Telesis Computing