help - find followed by sort in script, results in incorrect sort

[leedtran]

help please.

new user, converting large file express 6 database to fmpro5 has trouble

with script to 'find' then 'sort' in serial number reverse order (most

recent numbers first)

works perfectly as seperate scripts but not as a single

what am i doing

i sort manually on 'unique number' descending

open script editor whose lines read:

goto layout["data entry screen"]

enter find mode [restore, pause]

sort [restore, no dialogue]

press ok

replace find

replace sort

ok

done

when i run the script the result is unsorted or sorted in most recent

numbers last

if you can point me in the right direction, i would be very grateful

mal anderson, leeds england (where it is raining very hard at the moment)

[Kurt Knippel]

quote:

---

Originally posted by leedtran:

help please.

new user, converting large file express 6 database to fmpro5 has trouble

with script to 'find' then 'sort' in serial number reverse order (most

recent numbers first)

works perfectly as seperate scripts but not as a single

what am i doing

i sort manually on 'unique number' descending

open script editor whose lines read:

goto layout["data entry screen"]

enter find mode [restore, pause]

sort [restore, no dialogue]

press ok

replace find

replace sort

ok

done

when i run the script the result is unsorted or sorted in most recent

numbers last

---

I always seperate my find and sort scripts.

I am sure that the script is doing exactly what you told it. I would guess that something in your manual setup procedure has resulted in your saving the incorrect sort format.

I would setup the sort script and make sure that it sorts in the order that you want. Then simply add the Perform Script[sort Script] step to the end of your find script.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

[Vaughan]

Perform the sort just how you want it done. Now open scriptmaker and edit the script, don't change anything just click done, then select the option to update the sort order. Click OK.

Now run the script. Hopefully the sort should be OK. If it isn't look to make sure you only have one sort step in there.