I have a table that is ordered by a date and a time field. The users
do not enter the date and time, but they do fill in other information
on the record. As they do, and after I refresh the view, records with
the same date and time sometimes seem to be returned in a different
order.

Is it possible that Firebird is returning the records is a different
order since it has no instructions to the contrary? Do I need to
include the record ID in the "order by" to stop this? For example,
ORDER BY MyDate,MyTime,MyRecordID? Is there a better way?