Subject Re: [IBO] "RequestLive" with Like in the WHERE clause
Author Helen Borrie
At 04:44 AM 5/10/2005 +0000, you wrote:
>Is it possible to have a live query if LIKE and a comparison condition
>are in the WHERE clause? It seems that this prohibits "live" and I
>want to confirm that it's not something else.

Put it this way. Suppose your RequestLive query is

SELECT <field-list> from employee
where last_name like 'Jo%'

Then, you insert a row with everything filled, including the last_name
'Smith'; then post, commit and refresh. Are you therefore thinking that
this record was not inserted, because it "disappeared" on refresh?

If it didn't except, it was inserted. But it won't appear in the refreshed
dataset, because 'Smith' is not like 'Jo%'.