Need to allow user to invoke "Show All"

[Wanda Tucker]

I need to edit this code to ALLOW the user to clear the searched records and allow all records in the database to show.

Here is part of the code that the "search" button filters for. This is the part that I need to edit.

Can someone help me with the code? Can I just delete part of this section of code?

Thank you,
Wanda

[Stan Mathews]

I need to edit this code to ALLOW the user to clear the searched records and allow all records in the database to show.

Here is part of the code that the "search" button filters for. This is the part that I need to edit.

Can someone help me with the code? Can I just delete part of this section of code?

Thank you,
Wanda

If the button resides on the form itself, any one of these should do it.

topparent.command("SHOW_ALL")
parent.command("SHOW_ALL")
parentform.command("SHOW_ALL")

[Wanda Tucker]

Not that simple, unfortunately. The button resides on a "menu" form with lots of other buttons that perform other searches, so I'm thinking I need to do something with the code in the OnPush event of the button.

I do have a ShowAll button on the form that is opened after any "search" buttons are clicked. If any additional filtering is done by the user, clicking the ShowAll button clears the searched criteria. It does not clear any filters from any of the "search buttons" on my "search" form.

Am I explaining it well enough? Also, I'm leaving in about 10 minutes and won't be able to respond back until tomorrow moring.
Thanks, Stan.
Wanda

[Stan Mathews]

Not that simple, unfortunately. The button resides on a "menu" form with lots of other buttons that perform other searches, so I'm thinking I need to do something with the code in the OnPush event of the button.

I do have a ShowAll button on the form that is opened after any "search" buttons are clicked. If any additional filtering is done by the user, clicking the ShowAll button clears the searched criteria. It does not clear any filters from any of the "search buttons" on my "search" form.

Am I explaining it well enough? Also, I'm leaving in about 10 minutes and won't be able to respond back until tomorrow moring.
Thanks, Stan.
Wanda

Not sure, is there a problem with having a show all button on each form that may be opened?

[Wanda Tucker]

The ShowAll button IS on the form that the "search" button on the "Menu" form opens, via code, instead of Action Scripting.

In other words:
1. Form A opens Form B when the Search button on Form A is clicked.
2. The search filters out records when Form B is open, which is why ShowAll on Form B IS already showing all records in the search.
3. Because Form B opens with the filter (search) ON, then the code for the search needs to be edited to allow Form B to truly show all records in the table - NOT just the one's that the search button on Form A filters.

Get it? So, I need help, please with re-writing the code to allow Form B to show all records.

Note that sometimes a user can/will use the filter button on Form B. In that case the ShowAll on Form B clears any/all filters invoked from that Form B. For this reason, I can't simply close Form B, Open Form A, click ShowAll (on the tool bar - or on a "ShowAll" button), Close Form A and re-open Form B with no records showing. The use would have to sit/wait and wonder why forms are closing, opening, closing, opening. I think that would be utter confusing to the user.

Thanks,
Wanda

[Tom Cone Jr]

Wanda, in form B do you want both:

a) the ability to release any filter that was in effect when the form opens, thereby showing all records in the table

and

b) the ability to release any additive filter run by the user after form B opens in a filtered state.

If I understand your question, you have (b) running ok. But you want (a). My question is do you want both?

-- tom

[Wanda Tucker]

Hi Tom,
Yes, that is precisely what I want. :)
Thanks!
Wanda

[Wanda Tucker]

Wanda, in form B do you want both:

a) the ability to release any filter that was in effect when the form opens, thereby showing all records in the table

and

b) the ability to release any additive filter run by the user after form B opens in a filtered state.

If I understand your question, you have (b) running ok. But you want (a). My question is do you want both?

-- tom

Tom, anyone...any ideas how to code precisely what you, Tom, suggest here?
Thank you,
Wanda

[Tom Cone Jr]

Example

Wanda, here's an example illustrating one way to release the form's embedded filter. Hopefully, this will give you some ideas you can use in your app.

-- tom

[martinwcole]

one way to handle this is to not set a filter for the form, from design mode - but rather to set it at the oninit event. Then the showall will easily work

like at oninit

t=table.current()
query.filter="companyname=var->cname"
query.order="companyname"
query.options=""
t.query_create()
parentform.resynch()

[Wanda Tucker]

Hi Tom and Martin,

Thank you so much for your suggestions, but I'm afraid neither of them will work - and for the same reason.

I can't place an embedded filter expression in the form, as there are several "search buttons" in 5 different forms (i.e. "search menus"), meaning that I would need just as many filter expressions. If there were a way to embed several filters on one form, then probably either solution would work.

Oninit is also part of the form properties, so I would only be able to invoke 1 "search" this way.

I'm toying with Tom's "Release Form Filter" button, but am getting error messages that the table doesn't exist (when, in fact, it does). I don't know code, and just have no clue what else to do with Tom's to adapt it to my app.

Any other ideas?

Thank you,
Wanda

[Tom Cone Jr]

Despite our best efforts I think we're not understanding each other. Best idea now is for you to post a working model and point us to a button and form that you can then use as an example... -- tom

[Wanda Tucker]

Dang it...maybe I'll have to do that, which will take some time, as all records are confidential.

For now, I'm trying the following code:

tbl = table.open("sites")
query.filter="Equake=Y"
query.order=""
query.options=""
t.query_create()
parentform.resynch()

The error message I get is:
t.query_create()
Not found
t. not found

I dont' understand what it's telling me.

I'll copy the entire app to a different name, put in some dummy records and post it. This could take awhile.

Thank you so much,
Wanda

[Cheryl Lemire]

Wanda,

You set the pointer as tbl

tbl = table.open("sites")

so you would need to use tbl.query_create()

[Wanda Tucker]

Here is the zipped database.
1. Open the Main Menu form
2. Click on the Quick Screen button under Saved Searches.
3. Click on the Earthquake-proof button, which filters out all but the records (in the Sites Data Entry form) with a "Y" in the Equake field.

To clear the filter, the user must go back to the Main Menu (there is a button towards the top of the Sites Data Entry form which, when clicked, gives the user a list of forms he/she can chose). From the Main Menu, user must click on the Sites button below Data Entry. Then, once back in the Sites form, user can click the ShowAll.

This is cumbersom, although if you read my Instructions directly on the Quick Screen Menu, you'll see that I had given up and was just going to leave it as is, with instructions to explain how to clear all filters.

Thank you!
Wanda