On May 8, 2009, at 3:31 PM, Chuck Pelto wrote:
That's pretty much IT, BUT the script step "Constrain Found Set"
will not accept variables for the data to be searched for. In the
project I am currently working on I don't mind that these Find
scripts won't accept variables for the name of the Table::Field to
be searched in. But the fact that variables cannot be used in
specifying the text or numbers to be searched on.
So, lacking that capability inside of the scripting system, I'm
forced to use the approach of going into Find mode from the script
and then loading the fields with the search criteria. But, there is
no way to do a Constrain Found Set doing that, because when you go
into Find mode, it automatically clears the previously found set. I
need to be able to search inside of the found records from Find
mode. And that, as far as I can tell is not feasible.
Do you see the problem?
Do you know of a solution?
I think you are misunderstanding the way the Constrain Found Set step
works.
Now let's say you want to do an initial find, then take some data
from that original find and REFINE the find of the original set of
records.
The script would look something like this:
Set Error Cature [ON]
Enter Find Mode []
Set Field [this, that]
Set Field [this, that]
Perform Find []
If [Get(FoundCount) = 0]
Show Message [No Records]
Halt Script
End If
Set Variable[$$Result1, Value1 from initial found set]
Set Variable[$$Result2, Value2 from initial found set]
Enter Find Mode []
Set Field [this, $$Result1]
Set Field [this, $$Result2]
Constrain Found Set []
If [Get(FoundCount) = 0]
Show Message [No Records]
Halt Script
End If
Does this add a bit of clarification? If not, I guess I need more
info to help you out.
I hope this helps!
Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
[email protected]
Direct Line - (714) 389-4026
Integrated data solutions to fit your business needs.
JUST RELEASED - Appointment 1.0v9 for FileMaker Pro 9
http://www.appointment10.com
For a quick overview -
http://www.appointment10.com/Appt10_Promo/Overview.html
