I have a script that

" insert calculated value: "sold date" field
06/30/2005&"..."&07/05/2005

If I stop the script at this point it finds the appropriate records,
If I continue the scipt with the other "find" parmaters" it does not
work.


Thanks
jc lewis

JC wrote:
That would suggest that the find on the sold date is not the problem.
What other search parameters are you using?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

I "set field" "sold" = "yes"
"type" = "new"


Thanks
jc

Instead of doing it by script, please try doing the same criteria (sold
date, sold and type) in a manual find. Does that work? If not, take a
look at one particular record you would expect to show up in your find
results, just to double-check that it meets your criteria.

Let us know what happens when you try the above. Also, what version of
FileMaker are you using?

JC wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

JC wrote:
other. If so, each subsequent find will replace the results of the previous.

You can either take advantage of the constrain or extend find results
function or group into one find request with multiple criteria.

Michael Myett

Assuming you are actually using fields or quoted literals because

06/30/2005&"..."&07/05/2005

evaluates to

".0000997506234414....0006982543640898"


"Michael Myett" <michael.myett (AT) adelphia (DOT) net> wrote

Howard and ALL

Right after that it started Freezing up. So I un-installed and
re-installed FM 7.0v3 and it worked fine.

thanks so much for your time

JC