Okie, have recently upgraded my fm 5.5 solution to fm 7 and among some of the sillyness that i've been able to fix, I'm having trouble with this finding script.

My application is intended for dual platform and will be a bound solution for ethier mac or windows.

Basicly the script starts on one form where one of 4 global fields can be populated to help narrow the report down. the compile report button triggers a script in the line item file (cause it's an invoice with lineitems thing) and that script has the steps to:

switch to find mode

If the globals are not empty will set the respective fields to the contents of the globals (So i have 4 if's checking each global for not isempty)

Flips on error checking

Performs the find

If records where found, it then triggers another script that flips to the report layout and starts the process for printing the layout.

Otherwise an custom dialog is launched to explain no records where found.

What's happening though, is the last values are used for the search. If I set to the date to -1-2004....9-3-2004 it seems to work the first time, but if I go to run the report with a different date range, it'll do the find with the previous date range and wont use the range i just entered till i hit the compile report button again.

I have tried using a new record/request with a commit record/request to encompace the 4 if statments as I had a problem adding new line items to the lineitems file from the invoice file after conversion and adding a commit record/request in the right spot, the portal in the invoice file would reflect the new line items as it wouldn't otherwise.

Any help/thoughts would be great!

First guess: the Restore option is on for either Enter Find Mode or Perform Find. If that's not the problem, can you post your script here?

Restore was not set on the enter find, or perform find. this find process worked perfectly before i updated the solution to fm7 from fm 5.5/6.0 and even before that (this solution has it's roots all the way back to fm3).

What I found, is I need to add a commit records before I started the find process. I thought it was weird the that date range I entered wouldn't show up until the next find. If restore was set, it'd always give me the same find request, reguardless if the previous find was different than the current find request.

I guess the commit records/requests step is needed in all kinds of places that it wasn't before. What a rash.

Thanks for the help!