×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

"insert and show" problem

"insert and show" problem

"insert and show" problem

(OP)
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

RE: "insert and show" problem

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close