Dear Anthonio,
is it not possible to use an UPPER() in SET FILTER
SET FILTER TO "UPPER(FIELD) = 'AAA'"
if i use this command:
Error description: Error ADODB.Recordset/16389 E_FAIL: _FILTER
Any Ideas ? In ODBC it works fine...
Regards, Norbert
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ADORDD and SE FILTER
Norbert,
Try to use UCASE() instead of UPPER()
Antonio Linares wrote:Norbert,
Try to use UCASE() instead of UPPER()
Antonio,
same problem.
Error description: Error ADODB.Recordset/16389 E_FAIL: _FILTER
Args:
[ 1] = C UCASE(A_EMAIL) LIKE '%MICROSOFT%'
Stack Calls
===========
Called from TOLEAUTO:_FILTER(0)
Called from ADO_SETFILTER(537)
Called from DBSETFILTER(0)Norbert,
ADORDD just routes your request to the ADO driver.
Lets google to see how to use upper() or similar on an ADO filter
Norbert,
Is FIELD a valid fieldname on your table ?
Antonio Linares wrote:Norbert,
Is FIELD a valid fieldname on your table ?
yes. i have testet, and i think, i don´t need any UPPER
it works with A_EMAIL LIKE '%MICOROSOFT%'
and A_EMAIL LIKE '%microsoft%'
Regards, Norbert
Norbert,
Glad to know you got it working 
NK wrote:Dear Anthonio,
is it not possible to use an UPPER() in SET FILTER
SET FILTER TO "UPPER(FIELD) = 'AAA'"
if i use this command:
Error description: Error ADODB.Recordset/16389 E_FAIL: _FILTER
Any Ideas ? In ODBC it works fine...
Regards, Norbert
Try
SET FILTER TO UCASE(FIELD) = 'AAA'
EMG