Why does this

_Type IN ('Horror')
AND
(
(_Actors CONTAINS 'Mell Gibson' AND _Actors LIKE '%Mell Gibson%')
)
AND
(
(_Comments CONTAINS 'ghost' OR _Film CONTAINS 'ghost' )
)

work as a where clause but not as a filter?

Roy Lambert

ps in case you were wondering I've got fed up of not knowing in which box dvd's and tapes taken from the tv over the years is in, and in fact what we have.

It seems that a filter doesn't like the contains & like tests together. Leave one out and its fine, try and combine for a "phrase test" and blowie

Roy Lambert

Roy,

<< It seems that a filter doesn't like the contains & like tests together.
Leave one out and its fine, try and combine for a "phrase test" and blowie
>>

What exactly encompasses the "blowie" part ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>What exactly encompasses the "blowie" part ?

Yes - I can see where that might be helpful

My app
---------------------------
Debugger Exception Notification
---------------------------
Project Movies.exe raised exception class EAccessViolation with message 'Access violation at address 0064932F in module 'Movies.exe'. Read of address 00000058'.
---------------------------
Break   Continue   Help  
---------------------------


Your app - setting a table filter
---------------------------
ElevateDB Manager
---------------------------
Access violation at address 005818CB in module 'edbmgr.exe'. Read of address 00000058.
---------------------------
OK  
---------------------------

Works fine as a where clause

Roy Lambert

Roy,

<< Yes - I can see where that might be helpful >>

Does it occur when setting the filter, or after a post or some other
navigation ?  I have already fixed an issue whereby a CONSTAINS filter will
cause an AV after a post.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


When setting a filter. No post or navigation involved.

Roy Lambert

Roy,

<< When setting a filter. No post or navigation involved. >>

Okay, it's most likely the same issue, but I'll double-check to make sure.

--
Tim Young
Elevate Software
www.elevatesoft.com