My database is in the proper order, but when I test it, the order is scrambled.

How can I get the sql simple test to show the records the way they are in the database?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
My database is in the proper order, but when I test it, the order is scrambled.

How can I get the sql simple test to show the records the way they are in the database?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I'm a bit confused here. First, I'm going to ASSUME that you're using a MS Access 2000 database on a WinNT based platform. I'm also gonna assume that you mean that the "PROPER ORDER" is the order of the fields by which you inputed into a table, ie:

tblUsers
fldName
fldAge
fldFavoriteColor

Now you want the output of a page to return with Name, then Age, then Favorite Color? You can change the output of a record, but not the field itself. Fields won't be alphabetized or ordered. It's as simple as placing the data from which field where you want it.

I know you're new here (2 posts at the time of this reply) but to get the best results from the forums, it's best if you provide as much info as possible. I can't formulate your problem from the question.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Thanks for the reply, and in the future, I will follow your advice.

I figured it out.

I am working in Access 2000 with Windows 98. In the sql advanced recordset statement, I opened up tables then clicked on the order button. My database now is in the proper order. What I can't figure out is why did I have to do that. Why didn't the database remain in the same order? I'm speaking of the order inside the fields, ie, 1, 2, 3. Instead, I got 3, 1, 2.

Tracey Johnson

Glad you figged it out. I've noticed that if you have a field called ID and if it's an index, then even after you remove files and such, it never uses that index again. (ie, record 1, 2, 3, 4, 5) then remove 3, then add another record and you'll have 1, 2, 4, 5, 6.

After a while, things could probably seem a bit out of order. 8<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Hey, as long as you got it fixed; that's all that matters!

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])