Subject | Re: [IBO] Searching |
---|---|
Author | Lele Gaifax |
Post date | 2001-04-02T09:08:16Z |
HK> Lele Gaifax wrote:
HK> qry.SQLWhereItems.Add('MemoField CONTAINING ' + someword')
HK> end;
As said, maybe I'm missing something, but that doesn't seem to work!
I have a breakpoint on that event, and it isn't triggered when I post
the search... I tried doing the same within the BeforeExecute event
handler but, AFAICU, the doc is clear: only within PrepareSQL I'm
allowed to alter SQLWhereItems....
Should I call InvalidateSQL on memo's OnChange?
thanx a lot,
bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.
>> I tried using the usual OnPrepareSQL, but of course didn'tHK> procedure qryPrepareSQL(Sender: TIB_Statement); begin
>> work as the query is already prepared at this time...
>>
HK> qry.SQLWhereItems.Add('MemoField CONTAINING ' + someword')
HK> end;
As said, maybe I'm missing something, but that doesn't seem to work!
I have a breakpoint on that event, and it isn't triggered when I post
the search... I tried doing the same within the BeforeExecute event
handler but, AFAICU, the doc is clear: only within PrepareSQL I'm
allowed to alter SQLWhereItems....
Should I call InvalidateSQL on memo's OnChange?
thanx a lot,
bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.