|Subject||Re: [IBO] Problem with TIBOTable|
Thanks much! Will give it a try.
--- In IBObjects@y..., hans@h... wrote:
> TIBO_QUERY Master/Detail
> From my experience, this works:
> Assume IBO_MASTER : TIBOQuery with DS_IBO_MASTER : TDataSource
> and IBO_DETAIL : TIBOQuery
> set IBO_DETAIL.SQL.TEXT = 'Select * from Detail where FieldA
> set IBO_DETAIL.DataSource := DS_IBO_MASTER
> set IBO_DETAIL.ParamCheck := True
> Now IBO_DETAIL will follow IBO_MASTER on
> IBO_DETAIL.FieldA = IBO_MASTER.FieldB
> No Error exception is raised if IBO_MASTER.FieldB doesn't exist.
> Don't forget unique keylinks on IBO_Master and IBO_Detail
> slsolutions2002 wrote:
> > Hello:
> > I have an application I am writing with D5. The application uses
> > TIBOTables for the reports. I must use TIBOTables or TIBOQuerys
> > since my report writer does not recognize the TIB_QUERY. I need
> > use TIBOTables instead of TIBOuerys since I need the master/detail
> > relationship in the table and can't find this in the TIBOQuery.
> > problem is this: I have a few lookup fields defined for the
> > TIBOTables. They work fine (display correctly on the report etc)
> > except I need to filter out lookup records with a blank
> > field. IBO does not seem to handle this well. If I try to set
> > filer, I get an error message that says the Field (The lookup
> > does not exist. If I try to use the WHERE SQL of the table, I get
> > the same message. However, IBO allows me to define and use these
> > fields normally otherwise. If I could use the TIBQuery I could
> > up a join which IBO seems to handle fine, however, since I can't I
> > must use lookup fields. Is there a way around this?
> > Also, I have a 2 TIBOQuerys on the form. When I select the form
> > make it active (at design time), I get error messages on both
> > that say "Statement must have an IB_Connection assigned:
> > qrCostCategory, <No Name>." Both queries do have a connection or
> > least I believe they do. When I select the connection property I
> > my connection name in the combo box, however after selecting it
> > property changes to <default>. Other than the error message when
> > activating the form the queries work fine. What could the
> > IB Objects - direct, complete, custom connectivity to Firebird or
> > without the need for BDE, ODBC or any other layer.
> > http://www.ibobjects.com - your IBO community resource for Tech
> > keyword-searchable FAQ, community code contributions and more !
> > Your use of Yahoo! Groups is subject to