Re: [ic] Search problem ...

[Stefan Hornburg <suppressed>]

Marco Mescoli wrote:

> Example:
> In the table products i would search all records that have:
>
> (substring "one" inside field1 or inside field2 or inside field3) and
> (field4="two") and (field5="three");
>
> I can make this query with SQL but this way it is not applicable inside a
> [search-region ] like my needs.
>
> Have you suggestions ?
You can use search groups. The following example searches for CDROM and
(scope = 1 or scope = 3) if SCOPE equals 1.

__NAME__ cdrom::star::new
st=db
ml=20
co=yes
tf=name
lf=category3
sf=class
se=CDROM
op=eq
[if variable SCOPE eq 1]
sg=0
os=0
sg=1
os=1
sf=scope
se=1
sg=1
os=1
sf=scope
se=3
[/if]
__END__

Bye
                Racke


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users