Switch off automatic sorting in a Table

[Former Member]

Hi everybody,

how is it possible to switch off the automatic sorting function of a database table? I don't want to lose the actuall order in my table.

regards,

Sid

[Former Member]

Sid,

You should not rely on how the database stores data in the table. If you want to achieve some sort order, then you have to implement it by architecting the table that way. For example, you can add updated date and time and then sort by those fields.

If you have some other sorting logic, then you may add a new column to the table and insert a sort number in it.