Hmm,
try use CursorSchema for converting float to double.
MartinJ
>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