Script Error

[ngwaltne]

I am running a database for a short time. Now I get this message. Is there a clear cause or do you need more info?

The previous script step "Sort" could not be completed because it restores an invalid request. Do you wish to continue with this script?

Thanks

[DykstrL]

The usual reason for the error message you describe is one of the fields used to define the found set has been deleted or changed in such as way that it cannot be used for a find.

[RussBaker]

Does you script use the SetField step to try to set a date or time field with a conditional symbol - like a ">" ? If so, you should use Insert Calculated Result. Set Field requires the data to be in the strict format of the destination field.

[LiveOak]

FM stores sorts for the "Sort" script step by using the sort order last sorted on when the script was created. To reset the sort and eliminate the message 1) sort the records the way you wish manually, 2) open the script in scriptmaker, 3) when closing the script you will be presented with a dialog box, 4) check the option to replace the sort order.

-bd