You will need to re-prepare the new SQL with the “status = ‘1’” and then
reopen the query.



Jerry



From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] 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??

Thanks.

Emerson

__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/





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