Hi Martin,


The problem is because in the Total field I have the following data:

0.00
 132
59.8
42.3
14.0
92.4
 328

The data type of this field is Float(14,2)... look at the point, it is not regular... I have two, one or zero numbers after the point.

How can I to resolve it?... if I drop this field the problem don't occours.

thinks.


>Hi Geraldo,
>
>How is DB server?
>Has table Table any date/datetime column?
>How is set of SET SYSFORMATS?
>How is set of SET DATE?
>
>MartinJ
>
>>Hi,
>>
>>
>>When I execute the CursorFill method of a CursorAdapter in VFP9 I get the following error message:
>>

>>"Microsoft Cursor Engine : Data provider or other service returned an E_FAIL status."
>>

>>
>>Using the same CursorAdapter, changing only the SelectCMD propperty the error can occur or no.
>>if this.SelectCMD = "Select * from Table1" && the error doesn't occur
>>if this.SelectCMD = "Select * from Table2" && the error occurs
>>
>>I reindex the tabela, mas but it don't solution.
>>
>>- accessing the table by CursorAdapter the error occurs
>>- accessing the table by SQL PassThru (SQLExec) the error doesn't occur
>>- accessing the table by nativamente do VFP the error doesn't occur