There is no ALLTRIM function in Paradox database, only LTRIM and RTRIM functions, but no ALLTRIM in Paradox.
So, you must adjust your query and use LTRIM/RTRIM if you really need to remove spaces from the HdBk column before comparison.
Though are you sure you need it? And also, why are you using STR function with dates?
>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.
If it's not broken, fix it until it is.
My Blog