I see You use VFP 8. IMO it is easy if You create an CursorAdapter based on ADODB, then You can use it as an ordinary VFP Table (INDEX, SEEK ... ). About the second question if You create an CA there is no need to execute statements second time Just Use CursorRefresh() method of the CA.
>Dear all
>
>Can anybody Help me how to create and set 'Index' and use
>'Seek' Command in ADO RecordSets. I have a table with 3 indexes and
>i want to change index orders with respctive of my given conditions.
>Secondly, how will i check whether the recordset is opend or not.
>Because, i executed a statement at the first time its worked without any
>error but while execting the second time gives me error that 'ADODB record
> set operation is not allowed when the object is open...'. Then i just
>add a statement at the end that 'Recordset.Close'. But sometimes
> its giving same error when i calling from different Procedures.
>
>With thanks and Regards
>Abdulla
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.