Sorry, but I still don't understand. I would like to refresh the attachment records after a remote user has an unnatural disconnect. For example, Windows freezes and the user must reboot. With my application, the connection count must be accurate. So, if you would kindly give me an example of how I can refresh that table. Sorry to be so dumb.

--- In firebird-support@yahoogroups.com, "Carlos H. Cantu" <listas@...> wrote:
>
> h> Can the initial, commited transaction transaction be a simple select query?
>
> Not sure if I understand your question. The transaction I'm talking
> about is the transaction associated with the query (select) ran
> against the monitoring table.
>
> Carlos
> Firebird Performance in Detail - http://videos.firebirddevelopersday.com
> www.firebirdnews.org - www.FireBase.com.br
>
>
>
>
> h> --- In firebird-support@yahoogroups.com, "Carlos H. Cantu" <listas@> wrote:
> >>
> >> h> How can I force a refresh of MON$ATTACHMENTS from a Delphi application?
> >>
> >> Afaik, the only way is to commit actual transaction associated to the
> >> mon$ query, start a new transaction and run the query again.
> >>
> >> Carlos
> >> Firebird Performance in Detail - http://videos.firebirddevelopersday.com
> >> www.firebirdnews.org - www.FireBase.com.br
> >>
>
>
>
>
> h> ------------------------------------
>
> h> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> h> Visit http://www.firebirdsql.org and click the Resources item
> h> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> h> Also search the knowledgebases at http://www.ibphoenix.com
>
> h> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> h> Yahoo! Groups Links
>