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@...>
To: <IBObjects@yahoogroups.com>
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/
>
>