Specifying Find Request Question

[Doubledunk]

Hello, I was wondering if it was possible to specify a find request to compare a field's content with a local variable.

this is what my codes looks like.

I have two fields in layout called whatever. the fields are called fname and lname.

GotoLayout(Whatever)

Set Variable($fname, VALUE: globalvariable_1)

Set Variable($lname, VALUE: globalvariable_2)

Enter Find Mode[]

Perform Find[Restore]

within the perform find I have specified the following find request.

Action: Find Records

field criteria

Database::fname ==$fname

Database::lname ==$lname

Please help, thank you in advance.

Carlos C.

[David Jondreau]

The Perform Find script step can't handle variables within itself. Also, it's unclear what globalvariable_1 is, it may be unnecessary.

Instead, try:

GotoLayout(Whatever)

Set Variable($fname, VALUE: globalvariable_1)

Set Variable($lname, VALUE: globalvariable_2)

Enter Find Mode[]

Set Field database::fname [$fname]

Set Field database::lname [$lname]

Perform Find[]

Edited September 4, 2007 by Guest

[Doubledunk]

Thank you David, that solution worked perfectly.

Take care, Carlos C.

[briandye]

what if I wanted to do a find based on values inside of a checkbox field?

Any chance I can search a field based on multiple values stored in a checkbox field?

[Fenton]

Short answer; Yes, but you have to say whether you want to Find All the choices (default, more or less, though kind of sloppy; a relationship would work much better), or Any of the choices. The latter requires a Loop to create a New Request for each value checked.

[briandye]

How would you do this with a relationship?I might be poorly executing what I am really trying to do here and not getting the results I am looking for because of it.

I am looking for the search to display records containing any of the values that may be checked off in the checkbox field. I am searching records based on a field in a products table called "ProductLineCode"

The checkboxes exist as a field called "ProductLinesToQuote" in another table called CustomerQuote.

I am looking to take the checked off product lines the customer would like to see quoted to them, and then switch to the products table, to a view I have created that displays each records on it's own sort of printer formatted presentation page. Then run a search and only display the product lines checked off in the Create a Quote module. I figure after I get this to display correctly I could also create a record of what was in the quote and other specifics on pricing, keeping a historic record of quotes created.