Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!wuarchive!emory!gatech!purdue!haven!decuac!shlump.nac.dec.com!bacchus.pa.dec.com!buzzer.enet.dec.com!gerber
From: gerber@buzzer.enet.dec.com (Robert M. Gerber)
Newsgroups: comp.sys.amiga
Subject: AmigaVision and its database features....
Keywords: AmigaVision, database, bug?
Message-ID: <1990Oct18.153303@buzzer.enet.dec.com>
Date: 18 Oct 90 20:00:42 GMT
Sender: news@wrl.dec.com (News)
Reply-To: gerber@oldjon.enet.dec.com
Organization: Digital Equipment Corporation
Lines: 39


	Last week I picked up version 1.53G of AmigaVision and already have a few
questions about it...

	I set up a database using the facilities in AmigaVision with the following
fields:

	Field	Type	Length	Key
	=======	======	======	===
	System	String	20	#1
	Number	Number	4	#2
	Title	String	48	No

	When I use Key#1 to access the database the records come back sorted properly. 
When I tried using key#2 as the access reference, they were returned in exactly
the same order.

	When I swapped the key ordering,  the database still returned all the records
in the same order when accessing by either key.

	I would have expected the the database would be returned by the referencing Key
and if there were duplicates, then sort by the Key not referenced.  Am I wrong
in this assumption?  I though the purpose of multiple
keys was to allow you to access the database in different orders....

	I am trying to generate two different reports, the first sorted on the first
key, then the second.  The second report I just want sorted on the second key,
with the little bit of duplication on this key sorted by the first key.
Can this be done with AmigaVision?  Is this a bug? A feature?

ByTheWay: Has anyone got any AmigaVision applications that they are willing to
share?
------------------------------------------------------------------------
---------
Robert M. Gerber		  UUCP:	...!decwrl!oldjon.enet!gerber
				  INET:	gerber@oldjon.enet.dec.com

Any opinions represented here are definetly not those of my employer.
Come to think of it, they may not be mine either!