| Subject | Re: [IBO] "RequestLive" with Like in the WHERE clause |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-10-05T08:39:36Z |
At 04:44 AM 5/10/2005 +0000, you wrote:
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%'.
Helen
>Is it possible to have a live query if LIKE and a comparison conditionPut it this way. Suppose your RequestLive query is
>are in the WHERE clause? It seems that this prohibits "live" and I
>want to confirm that it's not something else.
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%'.
Helen