Hi,

I would suggest to return varDouble (80 bit) value for any Numeric
(x,y) types. Returning a varUnknown is not of much help to anyone :)

best regards

Kim Madsen
kbm@...
Author of TkbmMemTable

--- In IBObjects@egroups.com, "Jason Wharton" <jwharton@i...> wrote:
> So how else do I get an Int64 value in a variant?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Mauricio Longo" <mlongo@c...>
> To: <IBObjects@egroups.com>
> Sent: Wednesday, January 03, 2001 11:03 AM
> Subject: [IBO] Re: Fields[xx].value - unidentifyed type: 14
>
>
> > Hi,
> >
> > > Same problem. It seems that however IBO places the data in the
> > > Variant Value property it does not transfer correctly to
another
> > > variant property.
> > >
> > > I'll try to do more testing on this in particular, without the
use
> > of
> > > TkbMemTable to see if I can get more info on this behavior.
> > >
> >
> > I just experimented with some code that looked like this:
> >
> > var
> > data: variant;
> > begin
> > if not qryGetRoot.Prepared then
> > qryGetRoot.Prepare;
> > qryGetRoot.open;
> > Data := qryGetRoot.FieldByName('id').value;
> > ...
> >
> > The debugger reports the value of "data" as being "Data: Unknown
> > type: 14".
> >
> > So, it is not a problem of how TkbMemTable gets the info from the
> > Dataset, but rather a problem of how IBO handles the type of the
> > variant value property. It *cannot* be assigned to a variant
> > variable.
> >
> > Any clues to as how I work around this?
> >
> > All my best,
> >
> > Mauricio Longo
> >
> >
> >
> >
> >