Re: Accessing sorted records via VB
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 05/18/04
- Next message: Joe: "Audit trail while in Transact SQL"
- Previous message: KT: "Change datatype on all table (HELP, HELP, rush)"
- In reply to: DB: "Accessing sorted records via VB"
- Next in thread: DB: "Re: Accessing sorted records via VB"
- Reply: DB: "Re: Accessing sorted records via VB"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 12:31:37 -0500
Why not include an ORDER BY clause as part of your SELECT statement that retrieves the data from the database? This will make sure that the data is ordered when you process it.
Out of curiosity, what are you doing witih those 2 million rows? That is a lot of data to return to a client!
-- Keith "DB" <daveblair(nospam)@adelphia.net> wrote in message news:2B40A335-3556-4416-9CD0-3652E36DB319@microsoft.com... > I have an SQL 2000 table with many millions of records. I would like to process this table sequentially sorted on 2 of the fields in a VB program utilizing ADO connectivity. While I have an index over these fields, it is not the primary key. I don't see how to tell VB to use this index as the processing order. > > Thanks for the help :-)
- Next message: Joe: "Audit trail while in Transact SQL"
- Previous message: KT: "Change datatype on all table (HELP, HELP, rush)"
- In reply to: DB: "Accessing sorted records via VB"
- Next in thread: DB: "Re: Accessing sorted records via VB"
- Reply: DB: "Re: Accessing sorted records via VB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
