ADORDD and SE FILTER

[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

[Antonio Linares]

Norbert,

Try to use UCASE() instead of UPPER()

[NK]

Norbert,

Try to use UCASE() instead of UPPER()

Antonio,

same problem.

Code: Select all  Expand view  RUN

   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)


[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

[Antonio Linares]

Norbert,

Is FIELD a valid fieldname on your table ?

[NK]

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

[Antonio Linares]

Norbert,

Glad to know you got it working

[Enrico Maria Giordano]

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