Results 1 to 3 of 3

Thread: Sort an mdb datatable through VB6 code

  1. Dec 27th, 2008, 01:59 PM #1
    ktab
    ktab is offline

    Thread Starter
    Member
    Join Date
    Dec 2008
    Posts
    58

    Sort an mdb datatable through VB6 code

    Hello,

    I would like to know if i can sort a table using (SQL?) and change the index of each row. The reason is that I refer to this index to display data, and i'd like to have it sorted.
    E.g., now i use a string like "SELECT * From Customers WHERE AA=" & Cur_Row, where Cur_Row is an integer that is set programmatically, and AA field is unique index.
    Is there a way? Or an alternative to overcome this?
    Reply With Quote Reply With Quote
  2. Dec 27th, 2008, 06:26 PM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Sort an mdb datatable through VB6 code

    You could use the ORDER BY clause to sort a table according to a specific column or columns.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Dec 27th, 2008, 11:49 PM #3
    joebhoy
    joebhoy is offline
    Addicted Member
    Join Date
    Dec 2006
    Location
    Philippines
    Posts
    139

    Re: Sort an mdb datatable through VB6 code

    yeah, dee-u is right. :-)
    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