searching forms

[Guest_imported]

I know, I have been here a lot and it is because you keep answering my questions.
Can anyone tell me if it is possible to create a search box for forms?
Eg. in html, you can create a search box for search for info on the web. Can you create a search box for forms 6i?
Please let me know before 9 am tomorrow if you can as I am required to provide a feedback.
If I say yes but cannot implement it. I am in trouble.
thanks in advance

 

[lewisp]

Yes you can, but what context do you require the serch to be in? On a single column or a match on any columns in the select list?

 

[Guest_imported]

Thanks lewisp.
I want the search to be able to match on any columns in the select list.

 

[lewisp]

You may have a button that when pressed runs code something like:

Set_Block_Property('block_name',
DEFAULT_WHERE,
'column_1 LIKE ''%' || :block.search_field || '%'' ' ||
'OR column_2 LIKE ''%' || :block.search_field || '%''');

Go_Block('block_name');
Execute_Query;

 

[Guest_imported]

Hi lewisp!
Thanks again.
If you don't mind, can you please fill some of the blanks.
I understand the column_1 to column_N.
I will fill in what I understand:

Set_Block_Property('Customer',WHERE,
cust_id LIKE ''%' || :block.cust_id|| '%'' ' ||
'OR cust_name LIKE ''%' || :block.cust_name|| '%''');

Go_Block('Customer');
Execute_Query;
thank you very much

 

[Guest_imported]

One other lewisp,
I think my question is mistunderstood.
What you gave me is great but I really am hoping to have a search box like the one we I am typing this thread in
where you can actually type in a keyword, Id or name and have it display lists of records based on that search criteria.
I don't think when button pressed will do the trick unless I am missing something which won't surprise me.

 

[Guest_imported]

lewisp or anybody, anyword on this?
Even if it is a when-button-pressed trigger, I at least will like to return a record based on a search criteria.
I will like what lewisp gave me to be tweaked. I am a lot of problems with it.
thansk anybody

 

[lewisp]

Christi, I think the solution to your problem is to create a control block. In that control block on the same canvas as your data you create a text item which will be your search box. Also create a button so that when you press it the contents of the search box will be used as per the query I defined in my second reply.

Let me know how it goes.

Needo, make sure the values defined in the combo box match the ones being returned in any queries. You should start a new thread if youre still having problems.