It would be interesting to see what affect binding the textbox to a transformed field.

Set the text box to default (none) format and inputmask. What happens when:

THISFORM.txtMyTestTextBox.Value=TRANSFORM(THISFORM.oRS.Fields('d_datec').value)

Does the error still occur?

The 1429 pops-up for both connection and record source errors [at least]. You may want to implement COMRETURNERROR and AERR() to help isolate the error. There is a download, "ADO Query Analyzer", that implements an ADO COM error service.


>Hi all,
>
>My COM object return a recordset this way,
>

>.Open("SELECT *, CONVERT(char(10) ,d_datec,102) as d_datec FROM &lcTable where c_codigo= '"+lcChv1+"'",This.lcConn)
>

>
>Then i bound the field in TextBox like this THISFORM.oRS.Fields('d_datec').value, and when i get the end of the field when typing VFP give me this error...
>
>Error #1429 - OLE IDispatch exception code 0 from Microsoft Cursor Engine.
>
>Any help here.. The other fields work ok.
>
>Thank's
>
>João Batista