Disable automatic sort in FileMaker v10

[piping]

Someone know how to disable the automatic sorting of records? I have several layouts that are sorted and I want to maintain the original sort until I finish to update the information of the records showing there, but any change that I made, produce the system re-sort the records. It is getting very annoyed. Is a way to stop that?

Thanks in advance for your help!

[bcooney]

I believe that if you unsort the found set, autosorting will stop. But there is no setting to turn it off.

[piping]

Thank you for your help, but I want to keep the order that the sort gave me. If I use the unsort, the automatic sort will stop, but it also change the order that I want to see my data. Is there another way to stop the automatic sort?

[Søren Dyhr]

Portalize via a cartesian product selfjoin relation might be a daft attempt, but here can the view be sorted by the contents of a value list?

--sd

[comment]

I am curious what you're hinting at.

[Søren Dyhr]

It was a daft stab indeed, but there might be something to it if we knew a little more about the data behind. But the automatic sorting is one of those things woosh over your head, which have given us dynamic reporting, and a slightly different refreshing of fields.

One of the companies i develop for have drawn a line in the sand and will only use fm8.5 since the core business is IWP ... and this new overhead disturbs in some way I can't remember in particular.

--sd

[comment]

It was a daft stab indeed, but there might be something to it

Such as? I'll give you all the data that's required. One table, one field. The requirement is to sort the records by the field, edit selected records and keep the initial sort order until all records have been edited.

[comment]

I have posted a possible workaround here:

http://www.fmforums.com/forum/showtopic.php?tid/210830/

[manuellois]

Link doesn´t work

Can you send me the a new link o a samplt to know how to do the workaround to solve the problem?

[thrasykles]

the workaround i use is based on the fact automatic sort is turned off while a script is running.

i use a script with just a single script step (pause script) and have it run in the background as long as i want the automatic sort turned off

Edited September 22, 2015 by thrasykles