I know that when your are using a real database engine that the query is executed by the engine and not by ADO. ADO sends the query to the engine and a recordset gets back. I don't know how it is working with DBFs.


>Hi,
>
>I don't think so as one of my friend told me before that ADO seem to had
>problem in the SQL distinct command.
>
>If not, is there any way to solve this issue. Thank
>
>>I think that your problem is that DBF are not supporting the DISTINCT clause.
>>
>>>Hi,
>>>
>>>My VB6 written application using ADO 2.6 to pull
>>>some data from my dbf file is not giving me distinct
>>>record. Below is my code which is not giving me distinct
>>>record. I check Microsoft website and there is a article
>>>on this but is based on SQL server 6.5. It url is :
>>>http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q181479&LN=EN-US&rnk=1&SD=msdn&FR=1&qry=distinct&src=DHCS_MSPSS_msdn_SRCH&SPR=ADO&
>>>
>>>Please kindly advise me on how to solve this issue
>>>
>>>
>>> cn.CursorLocation = adUseServer
>>>
>>> rs.Open "SELECT DISTINCT Request_No, Outlet_ID, Trans_Date," & _
>>> "Delivery, Head_rem FROM inv_journal", cn, adOpenStatic, adLockReadOnly