Xref: utzoo comp.sys.amiga.multimedia:155 comp.sys.amiga.programmer:2213
Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!decwrl!mcnc!uvaarpa!vger.nsu.edu!manes
From: manes@vger.nsu.edu ((Mark D. Manes), Norfolk State University)
Newsgroups: comp.sys.amiga.multimedia,comp.sys.amiga.programmer
Subject: Re: AmigaVision Problems...Help I'm Stuck!
Message-ID: <803.27f8c002@vger.nsu.edu>
Date: 2 Apr 91 21:31:46 GMT
References: <1991Mar28.011658.47180@cc.usu.edu>
Lines: 52

In article <1991Mar28.011658.47180@cc.usu.edu>, sl3b4@cc.usu.edu writes:
> Hi all.  I am putting together an AmigaVision project for my workplace. 
> Hopefully if all goes well, they will be impressed and buy some Amigas. ;-)
> But...I have came across two problems, I hope someone out there can lend me
> hand in figuring them out!
> 
> 1.  I want to search a database "Key".  It is a string that is 30 chars.  The
>     problem I have is that when using the "Select Record" icon, it will only
>     match those records where the search string matches the first part of the
>     "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?

This may not be the 'fastest' solution, but it will work.

- Use the select database icon, and allow it to select all of the records.
- Then use the read data icon and bring in your key variable into a variable
  that you will examine
- Use the findstr() function to locate your sub-string.

> 
> 2.  This database is a Logo database for a large business forms producer.  The
>     logos are referenced by a number.  That number also designates an IFF brush
>     with an image of the logo so that you can search the database and find the
>     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
>     require a set path/filename.  Help...This is VERY important to the success 
>     of my getting them to get an Amiga.  They already have a pc with a similar 
>     database (ugly and not user friendly), and I was thinking this would be a
>     snap to do with AmigaVision.  So far, but this one got me.  HELP!

You can use a variable in any of the display or audio icons by place the
variable name inside of brackets.   The only problem is that if the file
is not found, you will not be able to trap the error nicely.  AmigaVision
will simply put up its "I give up" requestor.

> 
> Any help would be appreciated, thoughts, ideas, etc.  Thanks alot in advance!
> 
> John Z.
> SL3B4@cc.usu.edu

 -mark=
     
 +--------+   ==================================================          
 | \/     |   Mark D. Manes   "Mr. AmigaVision,  The 32 bit guy"
 | /\  \/ |   manes@vger.nsu.edu                                        
 |     /  |   (804) 683-2532    "Make up your own mind! - AMIGA"
 +--------+   ==================================================