display the value of the filter on the form

[rrego]

When I run a query how can I display the query value on the form?

I been playing with this and found s system variable - system->current_filter but it just displays .t. value. I than try running an action - Refresh Display - but this also didnt work as the display value remains .t.

It will be very nice to have a variable showing the value of the query that displays the forms.

Thanks,
Raul Rego
GatewayMCH

[Stan Mathews]

Re: display the value of the filter on the form

Try designing a calculated field with the expression

current_filter_expn()

and place that on the form.

[rrego]

Re: display the value of the filter on the form

Try designing a calculated field with the expression

current_filter_expn()

and place that on the form.

Stan, now I am lost. i should have started that I am new to Alpha programming. about a month into it.

I could certainly create the calculated field BUT have values do I assign to it?
I create a query under query by form or Genie BUT dont know where the query values are for me to assign them to a calculated field.

Thanks,
Raul

[Mike Wilson]

Re: display the value of the filter on the form

Raul,
with the form in design mode, click on the xy toolbar button and type in

cfx=current_filter_expression()

Then from the dragdrop list, choose cfx from the calculated field section and drag it onto your form.

[Stan Mathews]

Re: display the value of the filter on the form

I could certainly create the calculated field BUT have values do I assign to it?

some_calculated_fieldname = current_filter_expn()

then place some_calculated_fieldname on the form.
Make sure you edit the properties for this calculated field after dropping it on the form and set the display format characters to enough to display the result.

[rrego]

Re: display the value of the filter on the form

some_calculated_fieldname = current_filter_expn()

then place some_calculated_fieldname on the form.
Make sure you edit the properties for this calculated field after dropping it on the form and set the display format characters to enough to display the result.

What the heck am i missing?
I created a calculated field cfx = current_filter_expn()
put the field into the form.

when I start the form it is blank as it should; however as soon as I run a query County="essex" where county is the field, it gives me the matched records BUT the cfx field shows .t. I want it to show the query value of county="essex"

thanks,

[rrego]

Re: display the value of the filter on the form

Raul,
with the form in design mode, click on the xy toolbar button and type in

cfx=current_filter_expression()

Then from the dragdrop list, choose cfx from the calculated field section and drag it onto your form.

Mike, I did cfx=current_filter_expn() but when I execute a query it simply shows .t.

I want it to show fieldname="value" or whatever was executed in the query

[Ted Giles]

Re: display the value of the filter on the form

This is a working example of what I think you want Raul.
Look at the form TEST.
I have noticed a "bit of a funny" in that the field with the value of the Query from the standard Form Query sometimes shows .t. rather than the value. Seems random, so you will have to test this out.
Sorry to be rambling on a bit, but on first form load, you will get the .t..
Run a Query and you will still get .t..
Close form and reopen and the field will be as anticipated.

[Mike Wilson]

Re: display the value of the filter on the form

I agree that based on Ted's example, the calculated field value on the form using CURRENT_FILTER_EXPN() is not working as expected. Attached is an alternative that uses a variable that defines the filter expression for the query, that filter expression variable is assigned as a form session variable, and the filter variable is placed on the form from the dragdrop list. That works as needed.

[Ted Giles]

Re: display the value of the filter on the form

Nice one Mike.

[rrego]

Re: display the value of the filter on the form

Cool!
thamk you all