gerber@buzzer.enet.dec.com (Robert M. Gerber) (10/19/90)
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!
manes@vger.nsu.edu (10/19/90)
In article <1990Oct18.153303@buzzer.enet.dec.com>, gerber@buzzer.enet.dec.com (Robert M. Gerber) writes: > 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. It appears to me that the keys are sorted from first key to last key, whether you select by just one key or all of them. I think the key handling is probably one of the weaker areas in the AmigaVision database functions. > 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.... Actually the primary purpose of keys is to allow you to search the database, not really to 'sort' it. If I remember my dbase correctly, even in it, if you wanted a different sorting you had to use the sort command and send the output to a file. I am hoping that future versions of AmigaVision come up with a 'sort' icon. > > 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? I don't really classify this as a bug, but rather the way the beast works. Perhaps your solution is to have two databases. I realize that is not effiecient, but it is a solution. > > ByTheWay: Has anyone got any AmigaVision applications that they are willing to > share? Most of my AmigaVision applications are not real exciting. I am working on a Cash Register/Inventory Handling system, and just finished a demo for Republic Pictures in CA. > ------------------------------------------------------------------------ > --------- > 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! -mark= +--------+ ================================================== | \/ | Mark D. Manes "Mr. AmigaVision" | /\ \/ | manes@vger.nsu.edu | / | (804) 683-2532 "Make up your own mind! - AMIGA" +--------+ ==================================================