Subject RE: [IBO] CachedUpdates and Refresh
Author Jerry Sands
You will need to re-prepare the new SQL with the “status = ‘1’” and then
reopen the query.


From: [] On Behalf
Of Emerson - IBO - Firebird
Sent: Wednesday, November 17, 2010 1:54 PM
To: IBObjects Group
Subject: [IBO] CachedUpdates and Refresh

Hello there!

I have another question today.

In my TIB_Query I have this SQLWhere statement: WHERE status = '0'.

In response to some user action my program set the value of status to
'1' and execute Refresh method in TIB_Query.

So, I hope that the record with status = '1' disappears of my dataset,
but this doesn't happens. The record still there, even after I refresh
the dataset.

I imagine that it happens because I use CachedUpdates = TRUE in TIB_Query.

How to solve this??



Fale com seus amigos de graça com o novo Yahoo! Messenger

[Non-text portions of this message have been removed]