Xref: utzoo comp.sys.amiga.multimedia:153 comp.sys.amiga.programmer:2131
Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!rutgers!cbmvax!cathy
From: cathy@cbmvax.commodore.com (Catherine Godfrey - CATS)
Newsgroups: comp.sys.amiga.multimedia,comp.sys.amiga.programmer
Subject: Re: AmigaVision Problems...Help I'm Stuck!
Keywords: AmigaVision, database, variables
Message-ID: <20241@cbmvax.commodore.com>
Date: 1 Apr 91 23:52:54 GMT
References: <1991Mar28.011658.47180@cc.usu.edu>
Reply-To: cathy@cbmvax.commodore.com (Catherine Godfrey - CATS)
Organization: Commodore, West Chester, PA
Lines: 58

In article <1991Mar28.011658.47180@cc.usu.edu> sl3b4@cc.usu.edu writes:

>    "key".  What I want it to do is to select all of the records that contain 
>    the search string anywhere in that "key". Example:  Search string is
>    "BALL". The record with "BALL BEARINGS" would be selected but not, "RUBBER
>    MOUSE BALLS".  Can I do this?  If so how?

AmigaVision will only try to match the beginning of a key with your variable.  
You might want to consider the following options:

1) Add duplicate records...each with a different key field.  For instance, 
you could have a "Rubber Mouse Balls" record and then add two similar records, 
"Mouse Rubber Balls" and "Balls Rubber Mouse".  This way you could match this 
record if you were searching for "Ball", "Mouse" or "Rubber".  The obvious 
problem with this work-around is that it could make your database HUGE!

2) Create three (or four) new fields in your database and make them all key 
fields.  Each field would have a single key word.  
(The "Ball Bearings" record would contain:  Key Field 1 = Ball,  
                                            Key Field 2 = Bearings, and
                                            Key Field 3 = "".
The "Rubber Mouse Balls" record :           Key Field 1 = Rubber,
                                            Key Field 2 = Mouse, and 
                                            Key Field 3 = Balls.)
Whenever you do a search, actually do three searches.  Set up three SELECT
Icons with the first one trying to match your variable to Key Field 1, the
second trying to match the variable with Key Field 2 and so on.  Of course,
you want a simple check to make sure the previous SEARCH Icon didn't find
a match before you continue with the search.
   
Keep in mind, the problem with this work-around is that it could slow your 
search time.

>    logo you need.  BUT...how can I get the brush on the screen?  There is no
>    way that I can see that I can pass a variable with the path/filename of the
>    brush to be displayed to any of the AV type icons.  All of these icons

You can place a variable in the Filename field of a BRUSH Icon.  Just make sure
the variable is within square brackets, [].  

For example, your picture is in "Work:Apps/ILBM1/dog.pic" and
             your variable PICTURE = "ILBM1/dog", then 
             the Filename field would contain "Work:Apps/[PICTURE].pic".

In AmigaVision 1.53G you can use variables as filenames in Brush objects of 
the Object Editor, too.

>John Z.
>SL3B4@cc.usu.edu

Cathy

-- 
              ============================================
              Cathy Godfrey   {rutgers,uunet}!cbmvax!cathy
              Authoring System Support Specialist        
              Commodore Applications and Technical Support 
              ============================================