Sathian,
According to the various ng around xbase and dbase themselves, if you use
ADO to access xbase databases forget about indexes. The question is
really:
why are you bothering about them? When you create your sql query simply
add
your 'order by' statement to the query.
e.g.
"Select C1,C2 From Tabl1 order by C1" or
"Select C1,C2 From Tabl1 order by C2" or
"Select C1,C2 From Tabl1 order by C2, C1"
HTH
Martin
"Sathian" <sathian.t@[EMAIL PROTECTED]
> wrote in message
news:cfpf8j$9g8$1@[EMAIL PROTECTED]
> Hello,
>
> We develop a desk top Application with VB 6.0 and DBASE III as its
database.
> The Application is working fine.
> However, we need to use different indexes on the same table and use
these
> indexes throug VB on Querying the database based on the requirerement.
> At present when we fire the Query (SQL) through VB, it is taking the
last
> created index by default and we do not know how to explicitly specify
which
> index to be used.
> Can anyone help us in this matter?
> Any clue on this would be highly appreciated!
> Any particular site where we see the related topics?
>
> Thanks in advance
>
> Sathian
>
>
>
|
