Need help revising OnPush event for a similar button

[G Gabriel]

Re: Need help revising OnPush event for a similar button

I edited the line to read:
The error message I get is: Cannot open table.
Yes, I have tbl=table.open("Sites")
Why am I getting the error?

Capacity_Shelter is a field in "building". You should open the child table, "building" not "sites"
dim t as p
dim cry as p
t=table.open("building")
query.filter="Capacity_Shelter=............."
cry = t.query_create()


In this scenario, you do NOT need cry().

[G Gabriel]

Re: Need help revising OnPush event for a similar button

I edited the line to read:
The error message I get is: Cannot open table.
Yes, I have tbl=table.open("Sites")
Why am I getting the error?

Capacity_Shelter is a field in "building". You should open the child table, "building" not "sites"
dim t as p
dim qry as p
t=table.open("building")
query.filter="Capacity_Shelter=............."
qry = t.query_create()


In this scenario, you do NOT need flattenquery().

Ignore the previous reply (that's what happens when you use spell check!)

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Makes sense, but still not right. I've tried it numerous times in numerous different ways.

Here is what I have:

dim global tbl as P
dim global qry as P
dim global nrecs as N

tbl=tbl.open("buildings")

query.description = "Search for matching records"
query.order = ""
query.filter = "trim((flattenquery(sites_Plus->buildings->Capacity_Shelter)=\"Cap_30\""

If I don't have the (sites_Plus...) from the Query.filter line, I get: can not open set.

So, I indicate the set name, and get the message: Could not find buildings.set.

What am I missing?

Thank you, Gabriel.
W

[G Gabriel]

Re: Need help revising OnPush event for a similar button

Where are you running this script from?

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Also, when I write:

tbl.open("Buildings"), I get the error:

Alpha Five is unable to reset the current table from within a card. A table reset can be done from a script that is run using the new script.spawn() command.

So, I studied script.spawn(), and hacked away at placing it here and there in the code. Couldn't figure out, again, WHERE to put it. Help is great at indicating what does what - but horrid at explaining any error messages. So many of the messages just tell you it can't do this that or the other, or it gives enough of a hint to drive me nuts. This is precisely why I struggle with code - and the precise reason I love Action Scripting. Action Scripting doesnt' cover everything, though - and it's those things that just sink me.
W

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Where are you running this script from?

The script runs from a form set up as a menu with several buttons that each run a different search.

It should be so incredibly simple, but isn't.

All I need the search buttons to do is filter the number of people a shelter can hold - i.e.:

capacity_shelter<30
Capicity_shelter>30.and.<51
Capacity_shelter>51.and.<75

Thank you, Gabriel.
W

[G Gabriel]

Re: Need help revising OnPush event for a similar button

Is that form based on the set?
What do you want to see after the script runs? do you want to see a report? a form showing only the records that meet the criteria?

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Is that form based on the set?
What do you want to see after the script runs? do you want to see a report? a form showing only the records that meet the criteria?

Yes, the Sites form is based on a set. After the script runs, I want to see the parent records that have child records that have the number 30 or less in the capacity_shelter field, in the same form. So, yes, the form, showing only the records that meet this criteria.

Thx,
Wanda

[G Gabriel]

Re: Need help revising OnPush event for a similar button

Wanda:
Actually you could do this very easily with Action Script or if you wish, zip you file.

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

With Action Scripting, I'm stuck on this:

After the query is run, a browse of the records in Buildings that meet the criteria is opened. I want the Sites form to open, instead.

However, when I add the script to open the Sites form after running the query, it does not hold on to the queried records. I think this is because there is a variable in the Oninit Event of the sites form, which Mike Wilson very pains-takingly helped me with. I think the variable clears any query run prior to the sites form opening.

On another menu that has a different kind of search criteria (i.e. it filters out all fire department districts that the site is situated in, except for those that meet the criteria - such as sites within the Redwood Valley Fire District) the queries run beautifully, as they are based on the parent.

Mike could probably nail this in one fell swoop, knowing what's behind the scenes, so to speak...yet, I already owe him so much for the work he has done to help me, that I hesitate to ask him about this.

I've pretty much decided to give up on it. It's not so easy to zip and send the file, either, because I'd have to copy it to a different directory and delete all the confidential data.

What a waste of time this has been for both of us!!! I sincerely apologize.

No wonder I'm 100% burned out on design work!!!!! I just want to take a sledge hammer to this computer.

Thank you, though!
W

[G Gabriel]

Re: Need help revising OnPush event for a similar button

I am not realy sure why would you put a search criteria in InOnIt ? That pretty much limit what you could use the form for. Why do not you take that script out off OnInIt, put it on a button or something else Or put it on that menu form), then you could use the form any way you want.

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Because taking it out screws up all the other searches. It all has to do with the ability to ShowAll after a search is run.

My brain is totally mush at this point. To rehash it all is not possible, as I know I'd miss a beat here and there. You can look at the thread and follow the whole thing from the beginning. I'll get the correct thread names and post them.

Wanda

[G Gabriel]

Re: Need help revising OnPush event for a similar button

[QUOTE=Wanda Tucker] It all has to do with the ability to ShowAll after a search is run./QUOTE]
You could do that with couple simple lines before running a new search that says:
t=table.current()
t.query_detach_all()
I am not sure what is the dilemma?

[Wanda Tucker]

Re: Need help revising OnPush event for a similar button

Gabriel,

If you really want to know, take a look at these threads:

Need to allow user to invoke "ShowAll"

and

Conditional action on an Oninit event

Good luck wading through it if you so chose to take the plunge!

W

[Wanda Tucker]

All I can do is give up at this point

[QUOTE=G Gabriel]

I am not sure what is the dilemma?

The delima was quite complex. You'll see, when you read through the two threads, I think.

Thank you again,
Wanda

If anyone can see the tree through this forest, I would be most thankful! For now, I've decided to not even use the "capacity search" menu. It's not worth the stress. So what if the user has to look through several records, at this point?

I always try to make my apps perfect - and half the time the effort isn't even appreciated. So, they don't get the luxury of running these "capacity" searches. I'm done unless someone takes it upon themselves to rise to the challenge and enlightens me with a solution that I can implement without having to know everything there is to know about code.