its ok, sometimes you can't see the wood for the trees, as they say
DynamicQueryAdapter.Executebyid( "Test BAQ" )
Dim res As DataSet = DynamicQueryAdapter.QueryResults
erwin
DynamicQueryAdapter.Executebyid( "Test BAQ" )
Dim res As DataSet = DynamicQueryAdapter.QueryResults
erwin
--- In vantage@yahoogroups.com, "erwin" <erwinjw@...> wrote:
>
> Hi
>
> Having a bit of trouble with this code.
>
> If I try:
>
> Dim DynamicQueryAdapter As DynamicQueryAdapter = New DynamicQueryAdapter(QuoteForm)
> If ( DynamicQueryAdapter.BOConnect() ) then
> DynamicQueryAdapter.GetByID("Test BAQ")
> DynamicQueryAdapter.Execute( ds )
>
> but then the Execute is looking for a dataset
>
> if I try .ExecuteByID, it returns void, but where do I find the reult table?
>
> any help appreciated
>
>
> --- In vantage@yahoogroups.com, "erwin" <erwinjw@> wrote:
> >
> > thanks, I will try that
> >
> > --- In vantage@yahoogroups.com, "jckinneman" <jckinneman@> wrote:
> > >
> > >
> > >
> > > The business object dynamicquery can be used to run a BAQ. The result is a single table that you can bind to a grid. Any updates to the Grid would have to be done via another BO.
> > >
> > > You can also add filter criteria to the BAQ before executing it.
> > >
> > > Jim Kinneman
> > > Senior Consultant
> > > Encompass Solutions
> > >
> > > --- In vantage@yahoogroups.com, "erwin" <erwinjw@> wrote:
> > > >
> > > > Hi
> > > >
> > > > Anyone know how I can populate an UltraGrid on a form using a BAQ as the datasource?
> > > >
> > > > I don't want to add a dashboard to a sheet, but change the contents of the grid dependant on a button selection. A BAQ is required as I am filtering across multiple tables.
> > > >
> > > > any help appreciated
> > > >
> > > > erwin
> > > >
> > >
> >
>