Re: oracle post

log wrote:

> Because the long text field don't allow to enter query condition, I enter
> the query condition in the dummy character field v_qword1, then use
>
> select question_wording into :question_wording
> from archive.question_wording
> where upper(question_wording) like '%' || upper(:v_qword1) || '%';
>

just insert string:

upper(question_wording) like '%' || upper(:v_qword1) || '%';

into where clause of your Forms block.

Alexander Filonov,
Mosakin corp.,
email afilonov_at_empros.com

      afilonov_at_mosakin.com

All above opinions are my own and not necessarily of my employer. Received on Sat May 18 1996 - 00:00:00 CEST