"insert and show" problem

[selcukk]

Hi all,
I have a table in interbase which has an AutoIncrement primary key and thousands of records. In my program, these records are ordered by key field.

My problem is how to insert a record without changing the key values and showing this record in user-defined position. I tried to order by "date and time" but at this time when you update the date or time the position of record changes.

Is there any structure or information you know in interbase that can help me about this subject. I'll be very glad if you can help. Thanks...

Note : I use IBExpert 1.2

 

[svanels]

1) You have an autoincrement key in Interbase, are you using a trigger and a generator to do it?

Why you want to change the physical order of the records? If you are using queries the result will be shown in order you demand, regardless the physical location in the table.

Steven van Els
SAvanEls@cq-link.sr