| View previous topic :: View next topic |
| Author |
Message |
stan
Guest
|
 Posted: Fri Oct 13, 2006 8:11 am Post subject: how to set index |
 |
|
how to set the index fields in a ADOQuery?
Thx. |
|
| Back to top |
|
 |
Mick
Guest
|
| Posted: Fri Oct 13, 2006 1:26 pm Post subject: Re: how to set index |
|
|
In the sql statement itself try adding "order by (fieldname for index)" to
the end of the statement and the query will return its results set by any
field name you specify in the (fieldname for index).
You can choose to order the list in reverse by adding the ASC or DESC clause
to the order by.
example sql statement
select * from products
order by productname DESC
"stan" <stan (AT) yahoo (DOT) com> wrote in message
news:452f44c0$1 (AT) newsgroups (DOT) borland.com...
| Quote: |
how to set the index fields in a ADOQuery?
Thx. |
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Fri Oct 13, 2006 7:10 pm Post subject: Re: how to set index |
|
|
stan wrote:
| Quote: |
how to set the index fields in a ADOQuery?
Thx.
|
What do you want to accomplish by setting index fields?
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
