Wow Helen .. You just blow my mind .. Works perfectly, wasn't aware of the
AssignSQLWithSearch()



Thanks a stack!!!!



Adrian





-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Helen Borrie
Sent: 15 May 2005 03:08 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] How to Sync IB_Query with Tdataset IBOQuery



At 02:54 PM 15/05/2005 +0200, you wrote:

>I'm generating reports using ReportBuilder.
>
>Thus I supply the data for the report using IBOTDataset.
>
>I Have a IBOQuery linked to the ppDBPipeline.
>
>Now to be able to use IBObjects IB_Searchbar, that is linked to IB_Query1

on

>a form, with a number of IB_edits which are used to create the selection
>criteria.
>
>Now this all works as expected. I can populate the IB_Query1 with the data

I

>require, but how to make IBOQuery1 = IB_Query1, so that I can use the same
>resultset for my report.
>
>It must be simple, and probably overlooking something here?

Have you tried MyIBOQuery.AssignSQLWithSearch(MyIBQuery)?

Helen




___________________________________________________________________________
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

* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/


* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



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