How do I clear query from memory

[gwsgreg]

I use a query to search for a specific date for payments received and view the report which always works fine, but then I have a script that searches for payments made between certain dates like betewwn the 1st-20th and totals them on a report, which works great if i run it first after the program is opened. If I run the query for a specific date first or second, the script always will return the same value, it will not add totals for the date range asked, it always returns the same value as the query.

Greg

[Stan Mathews]

Re: How do I clear query from memory

then I have a script that searches for payments made between certain dates like betewwn the 1st-20th and totals them on a report

Might we be permitted to see said script so we could suggest modifications?

There are instances where CTRL-W (show all) might solve your problem.

[gwsgreg]

Re: How do I clear query from memory

i hope this zip attach works

[Stan Mathews]

Re: How do I clear query from memory

Greg,

That portion of the process displays an xdialog asking for two dates. Something else takes those two dates and performs the query.

Run your query as usual, then hold down the control key and type w. see what happens.

Another option is to use CTRL and I, select the query and delete it, should be bottom of the list.

[Mike Wilson]

Re: How do I clear query from memory

Stan,
I don't see either of these (Ctrl-I and Ctrl-W) listed in the shortcut keys list. They do nothing on my system. Are these your personal creations, possibly?

[gwsgreg]

Re: How do I clear query from memory

This is the query I run first and the the other script will always display this value.

DATEPD=VAR->ASKD_ENTER_DATE_

then I try to run the script of between dates and get the answer of the above query

[Mike Wilson]

Re: How do I clear query from memory

This is the query I run first and the the other script will always display this value.

DATEPD=VAR->ASKD_ENTER_DATE_

then I try to run the script of between dates and get the answer of the above query

This is the script Stan was refering to. It makes a difference what function is used to generate the query,(ie. base query vs others). Try the following and see if this works for you:

topparent:tables:[COLOR="Red"]PARENTTABLENAME[/COLOR].filter_expression =  ".t."
topparent:tables:[COLOR="red"]PARENTTABLENAME[/COLOR].order_expression = ""
topparent:tables:[COLOR="red"]PARENTTABLENAME[/COLOR].query()

[MikeC]

Re: How do I clear query from memory

Mike,

I don't see either of these (Ctrl-I and Ctrl-W) listed in the shortcut keys list.

If you float your mouse cursor over the filter or show all menu icons you will see these shortcuts appear....also show them in the top menu-->Query area.

[Mike Wilson]

Re: How do I clear query from memory

Mike,
I was referring to not seeing them listed in the documentations.

I have to be honest with you, although i am certain what you wrote would give me those items... I don't really have the slightest clue how to achieve what you outlined.

It's bed time here... goodnight gentlepeople.

[MikeC]

Re: How do I clear query from memory

Hi Mike,
I could not find these shortcuts in the documentation either. Thinking about it, I do remember where I found out about them---They were mentioned in Susan Bush's Alpha Made Easy v5 tutorial I used when first learning Alpha.

Another shortcut mentioned in her tutorial is Ctrl+S which, when in design mode, will save changes.

Also, here is a screenshot of what I was trying to refer to in my prior post regarding where to find the shortcuts mentioned here. Ctrl+S is seen when under the Main menu listing "File" when in design mode.