Results 1 to 5 of 5

Thread: Sorting records?

  1. Sep 13th, 2000, 02:38 PM #1
    jeffro
    jeffro is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253

    Question

    Hello

    Is there any way that you can sort the records in ado data control? I have the records sorted in ascending order in the database but when I scroll the records on my form they are in descending order.

    Any suggestions?
    Reply With Quote Reply With Quote
  2. Sep 13th, 2000, 02:45 PM #2
    CthulhuDragon
    CthulhuDragon is offline
    Lively Member
    Join Date
    Jul 2000
    Posts
    94
    Change your SQL statement. Not that familar with ado, but here is a sample SQL statement.
    "Select * from Table order by Name"
    Reply With Quote Reply With Quote
  3. Sep 13th, 2000, 03:06 PM #3
    HeSaidJoe
    HeSaidJoe is offline
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    you forgot the sort order...Dsc for decending.

    "Select * from Table order by Name Asc"
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    Reply With Quote Reply With Quote
  4. Sep 13th, 2000, 03:39 PM #4
    jeffro
    jeffro is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253

    Wink

    Thank you CthuluDragon, and HeSaidJoe both of your suggestions worked. HeSaidJoe just add a little secruity to the sql statement.

    Thanks again!!
    Reply With Quote Reply With Quote
  6. Sep 13th, 2000, 04:23 PM #5
    HeSaidJoe
    HeSaidJoe is offline
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    Wasn't sure what the default was. Since both work, the default is ASC...so CthulhuDragon, my apologies...you didn't forget..you knew better....I should have known it wouldn't be Dsc...in hind sight, that's as bad as thinking right to left as the default in reading.

    Later.
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    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