sort script

[jon2004]

in my database i'm constantly getting this error message:

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

when i run the following script line: Sort[Restore, No dialog]

is there some global or application setting or preference i need to set?

what causes this message to appear?

[Lee Smith]

Hi jon,

I would print the script and and see what it is (isn't) doing. There appears to be a step that can not be perform because of a change to the script, a field, or file.

HTH

Lee

[jon2004]

The complete script is...

Go to Layout ["Report"]

Show All Records

Sort[Restore, No dialog]

what sort of change to the script , field or file?

[jon2004]

ok, further investigation reveals...

if i try and sort from the icon on the toolbar i get the following message

"Some fields in the sort order are invalid or cannot be sorted. You must remove these fields"

i'm then presented with the sort dialog box with the legend "Field Missing" in the sort order, which i replace with a valid field, click on sort and done and it sorts.

However if i then click again on the sort icon on the toolbar it happens all over again...........

arrgghhhh...... is something somewhere else re-inserting an invalid sort field??

[Lee Smith]

Preform the sort manually using the Sort under Menu - Records - Sort. Once the sort is complete, go to ScriptMaker, and select the Script used in the Button, choose Edit, and then click okay. You will get a dialog box asking if you want to "Keep" or "Replace" the "Sort", choose "Replace". Now the button should act like you want it to.

Lee

[jon2004]

ahhh ha... if this works you're up for a drink......

[jon2004]

thanks Lee that works a treat, any time your in London, UK drop by for a free drink.... :-)

[Lee Smith]

You are welcome, Glad it worked.

Now, if you don't already know what the problem was, print out the script again and compare it to the first one, and you will see what the problem was.

HTH

Lee

[jon2004]

i think the problem was in the keepreplace bit which kept data from some other sort info from the purchase order sample file i "borrowed" the code from. i couldn't find any documentation on that so just "kept" the original data.

its a bit "left-field" to keep context data in that format, it really is a fine example of what happens when data and interface are so thoroughly mingled (or mixed up).