Reordering the database

#1

How can i reorder (not sort) the database permanently, according to a (or
more) field
(without exporting in a new database) ?

I have a database created with import folders (with images) and
i need reorder it according to "FileName" field.

#2

I need this order (by "FileName" field) because
i import each day many images and the new images
go to the end.
But i want to have always the order according to "FileName" field.

Ï "giannis" <zzzinobios (AT) freemail (DOT) gr> Ýãñáøå óôï ìÞíõìá
news

f2dnb8ak9HKENXTnZ2dnUVZ7s2dnZ2d (AT) giganews (DOT) com...

Quote:

How can i reorder (not sort) the database permanently, according to a (or
more) field
(without exporting in a new database) ?

I have a database created with import folders (with images) and
i need reorder it according to "FileName" field.

#3

In article <tYmdnU1GCorLDNXTnZ2dnUVZ8uadnZ2d (AT) giganews (DOT) com>, "giannis"
<zzzinobios (AT) freemail (DOT) gr> wrote:

Quote:

How can i reorder (not sort) the database permanently, according to a (or
more) field (without exporting in a new database) ?

I have a database created with import folders (with images) and i need
reorder it according to "FileName" field.

I need this order (by "FileName" field) because i import each day many
images and the new images go to the end.
But i want to have always the order according to "FileName" field.

You can't. New records are always added to the end, so even if you do
somehow "re-order" the records today, the next day's new records will be
added to the end anyway.

The only solution would be to have an Script that sorts the records, and
set the Preferences for that database to perform the Script when opening
the database (although it could take a while with LOTS of records and / or
a slow computer). This would give you the records in the correct order,
but as soon as you perfrom a Find or create / import new records they'll
be incorrectly ordered and you'll have to perform the Script to re-sort
them again.

Realistically, the sensible soultion is to Sort the records (or a smaller
Found Set) only when they NEED to be in that order, and otherwise not
worry about it.

Helpful Harry

)

#4

FileMaker is not so flexible as MSAccess !
Need many many improvements !!!

Quote:

You can't. New records are always added to the end, so even if you do
somehow "re-order" the records today, the next day's new records will be
added to the end anyway.

Realistically, the sensible soultion is to Sort the records (or a smaller
Found Set) only when they NEED to be in that order, and otherwise not
worry about it.

#5

The problem is that ALWAYS i need that order...

Quote:

Realistically, the sensible soultion is to Sort the records (or a smaller
Found Set) only when they NEED to be in that order, and otherwise not
worry about it.

Helpful Harry

)

#6

After serious thinking giannis wrote :

Quote:

The problem is that ALWAYS i need that order...

Realistically, the sensible soultion is to Sort the records (or a smaller
Found Set) only when they NEED to be in that order, and otherwise not
worry about it.

Helpful Harry

)

Well always sort them before you try to use them.

--
John G.

#7

giannis pretended :

Quote:

FileMaker is not so flexible as MSAccess !
Need many many improvements !!!

You can't. New records are always added to the end, so even if you do
somehow "re-order" the records today, the next day's new records will be
added to the end anyway.

Realistically, the sensible soultion is to Sort the records (or a smaller
Found Set) only when they NEED to be in that order, and otherwise not
worry about it.

If you do not like Fm go Go go back to MS in ACESSable.

--
John G.

#8

I dont like FileMaker because is so stupid program !

I prefer MSAccess because it have snapshoots !

Quote:

If you do not like Fm go Go go back to MS in ACESSable.

--
John G.

#9

FM is for newbies !

Quote:

Well always sort them before you try to use them.

--
John G.

#10

giannis explained on 15/08/2011 :

Quote:

FM is for newbies !

Well always sort them before you try to use them.

-- John G.

Some of us have been using FM quite successfully to do what WE want for
many years.
If you have real problem someone will try to help you.

If you do not like FM go away and stop complaining.

Oh! By the way, Top posting only displays your ignorance.

--
John G.