Use Data in find Script

[dpmnyc]

Hello and thank you in advance!

I am trying to use a "form" to perform a search in a script. I have an unrelated table set up that I am using to create a layout and the values from that layout are copied into global fields.

I would like to use the values in these global fields in a "perform find" where (for example):

MembersTable::member_number>ComparisonTable::GlobalField

This find would change every time we filled out the form, but that is the point.

I am using the Script Manager, but i don't know the syntax to bring the values from the global field into the find.

Again, thank you for your help.

dp

[efen]

I have an unrelated table set up that I am using to create a layout and the values from that layout are copied into global fields.

Why not just have the global fields in another table and use those without the unrelated table from which the data will be transferred - or is the unrelated table already used for globals?

I'm not quite sure what exactly you require here ...

[dpmnyc]

Thank you for the reply. I guess I need to be more clear. I am not having trouble with the concept of the global fields. The table that contains the globals is a table that we use to track which reports were run and when they were run.

The problem I am having is much simpler (I think). In the script to run a report, I want the value from one global field from the reports table to be inserted into a FIND. The data is a numerical value for a date (20091215). I want to find all members from the members table whose EFFECTIVE_DATE is later than December 15, 2009. I am having trouble figuring out the syntax of the find request to insert the DATA from the global field. It seems that everything I try inserts the name of the global field and not the value.

How would I write the line of the script that inserts the value of the field global_eff_date into the MEMBER::eff_date and performs the find. I assume it is something like:

MEMBER::eff_date:[>(BROKER_RPT::rpt_st_date)]

but this doesnt seem to work. I get "BROKER_RPT::rpt_st_date" placed in the MEMBER::eff_date field.

I hope I am being more clear.

dp

[The Big Bear]

I think you are looking for something like this

Enter find mode

setfield(effective_date;gobalfield)

perform find.

Hope this help

Lionel

[dpmnyc]

PERFECT! It worked. Thank you.