Jump to content

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


This topic is 7660 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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)

Link to comment
Share on other sites

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:CaptKurt@home.com

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7660 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.