Help with expression

[chrisdoane]

I am trying to setup an expression where, when opening a browse it asks for the following:

I have a Mailer_No field I want it to ask me "What Mailer Number" and will filter all records CONTAINING the entered number.

OR

I have an Address field and I want it to ask me "What Address" and it will filter to all records CONTAINING any of the text in the address field (ie. If ONLY the street name is known, all records CONTAINING the street name would be selected or if only the address is known, it will show all records CONTAINING the address numbers).

Thought this would work, but it does not.


((var->AskC_What_Mailer_Number$mailer_no)).or.((var->AskC_What_Address$address))

Any help would be greatly appreciated.

Chris

[Tom Cone Jr]

Re: Help with expression

The syntax in the filter expression will vary depending upon the data types involved.

Are both mailer_no and address fields character data typed?

Please describe the results you're getting using various input values.

Tell us where you've placed the filter.

I'm not a particular fan of using the Ask_C variables. You might consider getting the search criteria first, and then using that to filter the browse when it opens. Your post suggest you're opening the browse and expecting Alpha to then prompt for the search criteria.

[chrisdoane]

Re: Help with expression

Both are character fields.
Right now nothing happen Browse opens showing all records in rec_Num order. The browse is embedded in a form. I hit a button on one form. The new form opens with embedded browse in it. When the button is pressed the dialog box pops up asking me for my search criteria. No mater what I enter in the dialog boxes, I just get all records.

[Tom Cone Jr]

Re: Help with expression

Opening a form with an embedded browse is a very different thing than opening a browse.

Is the called form based on a set of tables, or just one table?

Does the called form have a permanent filter already? ( You'd see this in the Properties window for the form itself )

[chrisdoane]

Re: Help with expression

It is based on a .set and yes the form does have the permanent filter in its properties.

((var->AskC_What_Mailer_Number$mailer_no)).or.((var->AskC_What_Address$address))

[Stan Mathews]

Re: Help with expression

As Tom indicated, ask variables are not popular theses days due to their lack of flexibility and the newer options available. A simple xdialog would make it easy for the user to make a choice of which type of data to enter and filter the opening form appropriately.

Something like this.

DIM SHARED dtype as C
DIM SHARED entry as C
DIM SHARED varC_result as C
ok_button_label = "&OK"
cancel_button_label = "&Cancel"
varC_result = ui_dlg_box("Alpha Five",<<%dlg%
{region}
{region}Choose Mailer or Address:{endregion}|
{region}(dtype:Mailer Number);
(dtype:Address);{endregion};
;
Enter value to filter by:| [.40entry];
{endregion};
{line=1,0};
{region}
<*15=ok_button_label!OK> <15=cancel_button_label!CANCEL>
{endregion};
%dlg%)
if alltrim(dtype) = "" .or. alltrim(entry) = ""
	end 
else
	if dtype = "Mailer"
	:form.ViewQueried("yourformname","Mailer_no = "+quote(var->entry))
	else
	:form.ViewQueried("yourformname","Address = "+quote(var->entry))
	end if
end if

[chrisdoane]

Re: Help with expression

Stan,

If it's not too much to ask. How would that look?

[Stan Mathews]

Re: Help with expression

Amended my previous post with a sample. Replace yourformname with the actual form name. Mailer_no and address are fields in the parent table of the set?

This would be the code for a button on the form where you want to open the second form.

[chrisdoane]

Re: Help with expression

The dialog box looks great. But it returns "No Records in Query". Yes the Parent table has these fields. I've tried both an exact entry of a mailer no as well as just the street name in an address and got the same message of "No Records in Query"

[Stan Mathews]

Re: Help with expression

I was concentrating on the xdialog and neglected to pay attention to your filter preference.

if dtype = "Mailer"
:form.ViewQueried("yourformname",var->entry $ mailer_no)
else
:form.ViewQueried("yourformname",var->entry $ address)
end if

would be the syntax for the contained in queries.

To test first to see if we're on the right track, open the default form for the set, use the Query menu, Query by expression, and try each of the filters.

"Elm" $ address
"457" $ mailer_no

[johnkoh]

Re: Help with expression

Chris,

Work fine on my test and The form is base on single table.

Yes the Parent table has these fields.

- Are you trying it from SET table?

[chrisdoane]

Re: Help with expression

Yes it is from a set. Queries work fine from default form. Getting an error though when running normally. Also, though the error seems to be on the Address field. It does exist.

ScreenShot.jpg

[Stan Mathews]

Re: Help with expression

Error as in.........?

"No Records in Query" is not an error, just means no records fit the query. We may have to see a sample database to see what's not working.

My bad, should have said you needed

if dtype = "Mailer"
:form.ViewQueried("yourformname",quote(var->entry)+" $ mailer_no")
else
:form.ViewQueried("yourformname",quote(var->entry)+" $ address")
end if

[chrisdoane]

Re: Help with expression

See image in previous post

[chrisdoane]

Re: Help with expression

Ok. Address is working fine. But Mailer_No is giving No Records in Query. I copied and pasted a record number from the parent table into the dialog box field for mailer_no "5-031383" and still got no record in query.