Glad you got it!

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Anthony" <anthonydcruze@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 06, 2001 8:40 AM
Subject: Re: [IBO] PrepareSQL and AfterPrepare


> Sorry,
> I have a custom event on my DSP to set the SQLWhereItems, but i had
> forgotten to do:
>
> qry.unprepare;
>
> so that the prepare will fire each time
>
>
>
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > If these events don't fire I guarantee your dataset will return
> empty.
> > Even if the dataset is empty these events should still fire at some
> point.
> > In your situation you are dealing with pooled instances so unless
> you are
> > unpreparing them or at least calling InvalidateSQL at the first of
> each
> > "hit" these events will not be triggered each time a provider makes
> a
> > request from a dataset.
> >
> > HTH,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Anthony" <anthonydcruze@y...>
> > To: <IBObjects@y...>
> > Sent: Wednesday, June 06, 2001 7:19 AM
> > Subject: [IBO] PrepareSQL and AfterPrepare
> >
> >
> > > using IBO_Query in MIDAS app server app.
> > >
> > > Am I right in saying that PrepareSQL and AfterPrepare events do
> not
> > > get 'fired' if the query returns an empty dataset?
> > >
> > > If so, what event does get fire every time after a query has
> > > executed, wether it returns an empty set or not. I have some vars
> > > that MUST be cleared after each time the query is openned.
> > >
> > > Thanks
> > >
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>