Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Search option - maintain

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Search option - maintain
 Login/Join
 
Enigma006
Master
posted
hi

i am trying to implement search option in maintain tool but somehow its not working as expected. can someone help me with the MATCH statement with the tool.

I have a text box and search button. when something is entered and button is clicked, it goes to different form with htm table to show that matching record.

Thank you

This message has been edited. Last edited by: Kerry,


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
GamP
Virtuoso
posted Hide Post
quote:
somehow it's not working as expected

So, what have you coded, what's in the database, what do you expect and what do you get?
There is enough documentation on the MATCH command available, I assume you have already read those?


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Maintain Wizard
Master
posted Hide Post
I wouldn't use Match. I would use something like this:

COMPUTE search1/a0 = Input text
Reposition Keyfield
Stack clear outstk
For all next keyfield into outstk
where keyfield contains search1

Here input text is the value entered on the screen.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Enigma006
Master
posted Hide Post
Thanks for your replies.

@Mark - I am not much into the code and I am trying to do with the wizard.

@Gamp - Yes, I did go through the documentation and whenever I search, I just get what I entered in the search box.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
GamP
Virtuoso
posted Hide Post
quote:
I am trying to do with the wizard

Be aware that the wizard is quite limited. It will only give you some pretty standard code and in my experience most of the code you need is not obtainable through the wizard, although it does give you a head start in some situations.
Same with the FOR ALL ... WHERE ..., which syntax definitely is available through the wizard. You may need to fine tune the code after closing the wizard.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Maintain Wizard
Master
posted Hide Post
I highly recommend reading up on Retrieving records and using the Where clause. It is not difficult to code and a lot easier than using the Wizards.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Search option - maintain

Copyright © 1996-2020 Information Builders