Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread DBISAM.refresh never seems to work
Thu, Apr 12 2007 9:42 PMPermanent Link

Kerry Neighbour
This is just a general comment. I have found that .Refresh never seems to
work. ie when you do a refresh on a DBISAM table or query, I would assume
that the recordset would reflect the current correct and full contents. But
it never seems to do anything at all.

What I have to do to get a true recordset is to do a Close/Open. This works
just fine.

ie  DBISAMTable.refresh

as opposed to
    DBISAMTable.close
    DBISAMTable.open

Is what I am seeing correct? Or am I somehow mmisunderstanding the operation
of the refresh method?

Fri, Apr 13 2007 12:17 PMPermanent Link

"Robert"

"Kerry Neighbour" <kerry@dojitraders.com> wrote in message
news:639022ca5eb88c94bd7b3facbb8@elevatesoft.com...
>
> Is what I am seeing correct?

No, at least not the way you describe it. For a query (canned result) the
dataset is now the canned result, not the underlying tables, so a refresh
would not show changes to the tables. It is true that in that case in order
to see changes to the tables you have to close and reopen the query. Maybe
that is your situation, I don't know.

But for a table or live query (basically the same thing), a refresh will
definitely populate it with the most current data.

Robert

Image