>Last parameter in CA.CursorFill must be ADODB.Command when you use parameters:
>

>*** loCursorAdapter.CursorFill(.F., .F., 0, loRs)
>loCursorAdapter.CursorFill(.F., .F., 0, loCmd)
>

Hi Borislav,

According the VFP Help(see below), the last parameter cat be an ADO Command or an open RecordSet object. So I use RecordSet.
Now I change to ADODB.Command and the problem don't occurs.

Thinks about this help.


CursorAdapter.CursorFill( [ lUseCursorSchema [, lNoData [, nOptions [, Source ] ] ] ] )

Source
Specifies a reference to an ADO Command or an open RecordSet object.

The ADO Command object must have its ActiveConnection property set to the appropriate and already open ADO Connection object. When an ADO Command object is passed to Source, Visual FoxPro sets the ADO Command CommandText property to value of the CursorAdapter SelectCmd property. Visual FoxPro parses any parameters in SelectCmd, and creates and sets parameter values in the ADO Command object. CursorFill method then executes in the following manner: