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,

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?

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

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.

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.

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