>Hi all,
>
>I think "ALLTRIM" in a sql expression ( SELECTCMD ) of cursoradapter is NOT supported.
>it give a error in the CURSORfill method.
>
>What can i do ?
>
>

> TEXT TO ocursorAdapter.SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>SELECT HDBK, Hid , HDOCNO, HAMOUNT,  STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
>STR(Createdon) AS 'createdon' , hremint  FROM <<.TABLES>>
>WHERE ALLTRIM( HDBK ) LIKE '<<Vp_in>>'
>  ENDTEXT
>

What database you're using? There is no alltrim function in SQL Server.