Page 1 of 1
ADORDD and SE FILTER
Posted: Wed Jul 18, 2007 11:17 pm
by NK
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
Posted: Thu Jul 19, 2007 7:17 am
by Antonio Linares
Norbert,
Try to use UCASE() instead of UPPER()
Posted: Thu Jul 19, 2007 7:48 am
by NK
Antonio Linares wrote:Norbert,
Try to use UCASE() instead of UPPER()
Antonio,
same problem.
Code: Select all
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)
Posted: Thu Jul 19, 2007 9:11 am
by Antonio Linares
Norbert,
ADORDD just routes your request to the ADO driver.
Lets google to see how to use upper() or similar on an ADO filter
Posted: Thu Jul 19, 2007 9:12 am
by Antonio Linares
Norbert,
Is FIELD a valid fieldname on your table ?
Posted: Thu Jul 19, 2007 10:50 am
by NK
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
Posted: Thu Jul 19, 2007 11:20 am
by Antonio Linares
Norbert,
Glad to know you got it working
Re: ADORDD and SE FILTER
Posted: Thu Jul 19, 2007 11:20 am
by Enrico Maria Giordano
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