We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

indexing database

timpeters
timpeters asked
on
Medium Priority
156 Views
Last Modified: 2010-05-03
I am having difficulty appending records to the end of a database.  I understand how AddNew works but it sometimes puts records in between other records instead of at the index.  I even have a primary key that I created.  This primary key is of integer type and I increment it when I add a new record.  When it reaches 10, it appends that after index 1, not after index 9.  How do I overcome this?  I need to append each new record at the very end.
Comment
Watch Question

What are you using to view the data with?

Does it view like

1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9?

Also, what type of database are you accessing?
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.