I did this earlier today,

teammatt3 — Wed, 16 Jul 2008 16:54:28 +0000

I did this earlier today, and it put the new record where the one I just deleted was.

I experienced the same behavior. I'm still unsure if I'm always guaranteed that will happen but I guess I'll take my chances.

try deleting out a row from

Greg K — Fri, 11 Jul 2008 19:26:42 +0000

try deleting out a row from the middle of the ones returned to you, then add another row.

I did this earlier today, and it put the new record where the one I just deleted was.

When you need to make sure it is the same, give it rules to follow to make sure can (add PK or Order field and sort with it).

-Greg

teammatt3 — Fri, 11 Jul 2008 19:08:37 +0000

And yes, I know that I could add another column that contains the order in it, but that's not my question.