Why can't I filter ..AB.. ?

[woodyinoz]

Hi all,

I have a field which contains 3 values all with AB in them. These are,

AB2
B2_AB2
A2_AB2

What can I type in the filter to show all three values with AB2 in?

Thanks,

Woody.

 

[Guest_imported]

Don't think you can use a filter for what you want since you are only allowed to use .. after the characters in the filter. E.g. "A.." give the first and third values.

 

[Langley]

You can put each type of ocurrance in the filter using an 'or' operator.

i.e.

AB2 or B2_AB2 or A2_AB2




Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us

 

[woodyinoz]

The problem with using OR is thats sometimes I may have many instances where AB is present. This would of course render it impractical.

Is there any other method I could use other than filters?

 

[Langley]

Well, the only other thing I can think of is to base your objects on a query, where you <i>can</i> use ..AB2.. to get only those results. You could get fancy and even have a pushbutton that switched the underlying datasource from the query back to the table. Of course, if there are links involved, this may not be practical either.

Mac

&quot;Do not delve too deeply in the arts of your enemy and so become ensnared by them&quot;

langley_mckelvy@cd4.co.harris.tx.us

 

[ljprivara]

Why not use the DataSearch method to specifiy your search criteria, and scroll through the table using DataSearchNext method?

pushButton(var eventInfo Event)
   action(DataDearch)
endmethod

method pushButton(var eventInfo Event)
   action(DataSearchNext)
endmethod

When the find dialog box appears, select &quot;Advance Pattern Match&quot;; enter &quot;AB2..&quot;, without the quotes of course. By the way, if you want to enter more than one search criteria, separate each item using the pipe, &quot;|&quot;, not &quot;or&quot;.