Subject RE: [IBO] TIBOQuery - master child relationship
Author Alan McDonald
And you have created the field as a persistant field? it won't work with IBO
components if it's not made persistent.
Alan

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Robert martin
> Sent: Thursday, 16 August 2007 2:38 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] TIBOQuery - master child relationship
>
>
>
> Hi
>
> > I assume you mean Datasource. TIBOQuery doesn't have a
> Mastersource property.
> >
> >
> Yes. Sorry I did mean DataSource.
> > 1. Make sure the SP actually is a selectable procedure. If it
> > doesn't return its output via a SUSPEND statement, it's not a
> > selectable procedure.
> >
>
> Yes it is a selectable procedure. It runs fine when first opened (for
> the current item in the master ) but when the record in the master
> record changes the results do not update (and yes they should be
> different).
>
> > 2. What's the actual fieldname of the linking key? Is it ItemRef or
> > "ItemRef"? They're not the same.
> >
> ItemRef (no double quotes)
>
> > 3. Is ItemRef in the master a unique key? The M/D linkage will be
> > garbled if it's not.
> >
>
> Yes it is the primary key of the master.
>
> > 4. And I suppose this should be the first check: have you actually
> > tested the SP independently, with parameters, to see whether it
> > returns the output you expect?
> >
> >
> Yup. The results are perfect.
>
>
> Thanks
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>