Hi naomi,

Paradox
THIS.cConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ ;
THIS.gboblinkdir + ";Extended Properties=Paradox 7.x"


OR

Advantage
THIS.cConnectString = 'Provider=Advantage.OLEDB.1;' + ;
'Data Source=' + THIS.gboblinkdir && + 'User ID=adssys;Password=""'




>>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.