Results 1 to 2 of 2

Thread: order in Recordset

  1. Dec 12th, 1999, 04:26 PM #1
    Wouter
    Wouter is offline

    Thread Starter
    New Member
    Join Date
    Sep 1999
    Location
    Barcelona, España
    Posts
    14

    Post

    How can I make the order in a Recordset the same as the order in a table. In my case the order indexes (Autonum) of the rows in the table are 1,2,3,4,5,6 but the order of the indexes in the recordset is 1,2,5,6,3,4, how can I make that the recordset has the same order as the table?

    Regards
    Wouter
    Reply With Quote Reply With Quote
  2. Dec 12th, 1999, 04:35 PM #2
    R@emdonck
    R@emdonck is offline
    Lively Member
    Join Date
    Nov 1999
    Location
    Belgium
    Posts
    98

    Post

    Hi,

    When you request your recordset with an SQL statement, you can use the "ORDER BY" statement to get it righ.

    R@emdonck
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width