Helen,

My SQL statement is quite simple:

Select * from registry where Parent = :ParentId;

I'm selecting all records that have the same "parent" in a table with a self join.

I did indicate that the parameter was an Integer, both, when I was using the numeric(18,0) definition and later when I changed to integer.

Thanks!

All my best,

Mauricio

----- Original Message -----
From: Helen Borrie
To: IBObjects@egroups.com
Sent: Friday, December 29, 2000 7:59 PM
Subject: Re: [IBO] Fields[xx].value - unidentifyed type: 14


Mauricio,

I'd like to see your SQL statement.

The error you reported is the same one that you get (or used to) in
IB_WISQL when running a perfectly good DSQL call but inadvertently forgot
to check the "Params" checkbox off, i.e. possibly it is happening because
IBO is searching for an expected parameter, or something similar...comes to
mind an updateSQL statement (Insert, Edit or Delete) parameterizing a
column that is not in the SQL statement.

H.

At 07:25 PM 29-12-00 -0300, you wrote:
>Just one problem. The kbMemTable component has a score of methods to deal
>with retrieving structure and data from a TDataset descendant.
>
>I don't really intend to rewrite the component, which is quite complex, so
>I've got to get my data from a TDataset descendant. That is why I chose
>to use TIBOQuery.
>
>Anyway, what kind of data is being returned? I checked TkbMemTable's code
>for copying data from a dataset and it sure looks like it should work with
>ANY TDataset descendant.
>
>Thanks!
>
>Mauricio Longo
> ----- Original Message -----
> From: Jason Wharton
> To: IBObjects@egroups.com
> Sent: Friday, December 29, 2000 1:43 PM
> Subject: Re: [IBO] Fields[xx].value - unidentifyed type: 14
>
>
> I suggest you use a TIB_Cursor to populate things like dataset containers.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Mauricio Longo" <mlongo@...>
> To: <IBObjects@egroups.com>
> Sent: Friday, December 29, 2000 6:55 AM
> Subject: [IBO] Fields[xx].value - unidentifyed type: 14
>
>
> > I'm trying to copy a TIBOQuery into a tkbMemTable and I keep getting
> > a Field "xx" must have a value error. While debugging I notice that
> > my watch on the Source dataset's value property (the TIBOQuery) keeps
> > showing "Unidentified type: 14".
> >
> > I'm using in this computer an older version of IBO - 3.3 or 3.4.
> > I'll retry this at home where I have the latest version. If this was
> > an issue, was it corrected?
> >
> > I was trying to gain some time on my IBO project since I have nothing
> > to do at work (I never had anything to do in the last working day of
> > the year. I don't know I bother to come to the office.) :-)
> >
> > Thanks!
> >
> > All my best,
> >
> > Mauricio Longo
> >
> >
> >
> >
> >
>
>
> eGroups Sponsor
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

eGroups Sponsor




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